Creating a dataset in C#

/******************************************************************************/

/*Creats dataset */
public static DataSet createTestDataSet(string sqlstr)
{
SqlConnection myConnection = new SqlConnection(connString);
myConnection.Open();
DataSet myDataSet=new DataSet();
SqlDataAdapter da = new SqlDataAdapter();
try{
da.SelectCommand = new SqlCommand(sqlstr,myConnection);
da.Fill(myDataSet);
}
finally
{
da.Dispose();
myConnection.Close();
}
return myDataSet;
}
/******************************************************************************/

USe Dataset when you want to serialize data or load an XML or load a datagrid...

DataSet ds = biography_dev.includes.databaseCalls.createTestDataSet(sql);
Affiliation_datagrid.DataSource=ds;
//this try catch is needed because a person can go from page 11 of one department to page 1 of the other one which may not have 11 pages and it causes error due to that reason
try
{
//bind code
Affiliation_datagrid.DataBind();
Affiliation_datagrid.VirtualItemCount = ds.Tables.Count;
}
catch(Exception)
{
Affiliation_datagrid.CurrentPageIndex=0;
Affiliation_datagrid.DataBind();
Affiliation_datagrid.VirtualItemCount = ds.Tables.Count;
//re-bind code
}
Affiliation_datagrid.Visible=true;