File: App_Code\Default.cs
using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using System.Data;
using System.Data.SqlClient;
[WebService(Namespace = "http://www.tempuri.com/customers")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class Default : System.Web.Services.WebService
{
[WebMethod]
public DataSet GetDefault() {
SqlConnection conn;
SqlDataAdapter myDataAdapter;
DataSet myDataSet;
string cmdString = "Select * From Default";
conn = new SqlConnection("Server=localhost;uid=sa;pwd=;database=Northwind");
myDataAdapter = new SqlDataAdapter(cmdString, conn);
myDataSet = new DataSet();
myDataAdapter.Fill(myDataSet, "Default");
return myDataSet;
}
}
Changes to the web.config file after making a reference to the Web service