How to copy one datatable to another

Question

4.00/5 (1 vote)

See more:

I am stored values to datatable from database.
My datatable has following

jc_id  jc_name jc_car        jc_color  jc_plate jc_service  jc_spare jc_qty
1	asdfsa	Maruti800	red	123	NULL	    NULL	NULL
NULL	NULL	NULL		NULL	NULL	WaterWash   NULL	NULL
NULL    NULL    NULL            NULL    NULL    WaterWash   NULL         NULL
NULL    NULL    NULL            NULL    NULL    NULL        Star Wars   34.00
NULL    NULL    NULL            NULL    NULL    NULL        Shrek   43.00

In this datatable I want a jc_service column without null value
like

jc_service
WaterWash
WaterWash

I want to this copy this column only to another datatable how to do it?
Please help me...

Posted 2-Nov-12 20:38pm

devausha

Updated 2-Nov-12 20:39pm

v2

Add a Solution

3 solutions

Solution 3

Hi devausha, What dont you look for joins?
I think it may help you

Posted 2-Nov-12 23:51pm

Bhargav.456

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)

subhajit Giri · Accepted Answer · 2012-11-02T21:08:00

Solution 1

You may use this code for your task.

C#

DataTable dtTarget = new DataTable();
    dtTarget = dtSource.Clone();
    DataRow[] rowsToCopy;
    rowsToCopy = dtSource.Select("key='" + matchString + "'");
    foreach (DataRow temp in rowsToCopy)
    {
        dtTarget.ImportRow(temp);
    }

Posted 2-Nov-12 21:08pm

subhajit Giri

Updated 2-Nov-12 23:09pm

v2

Comments

Sunny_Kumar_ 3-Nov-12 3:34am

Hi subhajit, We must read the questions carefully before answering them as you can see, the question is about to copy a column to another datatable instead of cloning a whole table. Hope you get my point :)

devausha 3-Nov-12 5:52am

It works thank you

Sunny_Kumar_ · Accepted Answer · 2012-11-02T21:09:00

Hi devusha,

Well, in this case you add a column manually like:

C#

dt1.Columns.Add("newColumnName",Type.GetType("String"));

and If you want to copy this column to another datatable, you can do like this:

C#

DataTable dt2 = new DataTable();
dt2.Columns.Add(dt1.Columns["newColumnName"]);

Hope this helps!

Happy Coding:)

Best Regards,
Sunny K