please anybody help auto complete text box using ajax and database mysql

Hi,


i have devloping web application in Asp.net and c#, i have used ajax to achieve the auto complete text box, my company using visual studio 2003, ajax auto complete text box working fine with ms sql database, but it throughing some script error and not working, anybody to help me to solve this problem, how to make the ajax compatible with mysql database,i'm using following ajax method

[AjaxPro.AjaxMethod]
public DataTable GetSearchData(string sno)
{

string con=ConfigurationSettings.AppSettings["hd_mysql_con"].ToString();
MySqlConnection conn = new MySqlConnection(con);
cmd=new MySqlCommand("HD_SELECT_STORES",conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("?STORENUM",Convert.ToInt32(sno));
cmd.Parameters["?STORENUM"].Direction = ParameterDirection.Input;
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds,"hd_stores_login");
DataTable dt = new DataTable();
dt= ds.Tables["hd_stores_login"];
return dt;
}

Advanced thanks for any reply.

 

this might come in handy http://forums.digitalpoint.com/showthread.php?t=1619196

 

you just bumped a thread started in 2007