i am trying to display an autosuggest textbox that grabs information
from a database, there are there alot of examples out there but i
would like to use a webservice that i have created. how would i go
about doing it with this webservice

<%@ WebService Language="C#" Class="WebService" %>

using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;

[WebService(Namespace = "http://tempuri.org/";)]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class WebService : System.Web.Services.WebService
{
    [WebMethod(Description = "Input a name and it will return
players")]

    public DataSet SearchPlayer(string query)
    {
        //Initialize data access class used in MIS 324 (written in
VB.NET)
        string strSQL = "Select nameFirst, nameLast from FullMaster
where (nameFirst LIKE '" + query + "%') or (nameLast like '" + query +
"%')";
        DataAccess objDataAccess = new DataAccess("BaseballDatabase");
        DataTable dt = new DataTable();
        dt = objDataAccess.FillDataTable(strSQL);

        //Note: web services can return DataSets but not DataTables.
        DataSet ds = new DataSet("dsPlayer");
        ds.Tables.Add(dt);
        ds.AcceptChanges();
        return ds;

    }


}


in my asmx page, i want to create an ajax textbox that displays info
from that webservice, any help would be great

Reply via email to