AJAX AutoComplete:

AutoComplete is an ASP.NET AJAX extender that can be attached to any TextBox control, and will associate that control with a popup panel to display list of words that begin with the prefix typed into the textbox.

If you want to implement custom CSS style to AutoComplete Extender please refer this article. 

Custom CSS style for AJAX AutoComplete Extender

Here I’m going to demonstrate you, the textbox is associated with an AutoCompleteExtender that pulls words that start with the contents of the textbox using a web service.

AJAX AutoComplete properties:

<asp:AutoCompleteExtender ID="AutoCompleteExtender1"

                          runat="server"

                          TargetControlID="txtCity"

                          MinimumPrefixLength="1"

                          EnableCaching="true"

                          CompletionSetCount="1"

                          CompletionInterval="1000"

                          ServiceMethod="GetCity"

</asp:AutoCompleteExtender>

 

       TargetControlID - The TextBox control where the user types content to be automatically completed

   MinimumPrefixLength - Minimum number of characters that must be entered before getting suggestions from the web service.

             EnableCaching - Whether client side caching is enabled.

           CompletionSetCount - Number of suggestions to be retrieved from the web service.

   ServiceMethod - The web service method to be called. The signature of this method must match the following:

Sample code: 

                 [System.Web.Script.Services.ScriptMethod()]

       [System.Web.Services.WebMethod]

 

       public static List<string> GetCity(string prefixText)

       {

    …

       }

 

You can refer AutoComplete complete properties here

http://www.asp.net/ajaxLibrary/AjaxControlToolkitSampleSite/AutoComplete/AutoComplete.aspx

 

First we have to create a table. Sample table design given below

 

 Table design (City):

Column Name

Data Type

CityID

Int

CityName

varchar(50)

 

In we.config  file we have to set connection string

Sample code: 

<connectionStrings>

        <add name="ConnectionString" connectionString="Data Source=localhost;                           

                                        Initial Catalog=Demo; Integrated Security=True"/>

</connectionStrings>

 

Here we have to add AjaxControlToolkit assembly reference in our page 

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

 Then we have to create our aspx page like this

 

Designer source code:

 

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head runat="server">

    <title>AJAX AutoComplete</title>

</head>

<body>

    <form id="form1" runat="server">  

    <asp:ScriptManager ID="ScriptManager1" runat="server">

    </asp:ScriptManager>

    <div>   

    <asp:TextBox ID="txtCity" runat="server"></asp:TextBox>

    <asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="txtCity"

         MinimumPrefixLength="1" EnableCaching="true" CompletionSetCount="1" CompletionInterval="1000"

         ServiceMethod="GetCity" >

    </asp:AutoCompleteExtender>

    </div>

    </form>

</body>

</html>

 

C# code: 

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data;

using System.Data.SqlClient;

using System.Configuration; 

public partial class _Default : System.Web.UI.Page

{

    protected void Page_Load(object sender, EventArgs e)

    {   }  

    [System.Web.Script.Services.ScriptMethod()]

    [System.Web.Services.WebMethod]

    public static List<string> GetCity(string prefixText)

    {

        DataTable dt = new DataTable();

        string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();

        SqlConnection con = new SqlConnection(constr);

        con.Open();

        SqlCommand cmd = new SqlCommand("select * from City where CityName like @City+'%'", con);

        cmd.Parameters.AddWithValue("@City", prefixText);

        SqlDataAdapter adp = new SqlDataAdapter(cmd);       

        adp.Fill(dt);

        List<string> CityNames = new List<string>();

        for (int i = 0; i < dt.Rows.Count; i++)

        {

            CityNames.Add(dt.Rows[i][1].ToString());

        }

        return CityNames;

    }

}



View demo Download
http://www.dotnetfox.com/Document/1079/0Demo1.gif

If you enjoyed this article, get email updates (it's free).


Related Articles
  • Ajax Accordian control in ASP.NET In this article I’m going to explain how to use Ajax Accordian control in asp.net. The Accordian is a web control that allows you to provide multiple panes and display them at a time and only one panes expanded at a time. Accordian control has a templates for header and content. Also we can add server controls to the Accordian.
  • Ajax Calendar Extender in ASP.NET In this article I’m going to explain how to use Ajax Calendar Extender control in asp.net. Ajax Calendar Extender provides client side date picking functionality with customizable date and UI in a popup control. You can interact with calendar by clicking today date, past and future date. Also you can modify date format, popup display position and set custom styles to the calendar.
  • How to use Ajax ModalPopup Extender in ASP.NETIn this article I’m going to explain how to use Ajax Modalpopup Extender control in asp.net. The ModalPopup extender allows a page to display content to the user in a “modal” manner which prevents the user from interacting with rest of the page. We can add any web controls inside the modal content. When modal popup displayed only the modal content can be interacted with the user and rest of the pa...
  • How to use Ajax CalenderExtender in ASP.NET GridViewIn this article I’m going to explain how to use Ajax CalenderExtender in ASP.NET GridView. Today one of my blog subscriber asked me a question that’s how to use Ajax CalenderExtender in ASP.NET GridView. I hope you already know how to use Ajax CalenderExtender in normal page. There is no different to use Ajax CalenderExtender in normal page and GridView.
  • How to use Ajax ColorPickerExtender in ASP.NETIn this article I’m going to explain how to use Ajax ColorPickerExtender in ASP.NET. Ajax ColorPickerExtender provides client-side color-picking functionality with UI in a popup control. It can be attached to any ASP.NET TextBox control.
  • Google Geo Chart or Geo map with custom Color and Tooltip in ASP.NET I have already written an article for implementing Geo Chart in ASP.NET. In this article I’m going to explain how to use custom colors and tooltip in Google Geo Chart. In this demo I have implemented Geo chart for countries and percentage of world populations. For that first we have to create table with following fields.
  • Ajax Cascading DropDown example with database in ASP.NETCascadingDropDown is an ASP.NET AJAX extender that can be attached to an ASP.NET DropDownList control. It will automatically populate set of DropDownList controls without page postback. Each time the selection of one the DropDownList controls changes, the CascadingDropDown makes a call to a specified web service to retrieve the list of values for the next DropDownList in the set.
  • AJAX FileUpload or multiple FileUpload with progress example in ASP.NETThe AjaxFileUpload control is used to upload multiple files to the server folder. AjaxFileUpload uses one of two methods of showing file upload progress. If you are using a browser which fully supports the HTML5 File API (such as Google Chrome or Mozilla Firefox) then upload progress is displayed using client-side events. If, on the other hand, you are using a browser which does not fully support ...
  • UpdatePanel with Triggers in ASP.NETASP.NET AJAX provides the most visible feature that the ability to partial or incremental page updates with PostBack to the server. Before AJAX implementation is ASP.NET page update require a round trip to the server which requires a page refresh. UpdatePanel control remove the requirement to refresh the whole page with each postback which improves user experience. While working with UpdatePanel ...
  • Using jQuery ajax to call ASP.NET page method to execute store procedureCall ASP.NET page method to execute store procedure with multiple parameters using jQuery ajax. One of my blog reader asked me a question that how to execute store procedure directly using jQuery. Actually we can’t execute store procedure directly by jQuery. But we can call ASP.NET page method to execute store procedure.

Comments
comments powered by Disqus

Thanks for downloading..!!

×
Subscribe via Email
    
message to display in fancybox