Click here to Skip to main content
15,895,011 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hii..

i have problem like this..

i want crate list with auto complete/suggest where data from sql server
Posted

huntuajah wrote:
i want crate list with auto complete/suggest where data from sql server

So, what have you tried? Where's the issue?

If you have not yet started... look for number of articles present on autosuggest in google.. or you can just look here at CodeProject. Might not be in ASP but surely in ASP.NET.
 
Share this answer
 
(1)You can use the XMLHTTP object to create asynchronous http request from browser. This will allow you to reach databse server and retrive values as a string. You should get this string as a concatenated string separated with some predefined character. For example, if you want A,B,C as your autcomplete suggestion items then you would get the string as "A|B|C", assuming "|" is predefined character used as separator.

Please refer here for more help about how to use XMLHTTP object from browser
http://www.w3schools.com/XML/xml_http.asp[^]
[]

(2)Once you receive the values, you need to split (depending upon what character you have used while concatenating items in server) and display in div. This div you have create dynamically and must be prperly ailgned with the text box.

hope that helps, :thumbsup:
 
Share this answer
 
I have not tried it, but I've been searching on google for autosuggest like Auto-complete Control
and found by using javascript where data are stored in javascript variables are not taken from a database sql server.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900