WCF for ajaxToolkit:AutoCompleteExtender

本文主要是介绍WCF for ajaxToolkit:AutoCompleteExtender，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

今天学习WCF,做了一个练习，最终的效果：

在数据库中创建表，插入数据，写好存储过程：

View Code

SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GOCREATE TABLE [dbo].[Catalog]([Catalog_nbr] [smallint] IDENTITY(1,1) NOT NULL,[CatalogName] [nvarchar](100) NOT NULL,CONSTRAINT [PK_Catalog] PRIMARY KEY CLUSTERED 
([Catalog_nbr] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]GOINSERT INTO [dbo].[Catalog] VALUES 
(N'1120934567'),
(N'1034577856'),
(N'1145324576'),
(N'1034567889'),
(N'Adfgjfghgg'),
(N'ae45654657'),
(N'1dhjyuryr5'),
(N'brt4543w34'),
(N'brsa2346gh'),
(N'345gthu865'),
(N'3uettr43f5'),
(N'dgewqrytr4'),
(N'dgh6876532')GOSET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GO-- =============================================
-- Author:        Insus.NET
-- Create date: 2013-01-18
-- Description:    Get Catalog data for web services。
-- =============================================
CREATE PROCEDURE [dbo].[usp_Catalog_GetCatalogForWcfService]
(@PrefixText NVARCHAR(MAX),@Count INT
)
AS    
DECLARE @W NVARCHAR(MAX) = @PrefixText + '%'
EXECUTE('SELECT TOP (' + @Count + ') [CatalogName],[Catalog_nbr] FROM [dbo].[Catalog] WHERE [CatalogName] LIKE ''' + @w +'''')GO

在站点下，添加一个目录WCF,然后添加一个WCF Service，取名为Catalog.svc

<%@ ServiceHost Language="C#" Debug="true" Service="Insus.NET.Catalog" CodeBehind="~/App_Code/Catalog.cs" %>

上面的HTML注意一下Service属性，它应该包含命名空间与类别，更多参考：http://www.cnblogs.com/insus/archive/2013/01/19/2867629.html

接下来，我们应该看到App_Code目录有两个文件ICatalog接口与Catalog.cs类文件。

ICatalog

using System;
using System.Collections.Generic;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Web;
using System.Text;// NOTE: You can use the "Rename" command on the "Refactor" menu to change the interface name "ICatalog" in both code and config file together.
namespace Insus.NET
{[ServiceContract]public interface ICatalog{[OperationContract][WebInvoke(Method = "POST", ResponseFormat = WebMessageFormat.Json)]List<string> GetCatalog(string prefixText, int count);}
}

Catalog.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Activation;
using System.Text;
using System.Web;
using System.Web.Script.Serialization;// NOTE: You can use the "Rename" command on the "Refactor" menu to change the class name "Catalog" in code, svc and config file together.
namespace Insus.NET
{[AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]public class Catalog : ICatalog{BusinessBase objBusinessBase = new BusinessBase();public List<string> GetCatalog(string prefixText, int count){Parameter[] parameter = { new Parameter ("@PrefixText",SqlDbType.NVarChar,-1,prefixText),new Parameter ("@Count",SqlDbType.Int,4,count)};DataTable objDatTable = objBusinessBase.GetDataToDataSet("usp_Catalog_GetCatalogForWcfService", parameter).Tables[0];List<string> catalog = new List<string>();foreach (DataRow dataRow in objDatTable.Rows){string item = AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(dataRow["CatalogName"].ToString(),dataRow["Catalog_nbr"].ToString());catalog.Add(item);}return catalog;}}
}

写好接口与类别之后，在站点添加一个.aspx，如Default.aspx:

View Code

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server"><title></title>
</head>
<body><form id="form1" runat="server"><asp:ScriptManager ID="ScriptManager1" runat="server"></asp:ScriptManager><asp:UpdatePanel ID="UpdatePanel1" runat="server"><ContentTemplate>Catalog:<asp:TextBox ID="TextBoxCatalog" runat="server"></asp:TextBox><ajaxToolkit:AutoCompleteExtender ServiceMethod="GetCatalog"MinimumPrefixLength="1" ServicePath="~/WCF/Catalog.svc"TargetControlID="TextBoxCatalog"ID="AutoCompleteExtender1" runat="server" FirstRowSelected="false"></ajaxToolkit:AutoCompleteExtender></ContentTemplate></asp:UpdatePanel></form>
</body>
</html>

ok,我们可以试运行一下看看。此时看到的，没有任何效果喔，为何，难道上面写的代码有错误？

哦，原来我们少了在Web.config配置<system.serviceModel>，Insus.NET已经配置好，参考就是了：

Web.config

<?xml version="1.0"?><!--For more information on how to configure your ASP.NET application, please visithttp://go.microsoft.com/fwlink/?LinkId=169433--><configuration><connectionStrings><add name="InsusConnectionString" connectionString="Server=127.0.0.1\SQLSERVER2008R2;Initial Catalog=InsusSite;User ID=siteconnlogin;Password=aa43$98;Packet Size=8192;Max Pool Size=1000;" providerName="System.Data.SqlClient"/></connectionStrings><system.web><compilation debug="false" targetFramework="4.0" /><pages><controls><add namespace="AjaxControlToolkit" assembly="AjaxControlToolkit" tagPrefix="ajaxToolkit"/></controls></pages></system.web><system.serviceModel><behaviors><endpointBehaviors><behavior name="CatalogAspNetAjaxBehavior"><enableWebScript /></behavior>      </endpointBehaviors><serviceBehaviors><behavior name="CatalogBehavior"><serviceMetadata httpGetEnabled="true" /><serviceDebug includeExceptionDetailInFaults="true" /></behavior>        <behavior name=""><serviceMetadata httpGetEnabled="true" /><serviceDebug includeExceptionDetailInFaults="false" /></behavior></serviceBehaviors></behaviors><serviceHostingEnvironment aspNetCompatibilityEnabled="true"multipleSiteBindingsEnabled="true" /><services><service behaviorConfiguration="CatalogBehavior" name="Insus.NET.Catalog"><endpoint address="" binding="webHttpBinding" contract="Insus.NET.ICatalog" behaviorConfiguration="CatalogAspNetAjaxBehavior"><identity><dns value="localhost"/></identity></endpoint><endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange"/></service>    </services></system.serviceModel>
</configuration>