blocks|key|2968601|text|你可以使用这个库，它很简单，有好的代码|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2968602|http://www.asp.net/ajaxlibrary/AjaxControlToolkitSampleSite/AutoComplete/AutoComplete.aspx|offset|length|2968603|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|2I|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

You can use this library it's very easy a with good code

<a href="http://www.asp.net/ajaxlibrary/AjaxControlToolkitSampleSite/AutoComplete/AutoComplete.aspx" rel="nofollow">http://www.asp.net/ajaxlibrary/AjaxControlToolkitSampleSite/AutoComplete/AutoComplete.aspx</a>

blocks|key|2829535|text|首先，我们将使用将使用ASP.NET+Web+Service的|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2829536|(假设是Name.asmx)。|2829537|添加对Jquery+UI+CSS文件的引用|2829538|<link+href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/themes/base/jquery-ui.css"+rel="stylesheet"+type="text/css"/>|code-block|syntax|javascript|2829539|现在添加对Jquery+library的引用|2829540|<script+type="text/javascript"+src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"></script>|2829541|添加对Jquery+UI的引用|2829542|<script+type="text/javascript"+src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/jquery-ui.min.js"></script>+|2829543|假设您有一个包含auto类的textbox|2829544|<asp:TextBox+ID="tbAuto"+class="auto"+runat="server">
</asp:TextBox>|2829545|现在，我们将编写一个脚本，将在textbox中键入的每个字母传递给我们的Web+Service+(Name.asmx)。|2829546|<script+type="text/javascript">
$(function()+{
++++$(".auto").autocomplete({
++++++++source:+function(request,+response)+{
++++++++++++$.ajax({
++++++++++++++++url:+"Name.asmx/FetchNames",
++++++++++++++++data:+"{+'name':+'"+%2B+request.term+%2B+"'+}",
++++++++++++++++dataType:+"json",
++++++++++++++++type:+"POST",
++++++++++++++++contentType:+"application/json;+charset=utf-8",
++++++++++++++++dataFilter:+function(data)+{+return+data;+},
++++++++++++++++success:+function(data)+{
++++++++++++++++++++response($.map(data.d,+function(item)+{
++++++++++++++++++++++++return+{
++++++++++++++++++++++++++++value:+item.Name
++++++++++++++++++++++++}
++++++++++++++++++++}))
++++++++++++++++},
++++++++++++++++error:+function(XMLHttpRequest,+textStatus,+errorThrown)+{
++++++++++++++++++++alert(textStatus);
++++++++++++++++}
++++++++++++});
++++++++},
++++++++minLength:+2
++++});
});
</script>|2829547|最后是C#中的Web+Service|2829548|[WebMethod]
public+List<string>+FetchNames(string+name)
{
//Write+your+query+to+get+names+that+begin+with+the+letter+passed+as+parameter+and+++++return+results
//Remember+return+the+results+by+converting+it+to+List.
}|2829549|希望这能有所帮助。|2829550|如果你有问题，请回复。|2829551|编辑：|BOLD|2829552|下面是查询。|2829553|SqlDataReader+rdr+=+null;
SqlConnection+con+=+null;
SqlCommand+cmd+=+null;
List<string>+empName=new+List<string>();

++++++++++++try
++++++++++++{
++++++++++++++++//+Open+connection+to+the+database
++++++++++++++++string+ConnectionString+=+"server=yourservername;uid=sa;"%2B
++++++++++++++++++++"pwd=yourpswd;+database=yourdatabase";
++++++++++++++++con+=+new+SqlConnection(ConnectionString);
++++++++++++++++con.Open();

++++++++++++++++//+Set+up+a+command+with+the+given+query+and+associate
++++++++++++++++//+this+with+the+current+connection.
++++++++++++++++string+CommandText+=+"SELECT+FirstName"+%2B
+++++++++++++++++++++++++++++++++++++"++FROM+Employees"+%2B
+++++++++++++++++++++++++++++++++++++"+WHERE+(FirstName+LIKE+%2Bname%25)";
++++++++++++++++cmd+=+new+SqlCommand(CommandText);
++++++++++++++++cmd.Connection+=+con;


++++++++++++++++//+Execute+the+query
++++++++++++++++rdr+=+cmd.ExecuteReader();


++++++++++++++++while(rdr.Read())
++++++++++++++++{
+++++++++++++++++++empName.Add(rdr["FirstName"].ToString());
++++++++++++++++}
++++++++++++++return+empName;
++++++++++++}
++++++++++++catch(Exception+ex)
++++++++++++{
++++++++++++++++//+Print+error+message

++++++++++++}|2829554|注意:我还没有对此进行测试，但我认为只要根据您的需要做一些更改，它就会工作得很好！我还要试着改进这段代码|2829555|entityMap^0|B|J|0|4|9|0|3|D|0|0|5|E|0|0|3|9|0|0|8|4|0|0|F|7|10|B|1C|B|0|0|3|2|7|B|0|0|0|0|0|3|0|0|0|0^^$0|@$1|2|3|4|5|6|7|1N|8|@$9|1O|A|1P|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|1Q|8|@$9|1R|A|1S|B|C]]|D|@]|E|$]]|$1|H|3|I|5|6|7|1T|8|@$9|1U|A|1V|B|C]]|D|@]|E|$]]|$1|J|3|K|5|L|7|1W|8|@]|D|@]|E|$M|N]]|$1|O|3|P|5|6|7|1X|8|@$9|1Y|A|1Z|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|L|7|20|8|@]|D|@]|E|$M|N]]|$1|S|3|T|5|6|7|21|8|@$9|22|A|23|B|C]]|D|@]|E|$]]|$1|U|3|V|5|L|7|24|8|@]|D|@]|E|$M|N]]|$1|W|3|X|5|6|7|25|8|@$9|26|A|27|B|C]]|D|@]|E|$]]|$1|Y|3|Z|5|L|7|28|8|@]|D|@]|E|$M|N]]|$1|10|3|11|5|6|7|29|8|@$9|2A|A|2B|B|C]|$9|2C|A|2D|B|C]|$9|2E|A|2F|B|C]]|D|@]|E|$]]|$1|12|3|13|5|L|7|2G|8|@]|D|@]|E|$M|N]]|$1|14|3|15|5|6|7|2H|8|@$9|2I|A|2J|B|C]|$9|2K|A|2L|B|C]]|D|@]|E|$]]|$1|16|3|17|5|L|7|2M|8|@]|D|@]|E|$M|N]]|$1|18|3|19|5|6|7|2N|8|@]|D|@]|E|$]]|$1|1A|3|1B|5|6|7|2O|8|@]|D|@]|E|$]]|$1|1C|3|1D|5|6|7|2P|8|@$9|2Q|A|2R|B|1E]]|D|@]|E|$]]|$1|1F|3|1G|5|6|7|2S|8|@]|D|@]|E|$]]|$1|1H|3|1I|5|L|7|2T|8|@]|D|@]|E|$M|N]]|$1|1J|3|1K|5|6|7|2U|8|@]|D|@]|E|$]]|$1|1L|3|-4|5|6|7|2V|8|@]|D|@]|E|$]]]|1M|$]]

Firstly we will use <a href="http://jqueryui.com/demos/autocomplete/" rel="nofollow">Jquery UI Auocomplete</a> that will consume <code>ASP.NET Web Service</code>

(Let's say <code>Name.asmx</code>). 

Add reference to <code>Jquery UI CSS</code> file

<pre><code>&lt;link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/&gt;
</code></pre>

Now add reference to <code>Jquery library</code>

<pre><code>&lt;script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.4.2/jquery.min.js"&gt;&lt;/script&gt;
</code></pre>

Add reference to the <code>Jquery UI</code>

<pre><code>&lt;script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8.1/jquery-ui.min.js"&gt;&lt;/script&gt; 
</code></pre>

Let's say you have a textbox with class <code>auto</code>

<pre><code>&lt;asp:TextBox ID="tbAuto" class="auto" runat="server"&gt;
&lt;/asp:TextBox&gt;
</code></pre>

Now we will write a script that will pass every single letter typed in the <code>textbox</code> to our <code>Web Service</code> <code>(Name.asmx)</code>.

<pre><code>&lt;script type="text/javascript"&gt;
$(function() {
 $(".auto").autocomplete({
 source: function(request, response) {
 $.ajax({
 url: "Name.asmx/FetchNames",
 data: "{ 'name': '" + request.term + "' }",
 dataType: "json",
 type: "POST",
 contentType: "application/json; charset=utf-8",
 dataFilter: function(data) { return data; },
 success: function(data) {
 response($.map(data.d, function(item) {
 return {
 value: item.Name
 }
 }))
 },
 error: function(XMLHttpRequest, textStatus, errorThrown) {
 alert(textStatus);
 }
 });
 },
 minLength: 2
 });
});
&lt;/script&gt;
</code></pre>

Finally here is the <code>Web Service</code> in <code>C#</code>

<pre><code>[WebMethod]
public List&lt;string&gt; FetchNames(string name)
{
//Write your query to get names that begin with the letter passed as parameter and return results
//Remember return the results by converting it to List.
}
</code></pre>

Hope it will help.

Reply in case you have issues.

EDITED:

Here is the query.

<pre><code>SqlDataReader rdr = null;
SqlConnection con = null;
SqlCommand cmd = null;
List&lt;string&gt; empName=new List&lt;string&gt;();

 try
 {
 // Open connection to the database
 string ConnectionString = "server=yourservername;uid=sa;"+
 "pwd=yourpswd; database=yourdatabase";
 con = new SqlConnection(ConnectionString);
 con.Open();

 // Set up a command with the given query and associate
 // this with the current connection.
 string CommandText = "SELECT FirstName" +
 " FROM Employees" +
 " WHERE (FirstName LIKE +name%)";
 cmd = new SqlCommand(CommandText);
 cmd.Connection = con;


 // Execute the query
 rdr = cmd.ExecuteReader();


 while(rdr.Read())
 {
 empName.Add(rdr["FirstName"].ToString());
 }
 return empName;
 }
 catch(Exception ex)
 {
 // Print error message

 }
</code></pre>

Note:I have not tested this , but I think by doing few changes as per your needs it will work fine! Also try and improve this code

blocks|key|5621701|text|您可以使用jquery+autocomplete+api：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5621702|$(document).ready(function+()+{
++$("#<%25=ApplicationSearchResult.ClientID+%25>").autocomplete({+//applicationSearchResult+is+your+textbox
++source:+function+(request,+response)+{
+++$.ajax({
+++type:+"POST",
+++url:+"Dashboard.aspx/GetTreeNodesByText",+//+the+function+you+have+to+call+to+bring+you+the+data
+++data:+"{'text':+'"+%2B+request.term+%2B+"'}",+//+the+letter+the+user+entered+in+the+textbox
+++contentType:+"application/json;+charset=utf-8",
+++dataType:+"json",
+++success:+function+(data)+{
+++response(data.d);
+++}
+++});
+++},
+++minLength:+1
+++});
+++});|code-block|syntax|javascript|5621703|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

you can use jquery autocomplete api :

<pre><code>$(document).ready(function () {
 $("#&lt;%=ApplicationSearchResult.ClientID %&gt;").autocomplete({ //applicationSearchResult is your textbox
 source: function (request, response) {
 $.ajax({
 type: "POST",
 url: "Dashboard.aspx/GetTreeNodesByText", // the function you have to call to bring you the data
 data: "{'text': '" + request.term + "'}", // the letter the user entered in the textbox
 contentType: "application/json; charset=utf-8",
 dataType: "json",
 success: function (data) {
 response(data.d);
 }
 });
 },
 minLength: 1
 });
 });
</code></pre>

I've a textbox for entering employeename.When an user types the employeename,i wanted to list all the employees from database starting with that typed letter,just like a dropdownlist

I dont want any third party control.Is there any easier and understandable way for doing this??

how to create textbox list control?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个用于输入employeename.When的文本框，用户键入员工名，我想列出数据库中以键入的字母开头的所有员工，就像下拉列表一样我不想要任何第三方control.Is有任何更容易和理解的方式来做这件事？

问如何创建textbox列表控件？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何创建textbox列表控件？EN