Home > Computers and Internet > How to copy one DataTable into Other DataTable row by row

How to copy one DataTable into Other DataTable row by row

1.
 
There are  two DataTable
a. TableA
b. TableB
 
TableA contains value,and we need to insert rows into blank TableB.
 
DataTable TableB= TableA.Clone(); //copy the structure
Tableb.Rows.Clear();     //clear all rows
 
 
2.
Insert into TableB row by row from TableA
 
TableB.ImportRow(TableA.Row[1])
 
or

DataRow[] dr = TableA.Select(" availId = " + 1);

foreach(DataRow rows in dr)

{

TableB.ImportRow(rows);

}

 
 
 
 
Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: