asp.net如何模拟google下拉列表

asp.net如何模拟google下拉列表

用ajax

AutoCompleteExtender控件读取数据库实现自动完成

1 <%@ WebService Language="C#" Class="Demo2_WebService" %>

2

3 using System;

4 using System.Web;

5 using System.Web.Services;
6 using System.Web.Services.Protocols;

7 using System.Data;

8 using System.Data.SqlClient;

9 using System.Configuration;

10

11 [WebService(Namespace = " http://tempuri.org/")]

12 [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

13 [System.Web.Script.Services.ScriptService]

14 public class Demo2_WebService : System.Web.Services.WebService {

15

16 //定义数组保存获取的内容

17 private static string[] autoCompleteWordList = null;

18 //两个参数“prefixText”表示用户输入的前缀，count表示返回的个数

19 [WebMethod]

20 public String[] GetCompleteList(string prefixText, int count)

21 {

22 // 如果数组为空

23 if (autoCompleteWordList == null)

24 {

25 //读取数据库的内容

26 string strSql = "select top(10) C_Name,E_Name from Demo_User where E_Name like'" + prefixText + "%'";

27 DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.CONN_STRING, CommandType.Text, strSql, null);

28

29

30 //读取内容文件的数据到临时数组

31 string[] temp = new string[ds.Tables[0].Rows.Count];

32 int i = 0;

33 foreach (DataRow dr in ds.Tables[0].Rows)

34 {

35 temp[i] = dr["E_Name"].ToString() +"----"+ dr["C_Name"].ToString();

36 i++;

37 }

38 //将临时数组的内容赋给返回数组

39 autoCompleteWordList = temp;

40 }

41 String[] returnValue = new string[count];

42 returnValue = autoCompleteWordList;

43 //返回数据

44 return returnValue;

45 }

46

47 }

48

49

1 <asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager>
2 <table align="center" bgcolor="#c0de98" border="0" cellpadding="0" cellspacing="1" width="99%">
3 <tr>
4 <th colspan="2">
5 AutoCompleteExtender演示</th>
6 </tr>
7 <tr>
8 <td >请输入字母前缀：</td>
9 <td ><asp:TextBox ID="TextBox1" runat="server" Width="200px"></asp:TextBox></td>
10 </tr>
11 <tr>
12 <td> </td>
13 <td ><ajaxToolkit:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" Enabled="true"
14 TargetControlID="TextBox1"
15 ServicePath="Demo2_WebService.asmx"
16 ServiceMethod="GetCompleteList"
17 CompletionSetCount="10"
18 MinimumPrefixLength="1">
19 </ajaxToolkit:AutoCompleteExtender>
20 </td>
21 </tr>
22 </table>

http://www.aspx58.com.cn/Default_AC_View.aspx?ID=156