StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POautocomplete extender problem?
text
Body
copied!<p>I am using autocomplete extender, i write a webservice the webservice is working fine when i run webservice. But when i run my aspx page it is not displaying any thing the autocomplete is not showing only text box is there. this is my code......</p> <pre><code>[WebService(Namespace = "http://tempuri.org/")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] public class WebService : System.Web.Services.WebService { SqlConnection con;SqlDataAdapter da; public WebService () { //Uncomment the following line if using designed components //InitializeComponent(); } [WebMethod] public string[] GetTitleInfo(string prefixText) { int count = 10; string sqry = "select * from news_upload where newstitle like @prefixText"; da = new SqlDataAdapter(sqry, "server=localhost;database=tfcnew;user id=sa;password=sql123"); da.SelectCommand.Parameters.Add("@prefixText", SqlDbType.VarChar, 100).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["newstitle"].ToString (), i); i++; } return items; } </code></pre> <p>this is (above) service.</p> <p> </p> <pre><code> <asp:TextBox ID="txtcomplete" runat ="Server" ></asp:TextBox> <asp:AutoCompleteExtender ID="AutoCompleteExtender2" runat="server" MinimumPrefixLength ="1" ServiceMethod ="GetSuggestions" ServicePath="~/WebService2.asmx" TargetControlID ="txtcomplete" > </asp:AutoCompleteExtender> </code></pre> <p>This is aspx code..</p> <p>can u help me. thank you. </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload