Ajax 自动提示 AutoCompleteExtender代码,Asp.Net代码库,德仔网

代码语言
代码分类
【Asp.Net】 Ajax 自动提示 AutoCompleteExtender
作者:曾祥展 / 发布于2011/3/15/ 861
<div>
<font color="#ff8000" size="4">html:</font>
<pre class="code"><span style="background: rgb(255,238,98)"><%<span style="color: blue">@ </span><span style="color: rgb(163,21,21)">Page </span><span style="color: red">Language</span><span style="color: blue">="C#" </span><span style="color: red">AutoEventWireup</span><span style="color: blue">="true"  </span><span style="color: red">CodeFile</span><span style="color: blue">="Default.aspx.cs" </span><span style="color: red">Inherits</span><span style="color: blue">="_Default" </span><span style="background: rgb(255,238,98)">%>
<%<span style="color: blue">@ </span><span style="color: rgb(163,21,21)">Register </span><span style="color: red">Assembly</span><span style="color: blue">="AjaxControlToolkit" </span><span style="color: red">Namespace</span><span style="color: blue">="AjaxControlToolkit" </span><span style="color: red">TagPrefix</span><span style="color: blue">="cc1" </span><span style="background: rgb(255,238,98)">%>
</span><span style="color: blue"><!</span><span style="color: rgb(163,21,21)">DOCTYPE </span><span style="color: red">html PUBLIC </span><span style="color: blue">"-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<</span><span style="color: rgb(163,21,21)">html </span><span style="color: red">xmlns</span><span style="color: blue">="http://www.w3.org/1999/xhtml">
<</span><span style="color: rgb(163,21,21)">head </span><span style="color: red">runat</span><span style="color: blue">="server">
<</span><span style="color: rgb(163,21,21)">title</span><span style="color: blue">></</span><span style="color: rgb(163,21,21)">title</span><span style="color: blue">>
</</span><span style="color: rgb(163,21,21)">head</span><span style="color: blue">>
<</span><span style="color: rgb(163,21,21)">body</span><span style="color: blue">>
<</span><span style="color: rgb(163,21,21)">form </span><span style="color: red">id</span><span style="color: blue">="form1" </span><span style="color: red">runat</span><span style="color: blue">="server">
<</span><span style="color: rgb(163,21,21)">div</span><span style="color: blue">>
<</span><span style="color: rgb(163,21,21)">asp</span><span style="color: blue">:</span><span style="color: rgb(163,21,21)">ScriptManager </span><span style="color: red">ID</span><span style="color: blue">="ScriptManager1" </span><span style="color: red">runat</span><span style="color: blue">="server">
</</span><span style="color: rgb(163,21,21)">asp</span><span style="color: blue">:</span><span style="color: rgb(163,21,21)">ScriptManager</span><span style="color: blue">>
<</span><span style="color: rgb(163,21,21)">div</span><span style="color: blue">>
<</span><span style="color: rgb(163,21,21)">asp</span><span style="color: blue">:</span><span style="color: rgb(163,21,21)">TextBox </span><span style="color: red">ID</span><span style="color: blue">="TextBox1" </span><span style="color: red">runat</span><span style="color: blue">="server"></</span><span style="color: rgb(163,21,21)">asp</span><span style="color: blue">:</span><span style="color: rgb(163,21,21)">TextBox</span><span style="color: blue">>
<</span><span style="color: rgb(163,21,21)">cc1</span><span style="color: blue">:</span><span style="color: rgb(163,21,21)">AutoCompleteExtender </span><span style="color: red">ID</span><span style="color: blue">="AutoCompleteExtender1" </span><span style="color: red">runat</span><span style="color: blue">="server" </span><span style="color: red">TargetControlID</span><span style="color: blue">="TextBox1"
</span><span style="color: red">MinimumPrefixLength</span><span style="color: blue">="1" </span><span style="color: red">ServiceMethod</span><span style="color: blue">="GetProductName" </span><span style="color: red">ServicePath</span><span style="color: blue">="WebService.asmx">
</</span><span style="color: rgb(163,21,21)">cc1</span><span style="color: blue">:</span><span style="color: rgb(163,21,21)">AutoCompleteExtender</span><span style="color: blue">>
</</span><span style="color: rgb(163,21,21)">div</span><span style="color: blue">>
</</span><span style="color: rgb(163,21,21)">div</span><span style="color: blue">>
</</span><span style="color: rgb(163,21,21)">form</span><span style="color: blue">>
</</span><span style="color: rgb(163,21,21)">body</span><span style="color: blue">>
</</span><span style="color: rgb(163,21,21)">html</span><span style="color: blue">>
</span></pre>


<font color="#ff8000" size="4">WebService.cs:</font>
<pre class="code"><span style="color: blue">using </span>System;
<span style="color: blue">using </span>System.Collections.Generic;
<span style="color: blue">using </span>System.Linq;
<span style="color: blue">using </span>System.Web;
<span style="color: blue">using </span>System.Web.Services;
<span style="color: blue">using </span>System.Data.SqlClient;
<span style="color: blue">using </span>System.Data;
<span style="color: blue">using </span>System.Web.Script.Services;<span style="color: green">//关键程序集引用
</span><span style="color: gray">/// <summary>
///</span><span style="color: green">WebService 的摘要说明
</span><span style="color: gray">/// </summary>
</span>[<span style="color: rgb(43,145,175)">WebService</span>(Namespace = <span style="color: rgb(163,21,21)">"http://tempuri.org/"</span>)]
[<span style="color: rgb(43,145,175)">WebServiceBinding</span>(ConformsTo = <span style="color: rgb(43,145,175)">WsiProfiles</span>.BasicProfile1_1)]
<span style="color: green">//若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消对下行的注释。
</span>[System.Web.Script.Services.<span style="color: rgb(43,145,175)">ScriptService</span>]
<span style="color: blue">public class </span><span style="color: rgb(43,145,175)">WebService </span>: System.Web.Services.<span style="color: rgb(43,145,175)">WebService </span>{
<span style="color: blue">public </span>WebService () {
<span style="color: green">//如果使用设计的组件，请取消注释以下行
//InitializeComponent();
</span>}
[<span style="color: rgb(43,145,175)">WebMethod</span>]
[<span style="color: rgb(43,145,175)">ScriptMethod</span>]
<span style="color: blue">public string</span>[] GetProductName(<span style="color: blue">string </span>prefixText, <span style="color: blue">int </span>count)
{
<span style="color: rgb(43,145,175)">List</span><<span style="color: blue">string</span>> suggestions = <span style="color: blue">new </span><span style="color: rgb(43,145,175)">List</span><<span style="color: blue">string</span>>();<span style="color: green">//声明一泛型集合
</span><span style="color: rgb(43,145,175)">SqlConnection </span>con = <span style="color: blue">new </span><span style="color: rgb(43,145,175)">SqlConnection</span>(<span style="color: rgb(163,21,21)">"server=JUQI;database=NorthWind;uid=sa;pwd=sa;"</span>);
con.Open();
<span style="color: rgb(43,145,175)">SqlCommand </span>com = <span style="color: blue">new </span><span style="color: rgb(43,145,175)">SqlCommand</span>(<span style="color: rgb(163,21,21)">"select distinct productname from Products where productname like @prefixname order by productname"</span>, con);
com.Parameters.Add(<span style="color: rgb(163,21,21)">"@prefixname"</span>, <span style="color: rgb(43,145,175)">SqlDbType</span>.NVarChar).Value = prefixText + <span style="color: rgb(163,21,21)">"%"</span>;
<span style="color: rgb(43,145,175)">SqlDataReader </span>sdr = com.ExecuteReader();
<span style="color: blue">while </span>(sdr.Read())
{
suggestions.Add(sdr.GetString(0));
}
sdr.Close();
con.Close();
<span style="color: blue">return </span>suggestions.ToArray();
}
}</pre>
</div>
评论列表
本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。
试试其它关键字
　AutoCompleteExtender　
同语言下
可能有用的
曾祥展贡献的其它代码(13)