dropped combobox

[summiyashaheen]

how can i see multiple items in a combobox without clicking on it???

i want to use combobox getting dynamic list from the database on text box text change event. i want to view the complete list as i type characters in the textbox. focus is on textbox but list is updated at every character entry. the complete list must be visible throught the process.

[dip_developer]

how can i see multiple items in a combobox without clicking on it???

i want to use combobox getting dynamic list from the database on text box text change event. i want to view the complete list as i type characters in the textbox. focus is on textbox but list is updated at every character entry. the complete list must be visible throught the process.

first of all ....how can it be possible to see multiple items in a combobox without clicking it.....??? I am extremely confused..............

you can easily use a listbox for that.....

secondly ......
I guess you want to match the pattern of the textbox text with the database table field....you can have it with a sql quey......but without knowing your field type/text pattern/database /language nothing can be told...............
moreover in the textchanged event everytime you enter a character a sql query will be generated.........
so if you are creating a web application(as you did not mention in your question whether its a web or windows application) then the best practise would be to use AJAX........

[summiyashaheen]

i do not want ot use listbox as it takes more space
it is a desktop application
i have a text box n combobox and disabled text box. i enter itemcode in textbox, accordingly itemname must be shown in the combobox, the complete list should be displayed. list should be filtered with every other character inserted into text box, finally one itemname is left in the list, it is selected automatically and its price must be shown in disabled textbox. price is also saved in db. sql server db

[dip_developer]

i do not want ot use listbox as it takes more space
it is a desktop application
i have a text box n combobox and disabled text box. i enter itemcode in textbox, accordingly itemname must be shown in the combobox, the complete list should be displayed. list should be filtered with every other character inserted into text box, finally one itemname is left in the list, it is selected automatically and its price must be shown in disabled textbox. price is also saved in db. sql server db

so what is your problem??? do u want the full coding..?? its not possible here to give you the code.........try to execute exact sql query......and in every character entry in the textbox fire this query........bind your combobox.........but combobox will show only one item.....not the list