An XML Web service that exposes the Default table from Northwind (C#) : WebService « Development « ASP.NET Tutorial

1. ASP.NET Tutorial
2. Development
3. WebService

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 

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
   <appSettings>
      <add key="MyNamespace.Default" 
       value="http://www.tempuri.com/MyWebService/Default.asmx"/>
   </appSettings>
</configuration>