Asp.net

Dear Friends,

We are working in Asp.net technology...
Hope to get good comments and sure to provides the logical solutions as well...
thank you...
get start...

how to use autocompleteExtender in ASP.net AJAX
For this the design source you have to use is this
for .aspx source code
=============================================

=============================================
css is define below

====================================================

Coding .cs code

first of all in coding part you have to make a service
in .asmx.cs code is given below

[System.Web.Services.WebMethod]
public string[] GetCompletionList(string prefixText,int count)
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "your connection string";
List listString = new List();
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "select distinct(cName) from City where cName like '%" + prefixText.ToUpper() + "%' ORDER BY cName";
cmd.Connection = con;
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
listString.Add(dr["cName"].ToString());
}
}
con.close();
string[] str = listString.ToArray();
return str;
}


====================================================