Showing posts with label Merge the two tables. Show all posts
Showing posts with label Merge the two tables. Show all posts

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