<asp:TextBox ID="txtSearch" runat="server" Width="365" AutoComplete="OFF" />
<div ID="divwidth"></div> <ajaxToolkit:AutoCompleteExtender runat="server" ID="autoComplete1" TargetControlID="txtSearch" ServicePath="AutoComplete.asmx" ServiceMethod="GetCountriesList" MinimumPrefixLength="1" EnableCaching="true" CompletionListItemCssClass="AutoExtenderList" CompletionListHighlightedItemCssClass="AutoExtenderHighlight" CompletionListElementID="divwidth" /></td>
*webservice*
autocomplete.asmx
]]>
*class file*
using System;
using System.Web;
using System.Collections;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using MySql.Data.MySqlClient;
using System.Configuration;
///
/// Summary description for WebService
///
[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[System.Web.Script.Services.ScriptService]
public class AutoComplete : System.Web.Services.WebService
{
public string connString = ConfigurationManager.ConnectionStrings["connString"].ToString();
[WebMethod]
public string[] GetCountriesList(string prefixText)
{
DataSet dtst = new DataSet();
MySqlConnection sqlCon = new MySqlConnection(connString);
//string strSql = "SELECT top 10 company_name,country FROM company WHERE verify_status='Yes' and delete_status='No' ";
string strSql = "SELECT company_name FROM company WHERE company_name LIKE '" + prefixText + "%' and verify_status='Yes' and delete_status='No' limit 10 ";
MySqlCommand sqlComd = new MySqlCommand(strSql, sqlCon);
sqlCon.Open();
MySqlDataAdapter sqlAdpt = new MySqlDataAdapter();
sqlAdpt.SelectCommand = sqlComd;
sqlAdpt.Fill(dtst);
string[] cntName = new string[dtst.Tables[0].Rows.Count];
int i = 0;
try
{
foreach (DataRow rdr in dtst.Tables[0].Rows)
{
// string str = rdr["country"].ToString();
// str=str.PadLeft(10,' ');
cntName.SetValue(rdr["company_name"].ToString(), i);
i++;
}
}
catch { }
finally
{
sqlCon.Close();
}
return cntName ;
}
}
this will defnetly give output