my program is developed for a Store, in which it contains products , with each product there is an id or code specified only for it.
what i need when the "data entry" or "User" begins to enter a code for some product - when he typing just first numbers of the code of the product- he gets a list of all other product code the begins with these few numbers, and it decreases by typing more numbers until the desired product code appear.
" this can be called Filter"

i need this list to be appeared even if we type only one number

for example:

for product a,b,c,d
where 1200,1204,1245,1320 ,respectively
so when i begin to write a code in " a textbox control" .
so if i type:

 1
i get all product in the list

 12
i get "1200,1204,1245" ,..etc.

I HOPE IT IS CLEAR FOR YOU
.

u can show a seprate list box next to your text box on the key press event and according the key get the all the matching values frm the database..." LIKE 'a%'"
This is tried.. and tested

As "This is tried.. and tested"

please provide me with a sample code

You cannot list in the TextBox control but you can do the same in ComboBox control which is a combination of "TextBox" Control where you can type in the values and "ListBox" control which displays the list.

For that you can find a nice article at the site

http://www.kbalertz.com/Feedback_319946.aspx


It is not how much we do,
but how much love we put in the doing.

-Mother Theresa