How to compare cell values of datagridview with each other

Question

0.00/5 (No votes)

See more:

If I have a datagridview of say 7 Rows and 27 Columns and if I need to compare the values of cells with another cells how to do it?
Detail:
I need to compare 1st Row cell value with rest of the 6 rows cell values, same thing repeats for 2nd Row for rest 5 row, again same comparison needed for 3rd row with rest 4 rows. Basically It is row wise comparison
ROW1-> 2 2 2 4 4 6 6 8 8 8 7 7
ROW2-> 1 1 1 7 7 7 6 9 9 9 7 7
ROW3-> 1 1 3 3 3 3 5 5 5 0 0 0
ROW4-> 2 2 2 0 0 0 0 1 1 1 7 7
ROW5-> 0 0 0 3 3 3 4 4 4 8 8 8

Now I want to color those Cell whose values are repeating. Any idea will be a great help for me.

Posted 4-Jun-13 20:14pm

vishal deb

Add a Solution

Comments

kumar2413 5-Jun-13 2:16am

Post your sql statement to work out.for the value not repeating use DISTINCT and try.

vishal deb 5-Jun-13 2:21am

Thank You Kumar but I want to view this table with full data I don't want to use DISTINCT.
Here is the C# code of winform
public void check_conflict()
{
int rowCount=dataGridView1.RowCount;
int colCount=dataGridView1.ColumnCount;
string val1;
int c = 1;
for (int k = 0; k < rowCount - 1; k++)
{
for (int i = 1; i < colCount; i++, c++)
{
val1 = Convert.ToString(dataGridView1.Rows[k].Cells[i].Value);
for (int j = 1; j < rowCount - 1; j++)
{
string val2 = Convert.ToString(dataGridView1.Rows[j].Cells[i].Value);
if (val1 == val2 && (val1 != "" && val2 != ""))
{
DataGridViewCellStyle CellStyle = new DataGridViewCellStyle();
CellStyle.BackColor = Color.Red;
dataGridView1.Rows[j].Cells[i].Style = CellStyle;
}
}
}
}
Problem I facing with code is it is only comparing 1 Row with others

lukeer 5-Jun-13 2:48am

Place this code in your question. Use the "Improve question" link for that and enclose code in <pre lang="c#">YourCodeHere();</pre> tags to make it easily readable.

kumar2413 5-Jun-13 2:35am

What you should actually compare?

vishal deb 5-Jun-13 2:46am

You can see the table in my post where I have made everything clear
Take Example No. 1. ROW1 and ROW4 is having same values that is 2 2 2 again ROW1 and ROW2 have same value 6 and again ROW1 and ROW2 and ROW4 have same value 7 7 7 so now I want to color them with RED color as showing the conflicts.
Take Example No. 2. ROW2 and ROW3 have same value 1 1 so I want to color them in RED to show the conflict.
I hope now my intention is clear

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)

lukeer · Accepted Answer · 2013-06-04T20:56:00

C#

for(int comparerRow = 0; comparerRow < rowCount - 1; comparerRow++)
{
    for(int compareeRow = comparerRow + 1; compareeRow < rowCount; compareeRow++)
    {
        for(int columnIndex = 0; columnIndex < columnCount; columnIndex++)
        {
            // Comparison and visual effect
        }
    }
}

The important part is that the inner row loop has to depend on the outer row loop's iteration variable. So it won't start from the beginning over and over again.