Sample code for a .NET webservice

Easy webservices are one of the major improvements in .NET here is a sample

[andrey_sea]

Thought I would post a sample web service I wrote in C#. It retrives some data from multiple lookup tables and passes them on in a DataSet.

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Diagnostics;
using System.Web;
using System.Web.Services;

namespace wsCarts {
/// <summary>
/// Summary description for webservice.
/// </summary>
public class StartCarts : System.Web.Services.WebService {
public StartCarts(){

InitializeComponent();
}
private System.Data.SqlClient.SqlConnection sqlCnCarts;
#region Component Designer generated code

//Required by the Web Services Designer
private IContainer components = null;

/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent() {
this.sqlCnCarts = new System.Data.SqlClient.SqlConnection();
//
// sqlConHistoricalCount
//
this.sqlCnCarts.ConnectionString = "data source=SomeSQLServer;initial catalog=Carts;persist security info=" +
"False;password=pasword;user id=wsCarts;workstation id=MachineID;" +
"packet size=4096";
}

/// <summary>
/// Clean up any resources being used.
/// </summary>
protected override void Dispose( bool disposing ) {
if(disposing && components != null) {
components.Dispose();
}
base.Dispose(disposing);
}

#endregion

/// <summary>
/// Returns a DataSet composed of various tables/// </summary>
/// <returns>Returns a DataSet object</returns>
[WebMethod]
public DataSet getDDLData() {
DataSet ds = new DataSet();
ds = ADOGetDataSet("dbo.[spCities]", ds, "Cities");
ds = ADOGetDataSet("dbo.[spStaffLookup]", ds, "Staff");
ds = ADOGetDataSet("dbo.[spStatus]", ds, "Status");
ds = ADOGetDataSet("dbo.[spCategory]", ds, "Category");
ds = ADOGetDataSet("dbo.[spClientList]", ds, "ClientList");
return ADOGetDataSet("dbo.[spContactType]", ds, "ContactType");
}
/// <summary>
/// Returns a DataSet of Cities/// </summary>
/// <returns>Returns a DataSet object</returns>
[WebMethod]
public DataSet getCities() {
DataSet ds = new DataSet();
return ADOGetDataSet("dbo.[spCities]", ds);
}
/// <summary>
/// Returns a DataSet of employees/// </summary>
/// <returns>Returns a DataSet object</returns>
[WebMethod]
public DataSet getStaff() {
DataSet ds = new DataSet();
return ADOGetDataSet("dbo.[spStaffLookup]", ds);
}

/// <summary>
/// Returns a DataSet composed of status values.
/// </summary>
/// <param name="none">None</param>
/// <returns>Returns a DataSet object</returns>
[WebMethod]
public DataSet getStatus() {
DataSet ds = new DataSet();
return ADOGetDataSet("dbo.[spStatus]", ds);
}

// This is a generic function that accepts a SQL statement or a stored procedure name and
// performs database activities to return a DataSet
private DataSet ADOGetDataSet(string sSQL, DataSet ds) {
System.Data.SqlClient.SqlDataAdapter sqlDACarts = new System.Data.SqlClient.SqlDataAdapter(sSQL,sqlCnCarts);
sqlDACarts.Fill(ds);
return ds;
}
// This is a generic function that accepts a SQL statement or a stored procedure name and
// performs database activities to return a DataSet
private DataSet ADOGetDataSet(string sSQL, DataSet ds, string sTableName) {
System.Data.SqlClient.SqlDataAdapter sqlDACarts = new System.Data.SqlClient.SqlDataAdapter(sSQL,sqlCnCarts);
sqlDACarts.Fill(ds, sTableName);
return ds;
}
}
}

[Xoc]

Thanks, andrey_sea!