Please How can display fileds between two tables in gridview

void BindGrid()
{
SqlConnection myConnection = new SqlConnection(strConn);
DataSet DS1;
DataSet DS2;

//cmd1 &cmd2 are SqlCommand objects pre lang="c#">

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");

// Note : The table in both DataSet ["MyTable"] must have same name  

ds1.merge(ds2);

MyDataGrid.DataSource = DS1.tables[0].DefaultView;
MyDataGrid.DataBind();
}