ASP.NET

public DataSet WSfnGetInfo(string strQuery, string strName, string strClientUser, string strClientPassword)
{
strUser = strClientUser;
strPassword = strClientPassword;

fnCreateCS(); //Create the connection String

SqlDataAdapter dAdapter = new SqlDataAdapter(strQuery, connString );
// DA to fill the Dataset

DataSet dsInfo = new DataSet();
//Dataset

dAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;

try
{
dAdapter.Fill(dsInfo, strName);
//fill the data set
}
catch(SqlException ex)
{
//to return an error
System.Web.HttpContext.Current.Response.Write(ex.Message);
return null;
}

return dsInfo;
//Sending the dataset to the client
}

myServ.Service myService = new myServ.Service();

try
{
dsMeals = myService.WSfnGetInfo("SELECT * FROM dbo.MEALS", "MEALS", f1ref.user, f1ref.password);

dataGridView1.DataSource = dsMeals;
dataGridView1.DataMember = "MEALS";

}
catch (Exception ex)
{
MessageBox.Show(ex.Message + " " + ex.HelpLink + " " + ex.Data);
}