void BindGrid()
{
SqlConnection myConnection = new SqlConnection(strConn);
DataSet DS1;
DataSet DS2;
pre>
SqlDataAdapter MyCommand;
MyCommand = new SqlDataAdapter(cmd1, MyConnection);
DS1 = new DataSet();
MyCommand.Fill(DS1, "MyTable");
MyCommand = new SqlDataAdapter(cmd2, MyConnection);
DS2 = new DataSet();
MyCommand.Fill(DS2, "MyTable");
ds1.merge(ds2);
MyDataGrid.DataSource = DS1.tables[0].DefaultView;
MyDataGrid.DataBind();
}