Ajax中的自动完成扩展器 [英] autocomplete extender in ajax

问题描述

如何在ajax中创建具有多个单词的自动竞争扩展器，
例如在codeproject 标签文本框的询问问题"页面中，其中多个单词从数据库中提取.

how to create autocompete extender with multiple word in ajax,
for example in Ask question page of codeproject Tags textbox in which multiple words fetch from database.

help me plz for this.

推荐答案

此链接可以为您提供帮助:

http://www.ajaxcontroltoolkit.com/AutoComplete/AutoComplete.aspx [ http://www .ajaxtutorials.com/ajax-control-toolkit-tutorials/ajax-control-toolkit-tutorial-autocomplete-extender-using-asp-net-c/ [

This link can help you:

http://www.ajaxcontroltoolkit.com/AutoComplete/AutoComplete.aspx[^]


Or

http://www.ajaxtutorials.com/ajax-control-toolkit-tutorials/ajax-control-toolkit-tutorial-autocomplete-extender-using-asp-net-c/[^]

1.将AjaxControlToolkit.dll添加到您的项目中(通过添加引用).
2.将其注册到Web.Config文件中.
EX:< add namespace ="AjaxControlToolkit" assembly ="AjaxControlToolkit" tagprefix ="ajaxToolkit">
3.R.单击您的项目->添加新项->选择-> Web服务-> AutoComplete.asmx(输入名称)

4.然后创建 AutoComplete.asmx 和 AutoComplete.cs 文件.

AutoComplete.cs是在App Code上创建的.
5，在AutoComplete.cs内部编写代码并取消注释该行
作为[System.Web.Script.Services.ScriptService]

例如:

1.Add the AjaxControlToolkit.dll to your project(by Add Reference).
2.Register it in to Web.Config file.
EX:<add namespace="AjaxControlToolkit" assembly="AjaxControlToolkit" tagprefix="ajaxToolkit">
3.R.Click on your prject-->Add New Items-->Chooes-->Web Service-->AutoComplete.asmx(put name)

4.Then AutoComplete.asmx and AutoComplete.cs file is created.The

AutoComplete.cs is created on App Code .
5.Inside the AutoComplete.cs write the code and uncomment the line
as [System.Web.Script.Services.ScriptService]

EX:

using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Text;
using System.Web.Script.Services;

/// <summary>
/// Summary description for AutoComplete
/// </summary>
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
//[System.Web.Script.Services.ScriptService]
[System.Web.Script.Services.ScriptService]
public class AutoComplete : System.Web.Services.WebService
{
      [WebMethod]

    public string[] GetBlocks(string prefixText)
    {
        DataSet dtst = new DataSet();  
        SqlConnection sqlCon = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        string strSql = "select BlockName  from BlockMaster  WHERE ltrim(rtrim(BlockName))  LIKE '%" + prefixText + "%' and DeletedFlag=0  ";
        SqlCommand sqlComd = new SqlCommand(strSql, sqlCon);
        sqlCon.Open();
        SqlDataAdapter sqlAdpt = new SqlDataAdapter();
        sqlAdpt.SelectCommand = sqlComd;
        sqlAdpt.Fill(dtst);
        string[] BlockName = new string[dtst.Tables[0].Rows.Count];
        int i = 0;
        try
        {
            foreach (DataRow rdr in dtst.Tables[0].Rows)
            {
                BlockName.SetValue(rdr["BlockName"].ToString(), i);
                i++;
            }
        }
        catch { }
        finally
        {
            sqlCon.Close();
        }
        return BlockName;

}
6.转到查看或搜索页面，如Block.aspx

}
6.Go to View or Search Page like Block.aspx

<asp:TextBox ID="txtBlockSearch"  runat="server" CssClass="txtSearchBox"

              Width="200px"></asp:TextBox>

7，为自动完成扩展器编写内联代码

7.Write Inline code for AutoComplete Extender

<ajaxToolkit:AutoCompleteExtender  runat="server" ID="autoComplete1" TargetControlID="txtBlockSearch" ServicePath="AutoComplete.asmx" ServiceMethod="GetBlocks" MinimumPrefixLength="1" EnableCaching="true">
   </ajaxToolkit:AutoCompleteExtender>

8.运行项目

8.Run the project

这篇关于Ajax中的自动完成扩展器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！