Manipulating datatable values

Question

1.00/5 (1 vote)

See more:

I have two tables in a dataset and based on one table values i have to modify another table value and display it in the view.

C#

DataTable dt = _dsexportData.Tables["DiagnosisFaultDescription1"];
                      DataTable dt1 = _dsexportData.Tables["RecommendationDetails"];

                      foreach (DataRow item in dt.Rows)
                      {
                          if (item[0].ToString() == "Non-standard Fault Detected")
                          {
                              item["Recommendations"] = "Contact vibration Specialist";
                          }
                      }

but the thing is Recommendations column is not available in DiagnosisFaultDescription1 it is in RecommendationDetails how can i change that row value??

Posted 12-Aug-14 3:17am

chandra sekhar

Updated 12-Aug-14 3:29am

v3

Add a Solution

Comments

ChauhanAjay 12-Aug-14 11:07am

Is there any common column in both the data tables so that we can create a relationship between both of them.

1 solution

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)

Code.Combustion · Answer 1 · 2014-08-12T06:58:00

Hi Chandra,

If I understand correctly, you're trying to update values in the second table, based on values in the first table("DiagnosisFaultDescription1" and "RecommendationDetails") -- however the second table doesn't have column names (I'm assuming the table schema is the same in both tables or has overlapping columns. If neither is the case then I don't see the purpose in what you're doing).

C#

DataTable dt = _dsexportData.Tables["DiagnosisFaultDescription1"];
DataTable dt1 = _dsexportData.Tables["RecommendationDetails"];

var hasRecommendations = dt1.Columns.Contains("Recommendations");
var index = dt1.Columns.IndexOf("Recommendations");

// Loop through the first table, update the second table at the same row position
for (int i = 0; i < dt.Rows.Count; i++)
{
    var item = dt.Rows[i];
    // If the first column in the current row of DiagnosisFaultDescription1 is "Non-standard Fault Detected"
    if (item[0].ToString() == "Non-standard Fault Detected")
    {
        // You may not need this check
        if (hasRecommendations)
        {
            // Set the first column in the same row index in the second table
            // By Name
            dt1.Rows[i]["Recommendations"] = "Contact vibration Specialist";

            // OR By Index of the column
            dt1.Rows[i][index] = "Contact vibration Specialist";
        }
    }
}

I can provide a better answer if you can clarify your question and if possible, provide more schema detail. Otherwise, try to explain what you'd like to occur as the final result.

Hope this helps,

Code.Combustion