DE:Visual Web Developer 2008 Express Edition

DB:Access 2007

到http://www.asp.net/ajax/downloads/下载AJAX Control Toolkit，将AjaxControlToolkit.dll拷贝到项目的bin目录下，在工具栏中引入。

在Web.config的<controls>...</controls>里加上

[xhtml]view plaincopy

<addtagPrefix="ajaxToolkit"namespace="AjaxControlToolkit"assembly="AjaxControlToolkit"/>


WebService的代码：（aaa.asmx）


[vb]view plaincopy

<WebMethod()>_

<System.Web.Script.Services.ScriptMethod()>_

PublicFunctionGetCompletionList(ByValprefixTextAsString,ByValcountAsInteger)AsString()

DimmyConnectionAsOleDbConnection

DimmyCommandAsOleDbCommand

DimdbnameAsString

dbname=Server.MapPath("location.accdb")

myConnection=NewOleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;DATASource="&dbname)

myConnection.Open()

DimlistAsNewList(OfString)

myCommand=NewOleDbCommand("SELECTDISTINCT(columnName)FROMtableNameWHEREcolumnNameLIKE'"+prefixText&"%"+"'",myConnection)

DimreaderAsOleDbDataReader=myCommand.ExecuteReader()

DoWhilereader.Read

list.Add(reader.GetString(0))

Loop

Returnlist.ToArray()

EndFunction


FORM中的代码：（aaa.aspx）


[xhtml]view plaincopy

<asp:TextBoxID="txtNo"runat="server"autopostback="true"Columns="50"></asp:TextBox>

<ajaxToolkit:AutoCompleteExtenderID="txtNo_AutoCompleteExtender"runat="server"Enabled="True"ServiceMethod="GetCompletionList"ServicePath="aaa.asmx"TargetControlID="txtNo"MinimumPrefixLength="1"EnableCaching="true">

</ajaxToolkit:AutoCompleteExtender>


以上即可。

AJAX日期控件的使用也很方便，如：


[xhtml]view plaincopy

<asp:TextBoxID="txtDate"runat="server"Columns="24"></asp:TextBox>

<ajaxToolkit:CalendarExtenderID="txtDate_CalendarExtender"runat="server"Enabled="True"TargetControlID="txtDate">

</ajaxToolkit:CalendarExtender>


如果您觉得此篇文章对您有帮助，欢迎关注微信公众号：大禹编程，您的支持是对我最大的鼓励！共同学习，共同进步:)