Splitting the .net data table with calculated column

Asked Apr 01 '11 at 19:08

Active Feb 19 '14 at 17:42

Viewed 486 times

I have 2 data tables. First table has 4 columns and Second table has 5 columns. The 5th column in second data table calculated column. Tables schema are shown below.

First Table Columns: A B C D

Second Table Columns:

A1 B1 C1 D1 E1=(A1+B1 *10) here E1 is calculated column.

Now I want to tear off only column E1 from Second table and append it to First table. So my First table will look like.

A B C D E1

Is there any direct way to do this?

edited Feb 19 '14 at 17:42

madth3

7,275
12
50
74

asked Apr 01 '11 at 19:08

Omkar

2,129
8
33
59

1

how are the two tables related? – Bala R Apr 01 '11 at 19:12
The primary Key for both table is same. My only concern is how I move the calculated column from second table to first one. – Omkar Apr 03 '11 at 06:35

Splitting the .net data table with calculated column

0 Answers0