AjaxControlToolkit AutoCompleteExtender控件演示
发布时间:2020-12-16 00:43:19 所属栏目:百科 来源:网络整理
导读:原本程序是一个查询文本框,现用户要求改程序,要如google或baidu输入一样,有自动完成功能。下图是已经完成的效果: 实现使用了Web Service技术与Ajax的 AutoCompleteExtender 的控件。在数据库中,写好存储过程: CREATE PROCEDURE [ dbo ] . [ usp_Fqa_Lo
原本程序是一个查询文本框,现用户要求改程序,要如google或baidu输入一样,有自动完成功能。下图是已经完成的效果: 实现使用了Web Service技术与Ajax的AutoCompleteExtender的控件。在数据库中,写好存储过程:
CREATE
PROCEDURE
[
dbo
]
.
[
usp_Fqa_LotNumberCompletionList
]
( @PrefixText NVARCHAR ( 4000 ), @TopCount INT ) AS DECLARE @W NVARCHAR ( 4000 ) = @PrefixText + ' % ' EXECUTE ( ' SELECTTOP ' + @TopCount + ' [LotNumber]FROM[dbo].[Fqa]WHERE[IsSubmit]=1AND[LotNumber]LIKE ''' + @w + '''' ) 创建一个Web Service,执行存储过程:
using
System;
using System.Collections; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.Services; /// <summary> /// SummarydescriptionforFqaLotNumberService /// </summary> namespace Insus.NET { [WebService(Description = " FqaLotNumberService " ,Name = " FqaLotNumberService " ,Namespace = http://xxx.xxx.com/WebServices/ )] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] // ToallowthisWebServicetobecalledfromscript,usingASP.NETAJAX,uncommentthefollowingline. [System.Web.Script.Services.ScriptService] public class FqaLotNumberService:System.Web.Services.WebService { BusinessBaSEObjBusinessBase = new BusinessBase(); public FqaLotNumberService() { // Uncommentthefollowinglineifusingdesignedcomponents // InitializeComponent(); } [WebMethod] public string []GetFqaLotNumber( string prefixText, int count) { Parameter[]parameter = { new Parameter( " @PrefixText " ,SqlDbType.NVarChar, 4000 ,prefixText), new Parameter( " @TopCount " ,SqlDbType.Int, 4 ,count) }; DataTableLotNumberTable = objBusinessBase.GetDataToDataSet( " usp_Fqa_LotNumberCompletionList " ,parameter).Tables[ 0 ]; ArrayListarray = new ArrayList(); foreach (DataRowdataRow in LotNumberTable.Rows) { array.Add(dataRow[ " LotNumber " ].ToString()); } return ( string [])array.ToArray( typeof ( string )); } } }
.aspx:
批号:
<
asp:TextBox
ID
="txtLotNumber"
runat
="server"
></
asp:TextBox
>
< asp:Button ID ="ButtonSearch" runat ="server" OnClick ="ButtonSearch_Cliek" Text ="Search" /> < ajaxToolkit:AutoCompleteExtender ID ="AutoCompleteExtender1" runat ="server" MinimumPrefixLength ="1" TargetControlID ="txtLotNumber" ServiceMethod ="GetFqaLotNumber" ServicePath ="~/WebServices/FqaLotNumberService.asmx" CompletionSetCount ="10" > </ ajaxToolkit:AutoCompleteExtender >
(编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |