Ediatble Textbox in asp.net

Question

I want to editable textbox with it's dropdown list in asp.net. suppose I add 'a' letter in textbox then listout word from db those start in 'a' letter.Similarly in google search textbox.

Anil Kumar · Answer

ASPX Page @ Register Assembly = AjaxControlToolkit  Namespace = AjaxControlToolkit  TagPrefix = ajax  %> html xmlns =http://www.w3.org/1999/xhtml> head runat =server> title > Ajax AutoCompleteExtender without Webservice title > head > body > form id =form1 runat =server> ajax : ToolkitScriptManager ID =ScriptManager1 runat =server/> div > asp : TextBox ID = txtCountry  runat =server> asp : TextBox > ajax : AutoCompleteExtender ID =AutoCompleteExtender1 runat =server TargetControlID = txtCountry  MinimumPrefixLength =1 EnableCaching =true CompletionSetCount =1 CompletionInterval =1000 ServiceMethod = GetCountries  > ajax : AutoCompleteExtender > div > form > body > html > Aspx.cs Codding using System.Data; using System.Data. SqlClient ; using System.Collections.Generic; using System.Configuration; [ System.Web.Script.Services. ScriptMethod ()] [ System.Web.Services. WebMethod ] public static List string > GetCountries ( string prefixText ) { SqlConnection con = new SqlConnection ( ConfigurationManager .ConnectionStrings [  dbconnection  ]. ToString ()); con.Open(); SqlCommand cmd = new SqlCommand ( select * from Country where CountryName like @Name+'%'  con); cmd.Parameters. AddWithValue ( @Name  prefixText ); SqlDataAdapter da = new SqlDataAdapter ( cmd ); DataTable dt = new DataTable (); da.Fill( dt ); List string > CountryNames = new List string >(); for ( int i = 0; i i ++) { CountryNames.Add( dt.Rows [ i ][1]. ToString ()); } return CountryNames ; }