在ASP Classic + SQL Server上自动完成/建议 [英] auto complete/suggest on asp classic + sql server

问题描述

Hii ..

我有这样的问题..

我想使用自动完成/建议的箱子列表，其中来自sql server的数据

Hii..

i have problem like this..

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

推荐答案

huntuajah写道:

huntuajah wrote:

我要使用自动完成/建议的条板箱列表，其中来自sql server的数据

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

那么，您尝试了什么?问题出在哪里?

如果您尚未开始...，请在google上查找有关autosuggest的文章数量.或者您也可以在这里查看CodeProject.可能不在ASP中，但肯定不在ASP.NET中.

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.

(1)您可以使用XMLHTTP对象从浏览器创建异步http请求.这将使您可以访问数据库服务器并以字符串形式检索值.您应该将此字符串作为连接字符串，并用一些预定义字符分隔.例如，如果您希望A，B，C作为自动完成建议项，则假设"|"，则字符串将为"A | B | C"是用作分隔符的预定义字符.

请参考此处以获取有关如何从浏览器使用XMLHTTP对象的更多帮助
http://www.w3schools.com/XML/xml_http.asp [ [ ]

(2)一旦接收到值，就需要拆分(取决于在服务器中并置项目时使用的字符)并在div中显示.您动态创建的该div，必须在文本框中正确标明.

希望有帮助，:thumbsup:

(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:

我还没有尝试过，但是我一直在Google上搜索像

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.

这篇关于在ASP Classic + SQL Server上自动完成/建议的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！