Shulou(Shulou.com)06/03 Report--

This article mainly introduces how to use web services to achieve automatic text box expansion, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor with you to understand.

In the past, to write Ajax's AutoCompleteExtender function, you need to write WCF Service or Web Service data sources. But in a system, many text boxes want to use the function of AutoComplete. It is impossible for us to write a lot of Service, such as some smaller data. Do we have an alternative method? That's for sure. In the following demonstration, Insus.NET implements the AutoCompete extender function of the text box without writing Service.

First of all, get the number from the database, you can write SQL statements, or write stored procedures, the following is to get domain user information, imitating the effect of Outlook input recipient.

The information in the [ActiveDirectoryInfo] table is periodically synchronized with the domain's active directory.

The copy code is as follows:

Usp_ActiveDirectoryInfo_GetDisplayNameForService

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =

-- Author: Insus.NET

Create date: 2013-03-28

-- Description: Get dissplay name form web service

-- =

CREATE PROCEDURE [dbo]. [usp_ActiveDirectoryInfo_GetDisplayNameForService]

(

@ PrefixText NVARCHAR (MAX)

@ Count INT

)

AS

DECLARE @ W NVARCHAR (MAX) = @ PrefixText +'%'

EXECUTE ('SELECT TOP (' + @ Count +') [displayName] FROM [dbo]. [ActiveDirectoryInfo] WHERE [displayName] LIKE''+ @ w +'')

In the logical layer, we write a category to interact with the data layer:

The copy code is as follows:

Using System

Using System.Collections.Generic

Using System.Data

Using System.Linq

Using System.Web

/ / /

/ Summary description for ActiveDirectoryInfo

/ / /

Namespace Insus.NET

{

Public class ActiveDirectoryInfo

{

BusinessBase objBusinessBase = new BusinessBase ()

Public ActiveDirectoryInfo ()

{

/ /

/ / TODO: Add constructor logic here

/ /

}

Public DataTable GetDisplayName (string prefixText,int count)

{

Parameter [] parameter = {

New Parameter (@ PrefixText, SqlDbType.NVarChar,-1,prefixText)

New Parameter (@ Count, SqlDbType.Int,4,count)

}

Return objBusinessBase.GetDataToDataSet ("usp_ActiveDirectoryInfo_GetDisplayNameByPrefixText", parameter). Tables [0]

}

}

}

One of the above categories is BusinessBase.

Put ScriptManager

The copy code is as follows:

Or ToolkitScriptManager

The copy code is as follows:

Pull to the web page.

The following figure shows the html and cs programs, which must have two lines of code before the method:

The copy code is as follows:

[System.Web.Services.WebMethod]

[System.Web.Script.Services.ScriptMethod]

Effect:

Thank you for reading this article carefully. I hope the article "how to automatically expand the text box without using web services" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.