Still its not working, please help me sir its very important... below is my code..
<asp:TextBox ID="txtSearch" runat="server" CssClass="autosuggest" Width="180px" Height="25px"/>
<asp:TextBoxWatermarkExtender ID="TBWE2" runat="server" TargetControlID="txtSearch" WatermarkText=" Type Name Here"
WatermarkCssClass="watermark" />
<asp:AutoCompleteExtender ServiceMethod="SearchCustomers"
MinimumPrefixLength="2"
CompletionInterval="100" EnableCaching="false" CompletionSetCount="10"
TargetControlID="txtSearch"
ID="AutoCompleteExtender1" runat="server" FirstRowSelected = "false">
</asp:AutoCompleteExtender>
and .cs
[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["constring"].ToString();
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "select DISTINCT CompanyName from testCompany where CompanyName 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["CompanyName"].ToString());
}
}
conn.Close();
return customers;
}
}
}
