Tuesday, July 03, 2007 8:50 PM
royashbrook
simple web service
using System;
using System.Data;
using System.Data.SqlClient;
using System.Web.Services;
namespace IamSimple.Service.WebServices
{
[WebService(Namespace = "http://royashbrook.com/ns")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
public class simple : System.Web.Services.WebService
{
[WebMethod(Description = "Return a query as a dataset")]
public DataSet QueryAsDataSet(string q)
{
string cs = "connection string"
using (SqlConnection c = new SqlConnection(cs))
using (SqlCommand cm = new SqlCommand(q, c))
using (SqlDataAdapter da = new SqlDataAdapter(cm))
using (DataSet ds = new DataSet())
{
ds.RemotingFormat = SerializationFormat.Binary;
c.Open();
da.Fill(ds);
c.Close();
return ds;
}
}
}
Filed under: C#, .NET, web services