Ajax AutoCompleteExtender Help

Question

i am using Ajax AutoCompleteExtender in my project with a textbox. it work fine and return list of values. Can any help me to hand this list when list contain more than 10 item. i want to show only 10 items at one time with scrollbar.

Priti Srivastava · Answer

sir i am using oledb connection so plz post code for oledbdatabase

Priti Srivastava · Answer

thanks to reply ramu sir! but this is not correct answer of my query. I did it and the solution is .productList { margin: 0px; padding: 0px; height: 200px; overflow:auto; } > * CompletionListCssClass=productList EnableViewState=true Enabled=true TargetControlID=txtPurProName MinimumPrefixLength=1 EnableCaching=true CompletionInterval=1000 CompletionSetCount=1 ServiceMethod=GetProduct runat=server>

Ramu · Answer

@ Register Assembly =AjaxControlToolkit Namespace =AjaxControlToolkit TagPrefix =cc1 %> asp : ScriptManager ID =ScriptManager1 runat =server EnablePageMethods = true> asp : ScriptManager > asp : TextBox ID =txtContactsSearch runat =server> asp : TextBox > cc1 : AutoCompleteExtender ServiceMethod =SearchCustomers MinimumPrefixLength =2 CompletionInterval =100 EnableCaching =false CompletionSetCount =10 TargetControlID =txtContactsSearch ID =AutoCompleteExtender1 runat =server FirstRowSelected = false> cc1 : AutoCompleteExtender > [System.Web.Script.Services. ScriptMethod ()] [System.Web.Services. WebMethod ] public static List string > SearchCustomers( string prefixText int count) { using ( SqlConnection conn = new SqlConnection ()) { conn.ConnectionString = ConfigurationManager .ConnectionStrings[ constr ].ConnectionString; using ( SqlCommand cmd = new SqlCommand ()) { cmd.CommandText = select ContactName from Customers where  + ContactName like @SearchText + '%' ; cmd.Parameters.AddWithValue( @SearchText  prefixText); cmd.Connection = conn; conn.Open(); List string > customers = new List string >(); using ( SqlDataReader sdr = cmd.ExecuteReader()) { while (sdr.Read()) { customers.Add(sdr[ ContactName ].ToString()); } } conn.Close(); return customers; } } }