copying all columns in a datatable to single column in another datatable

Question

0.00/5 (No votes)

See more:

Hi,
i need to copy data from different columns image1,image2,image3etc in a datatable. onto a single column image1 in another datatable using c#.can anybody help me please.god bless you

Posted 29-Sep-13 20:17pm

faizel s

Updated 29-Sep-13 20:41pm

v2

Add a Solution

Comments

[no name] 30-Sep-13 2:54am

not clear.. keep it simple

you mean merge many into one..?

faizel s 30-Sep-13 2:58am

i have several columns like image1,image2,image3 in one datatable.i want to copy copy data from these columns onto single column in another datatable.did you understand what i am saying?god bless you

3 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)

sahabiswarup · Answer 1 · 2013-09-29T21:07:00

Solution 1

using this following code you can select records from one datatable and copy to other

DataTable dt2 = dt1.Select("(Column1 = 'put condition')").CopyToDataTable();

Posted 29-Sep-13 21:07pm

sahabiswarup

Comments

faizel s 30-Sep-13 3:51am

what should we put in the place of condition,

sahabiswarup 30-Sep-13 5:09am

suppose there is one column in dt1 named "Type"; you want to sort or fetch data from dt1 as "Type" basis.

DataTable dt2 = dt1.Select("(Type = 'image')").CopyToDataTable();

so all image type of records will be copied to the new datatable ie dt2.

bluesathish · Answer 2 · 2013-09-29T21:35:00

Solution 2

Dear Faizel,

Try the following code, make sure you add column in dt2 datatable.

C#

foreach (DataRow dr in dt1.Rows) {
	dt2.Rows.Add(dr("image1").ToString() + dr("image2").ToString() + dr("image2").ToString());

}

Regards,
Bluesathish

Posted 29-Sep-13 21:35pm

bluesathish

Singh Gyan · Answer 3 · 2013-09-30T01:28:00

Solution 3

What you need to do is just loop through all the row of the table and add all of your column to the single column of the new data table like this.

C#

foreach (DataRow dr in DataTableOld.Rows) {
	NewDataTable.Rows.Add(dr("Col1").ToString() + dr("Col2").ToString()
 
}

-SG

Posted 30-Sep-13 1:28am

Singh Gyan