Compare Two Columns in a DataTable

Question

0.00/5 (No votes)

See more:

In my 'DataTable' Data is

Pk Col1 col2 col3

100 1 1 Result
101 2 2
103 3 3
104 2 4
105 5 5

this is my 'DataTable' ,now i want to compare 'col1,col2' records.If it missmatch
then Check the condition.
for ex :

104 2 4 , this row columns are missmatched, then

check the condition

If(2<4)
{

Then, in col2 2 is come then its increment 1 means the vaslue of 2 is replaced by 3,... upto its reaches 4.
Once it Reaches the 4, then col2 value(4) is replaced with col1 value(2) then store the result in anothe column.

}
My final Result is like this 1,3,4,2,5
This is my task, plz give suggestion to do this

Posted 1-Aug-12 19:14pm

naveensanagasetti

Updated 1-Aug-12 19:24pm

v2

Add a Solution

Comments

pradiprenushe 2-Aug-12 1:28am

You want to interchange column? Still your logic is not clear.

BobJanova 2-Aug-12 10:52am

Seems like homework, this is a really arbitrary looking requirement.

3 solutions

Solution 2

try this:

VB

For Each dr as DataRow in dt.Rows

If dr("col1")<>dr("col2") Then
--your condition
End If

Next

Posted 1-Aug-12 19:49pm

dimpledevani

Updated 2-Aug-12 2:16am

v2

Solution 3

Try the below one. Here replace age with col1 and age2 with col2.

C#

foreach (DataRow dr in dt.Rows)
            {
                if (Convert.ToInt32(dr["Age"]) < Convert.ToInt32(dr["Age2"]))
                {

                    foreach (DataRow dr2 in dt.Rows)
                    {
                        if (Convert.ToInt32(dr2["Age2"]) == Convert.ToInt32(dr["Age"]))
                        {

                            foreach (DataRow dr3 in dt.Rows)
                            {
                                if (Convert.ToInt32(dr3["Age2"]) < Convert.ToInt32(dr["Age2"]))
                                    dr3["Age2"] = Convert.ToInt32(dr["Age"]) + 1;
                                if (Convert.ToInt32(dr3["Age2"]) == Convert.ToInt32(dr["Age2"]))
                                    dr3["Age2"] = Convert.ToInt32(dr["Age"]);
                            }
                        }

                    }
                }

i tried with similar scenario of table. Below is the my table contents. It worked perfectly.

C#

ew Student() { Name = "Jack", Age = 1, Age2 = 15,StudentId = 100 },
         new Student() { Name = "Smith", Age = 2, Age2 = 2,StudentId = 101 },
         new Student() { Name = "Smit", Age = 3,Age2 = 3, StudentId = 102 },
          new Student() { Name = "Smit", Age = 2,Age2 = 4, StudentId = 102 }

Posted 2-Aug-12 2:14am

Santhosh Kumar Jayaraman

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)

_Amy · Accepted Answer · 2012-08-01T19:26:00

Hi,
Try this:

C#

for(int i=0; i<dt.rows.count;>{
    if(dt.Rows[i][1] != dt.Rows[i][2])
    {
        if(dt.Rows[i][1] < dt.Rows[i][2])
        {
            int val= Convert.ToInt32(dt.Rows[i][1]);
            do
            {
                val++;
            }while(val <= Convert.ToInt32(dt.Rows[i][1]);
            dt.Rows[i][1] = val;
        }
    }
}
dt.AcceptChanges();

--Amit