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

How To Merge Datatable

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)