| Author: Pascal 12 Jan 2009 | Member Level: Gold | Rating:  Points: 2 |
Can you please confirm whether its a dropdownlist or listbox? On page load you will be loading all the data and display it as the user types it right?
|
| Author: Tejinder Singh Barnala 12 Jan 2009 | Member Level: Gold | Rating: Points: 2 |
just go like that
create proc search(@data varchar(100))
as
select * from yourtablename where yourcolumnname like @data +'%'
hope it will help you
Many Thanks
Tejinder Singh Barnala
/*I have the simplest tastes. I am always satisfied with the best*/
|
| Author: pernia khan 12 Jan 2009 | Member Level: Bronze | Rating: Points: 0 |
actually its list box plzzzzzz explain me in detail
|
| Author: Nitin Srivastava 12 Jan 2009 | Member Level: Gold | Rating: Points: 2 |
please try to solve ur prob in three step.
First: Create a sp as script given by Tejinder Singh
Second : call this SP on the key down event of the text box.
Display the result of the SP in the list box.
Hope this way u can solve your prob.
|