List search using Ajax 'AutoExtender control'

create a new ajax enabled website and add AjaxcontrolToolkit dll
add the foolowing stmt
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="ajax" %>
in the source page Eg.,default.aspx

ADD textbox
and AutoCompleteExtender

ajax:AutoCompleteExtender ID="AutoCompleteExtender1"

runat="server"

ServicePath="SearchAutoComplete.asmx"

ServiceMethod="FindName"

MinimumPrefixLength="1"

TargetControlID="TextBox1">





add webservice to your project i.e.,SearchAutoComplete.asmx(name of your website)
and method name is "FindName"

Note:[System.Web.Script.Services.ScriptService] must be declared before class

[WebMethod]

public string[] FindName(string prefixText)
{

List titlearraylist = new List();


string sql="select city from city where city like '"+prefixText +"%'";
SqlCommand cmd=new SqlCommand(sql,con);
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
while(dr.Read())
{
string strTemp = Convert.ToString(dr["city"]);

titlearraylist.Add(strTemp);

}