how to create suggction box in asp.net?

Archived in the category: asp net popup
Posted by Kristen Meyers on 18 Nov 09 -

hi all,

i want to create popupbox it will popup when i type character in textfield and showing the values staring with that letter from the database it apper down the textbox .is it possible

can anyone give me any hint?

thanks
eldhose
i need to use div to show the box
<div>
<div> node1</>
<div >node2</>
</div>
help me to move up and down key through the item in the div and i need to show the div only onfocus in the sle onblur it should be hide

how it can be done ?
please help

This SQL returns all Names starting with the uppercase letter L from table tblAddress. This SQL may be slightly different from database to database. I tested it out with MS Access.

select * from tblAddress where name like ‘L*’

With the result of this SQL you could i.e. populate a combobox. If you do this in Access, then you hardly have anything to do. You just modify your datasource in the VBA code to become a SQL statement like the above one.The SQL would just change the i.e. ‘L*’ to ‘Li*’ according to the input you want to capture in the Change event of your text box.

I hope that helped

powered by Yahoo Answers

One comment for “how to create suggction box in asp.net?”

1
MichaelInScarborough

This SQL returns all Names starting with the uppercase letter L from table tblAddress. This SQL may be slightly different from database to database. I tested it out with MS Access.

select * from tblAddress where name like ‘L*’

With the result of this SQL you could i.e. populate a combobox. If you do this in Access, then you hardly have anything to do. You just modify your datasource in the VBA code to become a SQL statement like the above one.The SQL would just change the i.e. ‘L*’ to ‘Li*’ according to the input you want to capture in the Change event of your text box.

I hope that helped
References :

November 18th, 2009 at 7:40 am

Laeave a Reply