Mega Code Archive

 

Categories / ASP.Net Tutorial / Development

 

An XML Web service that exposes the Default table from Northwind (C#)

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>