How to add new column with data from first data table to second data table using C#

Question

1.00/5 (3 votes)

See more:

, +

My Current Result in Table[0]

Id  |   Name    |  City
1   |  Akshada  |  Baroda
2   |  Rutu     |  Pune

I want to add Cast from Table[2] into Table[0]

I Want Below Answer

Id  |   Name    |  City    | Cast
1   |  Akshada  |  Baroda  | Bramhin
2   |  Rutu     |  Pune    | Rajput
3   |  Priya    |  Jaipur  | Muslim

I Want to add Cast using foreach loop

Check My DATA in Below Tables for Example

----------

Table[0]

Id  |   Name    |  City    
1   |  Akshada  |  Baroda  
2   |  Rutu     |  Pune    
3   |  Priya    |  Jaipur

----------

Table [2]

Bramhin 
Rajput 
Muslim

----------

What I have tried:

objResult = objDataBl.Result_SelectAll_ForDisplay(intBatchId);

objResult.ResutlDs.Tables[0].Columns.Add("Cast", typeof(string));

foreach (DataRow row in objResult.ResutlDs.Tables[0].Rows)
{
     row["Cast"] = objResult.ResutlDs.Tables[2].Rows[0]["Column1"].ToString();          
}

Using above code i got wrong ans
My Answer is

Id  |   Name    |  City    | Cast
1   |  Akshada  |  Baroda  | Bramhin
2   |  Rutu     |  Pune    | Bramhin 
3   |  Priya    |  Jaipur  | Bramhin

Posted 3-Aug-18 23:24pm

Akshada Sane

Updated 5-Aug-18 18:17pm

v2

Add a Solution

Comments

Richard Deeming 6-Aug-18 10:38am

REPOST
You have already posted this:
https://www.codeproject.com/Questions/1255219/How-to-add-new-column-with-data-in-first-datatable[^]

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

OriginalGriff · Accepted Answer · 2018-08-04T00:03:00

Solution 1

Simple: stop using row zero each time:

C#

row["Cast"] = objResult.ResutlDs.Tables[2].Rows[0]["Column1"].ToString();
                                                ^
                                                |

Instead, set up a integer variable outside your loop (or better use a for loop instead of a foreach) and use that instead of the constant value.

Posted 4-Aug-18 0:03am

OriginalGriff

Comments

Akshada Sane 4-Aug-18 6:13am

for (int i = 0; i < objResult.ResutlDs.Tables[0].Rows.Count; i++)
{
row["Denier"] = objResult.ResutlDs.Tables[2].Rows[i]["Column1"].ToString();
}
Using for loop got error in "row["Denier"]"

Error : "Then name does not exist"

OriginalGriff 4-Aug-18 6:25am

:sigh:
When you replace a foreach with a for, you are responsible for creating the variable, that used to be automatically created, scoped, and filled by the foreach; and filling it with a value ...

Akshada Sane 4-Aug-18 7:00am

It would be better if I could code and show it to me

OriginalGriff 4-Aug-18 7:09am

Oh, come on! This is the trivial stuff!

foreach (MyClass mc in MyCollection)
   {
   ...
   }

Is equivelant to:

for (int i = 0; i < MyCollection.Count; i++)
   {
   MyClass c = MyCollection[i];
   ...
   }

You know that!

Akshada Sane 4-Aug-18 7:16am

DataRow row = objResult.ResutlDs.Tables[0].NewRow();
for (int i = 0; i < objResult.ResutlDs.Tables[0].Rows.Count; i++)
{
row["Denier"] = objResult.ResutlDs.Tables[0].Rows[i];
}

OriginalGriff 4-Aug-18 7:18am

No.
Look at the examples again, and think.

Akshada Sane 4-Aug-18 7:30am

thank you for your help but i don't know getting wrong ans

foreach (DataRow row in objResult.ResutlDs.Tables[0].Rows)
{
for (int i = 0; i < objResult.ResutlDs.Tables[0].Rows.Count; i++)
{
row["Denier"] = objResult.ResutlDs.Tables[2].Rows[i]["Column1"].ToString();
}
}

OriginalGriff 4-Aug-18 8:21am

Then stop guessing, and start thinking!

Development doesn;t work by "hope and pray" - you are expected to use your brain, rather than throw down any old code and hope for the best.
Com on now - you are brighter than that!

Akshada Sane · Accepted Answer · 2018-08-05T18:17:00

Thank you all for helping me i got solution using below code

objResult.ResutlDs.Tables[0].Columns.Add("Cast", typeof(string));
for (int i = 0; i < objResult.ResutlDs.Tables[0].Rows.Count; i++)
{
     objResult.ResutlDs.Tables[0].Rows[i]["Cast"] = objResult.ResutlDs.Tables[2].Rows[i]["Cast"];
}