Wednesday 23 April 2014

Merge the two tables in Asp.Net

Merge the two tables in Asp.Net
DataTable dtOne = new DataTable("MyFirstTable");
dtOne.Columns.Add("Number");
DataTable dtTwo = new DataTable("MySecondTable");
dtTwo.Columns.Add("Number");
// Populate the first table
for (int i = 1; i <= 10; i++)
{
DataRow row = dtOne.NewRow();
row["Number"] = "Data" + i;
dtOne.Rows.Add(row);
}
// Populate the second table
for (int i = 11; i <= 20; i++)
{
DataRow row = dtTwo.NewRow();
row["Number"] = "Data" + i;
dtTwo.Rows.Add(row);
}
// Now merge the two tables /* ONLY ONE LINE OF CODE COOL RIGHT! */
dtOne.Merge(dtTwo);
GridView1.DataSource = dtOne;
GridView1.DataBind();