Hello to all Professionals,
I have create a text box autofill using .asmx file its worling fine
here the code
But after this when i insert , separator this will repeat all the
previous values that is already filled in textbox please guide me or
send me how to do this
<form id="form1" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server"
EnablePageMethods="true">
<Services>
<asp:ServiceReference Path="~/autocomplete.asmx" />
</Services>
</asp:ScriptManager>
<asp:TextBox ID="TextBox1" runat="server" Width="266px"></
asp:TextBox><div>
<cc1:AutoCompleteExtender ID="AutoCompleteExtender1"
runat="server"
TargetControlID="TextBox1"
MinimumPrefixLength="1"
ScriptPath="~/autocomplete.asmx"
ServiceMethod="ListUser" ServicePath="">
</cc1:AutoCompleteExtender>
</div>
</form>
//---------------------
[WebMethod]
public string[] ListUser(string prefixText)
{
//return all records whose Title starts with the prefix input
string
//int count = 10;
string sql = "select BhootName from bhoot where bhootname like
@prefixText";
SqlDataAdapter da = new SqlDataAdapter(sql, "Data
Source=vivacity5\\SQLEXPRESS;Initial Catalog=practice;Integrated
Security=True");
da.SelectCommand.Parameters.Add("@prefixText",
SqlDbType.VarChar, 50).Value = prefixText + "%";
DataTable dt = new DataTable();
da.Fill(dt);
string[] items = new string[dt.Rows.Count];
int i = 0;
foreach (DataRow dr in dt.Rows)
{
items.SetValue(dr["BhootName"].ToString(), i);
i++;
}
return items;
}
Regards,
Anil