Dynamically changing datagridview

Hi, I have this problem with DataGridView:

Let's say I have a database with two fields: Name and Code, the Name consists words that the starts with the letter "A" and the code represents a unique code for the word. For example: Apple is 1, Airplane is 2 and so on.
I want to display in Datagrid the words and their relative code, but the catch (for me that is), that I want it to dynamically change using "textbox_textchange", for example: If I type "Al" I want only words that start with "Al" to be displayed, if I type "Alr" I want only words that start with "Arg" to be displayed. I got the code for the database, textchange and dataset, but I don't know how to control the datagridview to do it. I want it to narrow the list automatically as I type more letter (like a filter).

Thanks in advance,
Udi

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs16y ago
Accepted answer
I have spent time familiarizing myself with the various classes such as the BindingSource class. I suggest doing that. There are things such as the BindingSource.Filter property that can be very useful.