Ajax autocompleteextender与asp.net中的进度条图像 [英] Ajax autocompleteextender with progressbar image in asp.net

问题描述

Webservices code is working proper but in textbox not fetching data from database.And no error displaying..



webservices code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.IO;
using System.Collections.Generic;

/// <summary>
/// Summary description for WebService
/// </summary>
[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 HelloWorld() {
    //    return "Hello World";
    //}



 public List<string> GetCountries(string prefixText)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ToString());
con.Open();
SqlCommand cmd = new SqlCommand("select * from ace where name like @name+'%'", con);
cmd.Parameters.AddWithValue("@name", prefixText);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable  dt = new DataTable( );
da.Fill(dt);
List<string> CountryNames = new List<string>();
for(int i=0;i<dt.Rows.Count;i++)

{

CountryNames.Add(dt.Rows[i][1].ToString());

}

return CountryNames;

}

}





default.aspx code







        <asp:TextBox ID="txtCountry" runat="server">  <br />
         
       
        <asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server" TargetControlID="txtCountry" ServicePath="WebService.asmx"

MinimumPrefixLength="1" EnableCaching="true" CompletionSetCount="1" CompletionInterval="1000" ServiceMethod="GetCountries" OnClientPopulating="ShowProcessImage" OnClientPopulated="HideProcessImage">

推荐答案

更改您的方法签名如下

change your method signature as below

[System.Web.Script.Services.ScriptMethod()]
[System.Web.Services.WebMethod]
public static List<string> GetCountries(string prefixText, int count)
 SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["conn"].ToString());
 con.Open();
 SqlCommand cmd = new SqlCommand("select * from ace where name like @name+'%'", con);
 cmd.Parameters.AddWithValue("@name", prefixText);
 SqlDataAdapter da = new SqlDataAdapter(cmd);
 DataTable  dt = new DataTable( );
 da.Fill(dt);
 List<string> CountryNames = new List<string>();
 for(int i=0;i<dt.Rows.Count;i++)
 {
   CountryNames.Add(dt.Rows[i][1].ToString());
 }
 return CountryNames;
}

查看文档以获取更多信息 [ ^ ]

这篇关于Ajax autocompleteextender与asp.net中的进度条图像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！