copy few records from first datatable to second datatable

Question

0.00/5 (No votes)

See more:

i have a two datatable(dt1 and dt2)
column 1 to 5 in dt1
and i want to copy few records from first datatable to second datatable(copy column 1,2,3 in dt2)

how?

thanks

How I copy data table specifiy columns to another Datat able?

In C# , I m using one datatable concept, In that datatable had 7 columns,
Now I want to copy first 5 Coulmns for first New Datatable How do I this ?

Source Table Name - Days

Date | Day1 | Slot 1 | Day 2 | Slot 2 | Day 3 | Slot 3

9:00 AM | Invite | A,0 | Invite | B,0 | Invite | C,0
9:20 AM | Invite | A,1 | Invite | B,1 | Invite | C,1

New Datable Name : dtInternational

Date | Day1 | Slot 1 | Day 2 | Slot 2

9:00 AM | Invite | A,0 | Invite | B,0
9:20 AM | Invite | A,1 | Invite | B,1

Posted 3-Oct-12 21:06pm

Jaypal@18

Updated 3-Oct-12 21:26pm

v2

Add a Solution

4 solutions

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)

Mohd. Mukhtar · Answer 1 · 2012-10-03T21:44:00

Hi,

Use the below query

SQL

INSERT INTO dt2 VALUES as
                 SELECT col1,col2,col3 FROM dt1

Please make sure that data type and length of subsequent columns are same.

You can also specify column name in table 2 on which column you want to insert data.

as below

SQL

INSERT INTO dt2<columns name in which you want to insert the data.> VALUES as
                 SELECT col1,col2,col3 FROM dt1

Rockstar_ · Answer 2 · 2012-10-03T21:17:00

Solution 2

i friend,

Apply a select query for the data table, you will get the selected rows from one datatable to another datatable.

http://www.dotnetperls.com/datatable-select[^]

http://msdn.microsoft.com/en-us/library/det4aw50.aspx[^]

Posted 3-Oct-12 21:17pm

Rockstar_

Rockstar_ · Answer 3 · 2012-10-03T21:50:00

Solution 4

hi ,
With below query you can write the column names also ans where condition also.

DataRow[] rows = datatable.Select('TOP 5');

Posted 3-Oct-12 21:50pm

Rockstar_

solanki.net · Answer 4 · 2012-10-03T21:15:00

Solution 1

then what is your problem this is not proper question .u did not explain your tables structure and condition .

Posted 3-Oct-12 21:15pm

solanki.net