How To Merge Datatable

DataTable dt = new DataTable(); //define static

DataTable dt1 = new DataTable();

protected void Page_Load(object sender, EventArgs e)

{

ReadTable1Data();

ReadTable2Data();

MargeBothTable();

}

protected void ReadTable1Data()

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["db_EnterprisesConnectionString"].ToString());

SqlCommand cmd = new SqlCommand();

con.Open();

cmd.Connection = con;

cmd.CommandType = CommandType.Text;

cmd.CommandText = "SELECT [numChallanID] as 'ID', [txtCustomerName] as 'Name' FROM [dbo].[tbl_Challan]";

SqlDataAdapter sda = new SqlDataAdapter(cmd);

sda.Fill(dt);

cmd.Dispose();

con.Close();

}

protected void ReadTable2Data()

{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["db_EnterprisesConnectionString"].ToString());

SqlCommand cmd = new SqlCommand();

con.Open();

cmd.Connection = con;

cmd.CommandType = CommandType.Text;

cmd.CommandText = "SELECT [numInvoiceID] as 'ID', [txtCustomerName] as 'Name' FROM [dbo].[tbl_Invoice]";

SqlDataAdapter sda = new SqlDataAdapter(cmd);

sda.Fill(dt1);

cmd.Dispose();

con.Close();

}

protected void MargeBothTable()

{

dt.Merge(dt1);

dt.AcceptChanges();

grdJournalList.DataSource = dt;

grdJournalList.DataBind();

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Senzeye10y ago
Accepted answer
Below link help to merge 2 dataset

http://dotnetdrizzles.blogspot.in/2015/11/how-to-merge-two-datatable-or-dataset.html
Ravi Patel10y ago
Hi ,

go through the link
https://www.youtube.com/watch?v=knp0Ghzfmjg
Rajan Singh10y ago
DataTable dt = new DataTable(); //define static
DataTable dt1 = new DataTable();
protected void Page_Load(object sender, EventArgs e)
{
ReadTable1Data();
ReadTable2Data();
MargeBothTable();
}
protected void ReadTable1Data()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["db_EnterprisesConnectionString"].ToString());
SqlCommand cmd = new SqlCommand();
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT [numChallanID] as 'ID', [txtCustomerName] as 'Name' FROM [dbo].[tbl_Challan]";
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt);
cmd.Dispose();
con.Close();
}
protected void ReadTable2Data()
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["db_EnterprisesConnectionString"].ToString());
SqlCommand cmd = new SqlCommand();
con.Open();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT [numInvoiceID] as 'ID', [txtCustomerName] as 'Name' FROM [dbo].[tbl_Invoice]";
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(dt1);
cmd.Dispose();
con.Close();
}
protected void MargeBothTable()
{
dt.Merge(dt1);
dt.AcceptChanges();
grdJournalList.DataSource = dt;
grdJournalList.DataBind();
}