C# - Add/Copy Rows from One Datatable to Another Datatable

Introduction:

Here I will explain simple code snippet in c# to add rows from one table to another table in vb.net, asp.net or copy rows from one datatable to another datatable in  c#, vb.net.

Description:

In Previous posts I explained using statement example in c#, Get all files from folder and subfolders in c#, Export webpage with images to pdf in asp.net and many articles relating to c#, vb.net, Asp.net, Gridview, SQL Server, Ajax, JavaScript etc. Now I will explain how to add rows from one table to another table in c#, vb.net, asp.net.  

To add rows from one table to another table we need to use ImportRow function like as shown below

C# Code

DataTable _dt=new DataTable(); _dt = _ds.Tables[0]; DataTable dt1 = ds1.Tables[0]; for (int i = 0; i < dt1.Rows.Count; i++) { _dt.ImportRow(dt1.Rows[i]); }

VB.NET Code

Dim _dt As New DataTable() _dt = _ds.Tables(0) Dim dt1 As DataTable = ds1.Tables(0) For i As Integer = 0 To dt1.Rows.Count - 1 _dt.ImportRow(dt1.Rows(i)) Next

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email