Copy one datat table specific columns to anothere data table

Question

0.00/5 (No votes)

See more:

Hello ,

I Have one DataTable with Columns as SlNo,FirstName,LastName,MobileNO and Salary,

i want to Copy only SlNo,FirstName,LastName and Salary to anothere table .....

Using Loops i want to add Data

What I have tried:

newTable = dt.DefaultView.ToTable(false, ColumnName);

i want add through loop of data table copy to another table

Posted 23-Nov-16 19:46pm

Darshan E Ksheerasagar

Updated 23-Nov-16 20:24pm

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

manu_dhobale · Accepted Answer · 2016-11-23T20:24:00

Use Copy method and remove desired columns

C#

DataTable newTable ;
newTable = dt.Copy();

or you can clone datatable structure and by looping add rows to new table

C#

DataTable newTable = dt.Clone();
   foreach (DataRow item in dt.Rows)
   {
    newTable.ImportRow(item);
   }

for column removal use one of below

C#

dt.Columns.Remove("columnName");
dt.Columns.RemoveAt(columnIndex);

Updated solution:

C#

DataTable dt = new DataTable();
dt.Columns.Add("[Serial Number]", typeof(int));
dt.Columns.Add("[Last Name]", typeof(string));
dt.Columns.Add("[First Name]", typeof(string));
dt.Columns.Add("Salary", typeof(decimal));
dt.Columns.Add("[Mobile No]", typeof(string));

dt.Rows.Add(1, "Kulkarni", "Ramesh", 1500.00, "9485234567");
dt.Rows.Add(2, "rani", "suresh", 1500.00, "9485234567");



DataTable newTable;
newTable = dt.Copy();
newTable.Columns.Remove("[Mobile No]");
newTable.AcceptChanges();

Copy one datat table specific columns to anothere data table

1 solution

Solution 1

Add your solution here

Preview 0

Copy one datat table specific columns to anothere data table

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us