c# - Finding a value in a database from a DataGridViewColumn -

i have datagridview want add searching criteria. should setup such it's billing form item saved in table.

so whenever start typing value in datagridviewcolumn named bill, new listbox open, displaying list of items having similar names value entered using %like query.

i don't have issue writing %like query or displaying listview, don't understand how actively use value datagridviewcolumn while it's being entered.

you have create event handler datagridview.currentcelldirtystatechanged uses datagridview.commitedit datagridview. event can make calls necessary query database , create new listview actively, cell value changes (while active).

the msdn article datagridview.commitedit explains well. have make listview addition.