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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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