This C# function creates and retrieves a named DataSet using an open connection and a command.
public System.Data.DataSet dsReturnedDataSetFrom(System.Data.SqlClient.SqlConnection
sqlOpenConn, System.Data.SqlClient.SqlCommand TheSQLCommand, string TheQueriedTable, string
TheDatasetName)
{
TheSQLCommand.Connection = sqlOpenConn;
System.Data.SqlClient.SqlDataAdapter NewDA = new System.Data.SqlClient.SqlDataAdapter
(TheSQLCommand);
DataSet NewDS = new DataSet();
TheDatasetName.Trim();
NewDS.DataSetName=TheDatasetName;
NewDA.Fill(NewDS, TheQueriedTable);
NewDA.Dispose();
return NewDS;
}