combobox usage with sql statement

I have datagridview , combobox. And I completely set the datasource. I addet some items into combobox. I want to execute the sql statement when I click the items in combobox but it does not work.

sql statement for fillby :

select * from table 1 where abc like ' " &combobox1& " '

and the click event of combobox1 is :

me.table1tableadapter.fillby(me.dataset.table1)

it doesn't work.. How can I do this ?

[467 byte] By [jacabo2006] at [2007-12-24]