Ajax Autocomplete problem in asp.net

[gopinathtamil]

The below code is i tryed for ajax auto complete on my site.. plz say if their is any bugs... default2.aspx ]]> function IAmSelected(source, eventArgs) { alert(" Key : " + eventArgs.get_text() + " Value : " + eventArgs.get_value()); }

BehaviorID="AutoCompleteEx" TargetControlID="TextBox1" ServicePath="WebService.asmx" MinimumPrefixLength="3" EnableCaching="true" ServiceMethod="GetCompletionList">

autocomplete.cs using System; using System.Collections.Generic; using System.Web.Services; using System.Data; using System.Data.SqlClient; using System.Web.Script.Services; /// /// Summary description for WebService /// [WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] // To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. // [System.Web.Script.Services.ScriptService] public class WebService : System.Web.Services.WebService { public WebService () { //Uncomment the following line if using designed components //InitializeComponent(); } [WebMethod] public string[] GetCompletionList(string prefixText) { { string sql = "select Aname From Pincode Where Aname like @prefixText"; SqlDataAdapter da = new SqlDataAdapter(sql, "Server=sql346.mysite4now.com;uid=aitts_85478;password=aitts;database=aitts_85478"); da.SelectCommand.Parameters.Add("@prefixText", SqlDbType.VarChar, 50).Value = prefixText + "%"; DataTable dt = new DataTable(); da.Fill(dt); // List items = new List(); string[] items = new string[dt.Rows.Count]; int i = 0; foreach (DataRow dr in dt.Rows) { items.SetValue(dr["Aname"].ToString(), i); //items.Add(dr["Location_Name"].ToString()); i++; } // return items.ToA