MyWebService:
[WebMethod]
public static List
{
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection("database=asha;server=.;integrated security=true");
SqlCommand cmd = new SqlCommand("select* from manish WHERE Name LIKE '" + s + "%' ", con);
cmd.Parameters.AddWithValue("@Name", s);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
List
for (int i = 1; i < dt.Rows.Count; i++)
{
name.Add(dt.Rows[i][0].ToString());
}
return name;
}
}
Default.aspx code;
<asp:ScriptManager ID="ScriptManager1" runat="server">
<Services>
<asp:ServiceReference Path="~/WebService.asmx"/>
Services>
asp:ScriptManager>
<div>
<asp:TextBox ID="TextBox1"runat="server">asp:Te
<asp:AutoCompleteExtenderID="AutoCompleteExtender1"runat="server"TargetControlID="TextBox1"ServiceMethod="Record"ServicePath="~/WebService.asmx" MinimumPrefixLength="1" EnableCaching="true" CompletionSetCount="1" CompletionInterval="1000" >
asp:AutoCompleteExtender>
div>
When we run the program then only textbox show and write any word then no related record find.
Posted Jun 18, 2012, 5:20 AM
please check the service url correct or not in your service reference path.
Suthish NairPosted Jun 18, 2012, 1:45 PM
Davin MartynPosted Jun 18, 2012, 12:33 PM