How To Merge Datatable

Question

How to merge two datatable values bind to gridview ?

Senzeye · Answer

Below link help to merge 2 dataset http://dotnetdrizzles.blogspot.in/2015/11/how-to-merge-two-datatable-or-dataset.html

Ravi Patel · Answer

Hi  go through the link https://www.youtube.com/watch?v=knp0Ghzfmjg

Rajan Singh · Answer

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