How to Copy Specific Column Data From One Datatable To Another

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

, +

I Want to copy Data-table 2 Column with data to data-table 2

data-table 1
Age

Height

5

50

6

60

7

70

8

80

data-table 2
Age

Weight

5

30

7

35

Output

Age

Height

Weight

5

50

30

6

60

NULL

7

70

50

8

80

NULL

Posted 29-Jun-15 1:09am

Amol_Khairnar

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)

Abhinav S · Answer 1 · 2015-06-29T01:20:00

Solution 1

Copy the whole data table and remove the specific columns
e.g.

DataTable cpy;
cpy = original.Copy();
cpy.Columns.Remove("OrderName");
cpy.Columns.Remove("OrderDate");

Posted 29-Jun-15 1:20am

Abhinav S

v2

How to Copy Specific Column Data From One Datatable To Another

1 solution

Solution 1

Add your solution here

Preview 0

How to Copy Specific Column Data From One Datatable To Another

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us