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;         }     } }