How do I raise the CellValueChanged event from a datagridview when the datasource has changes

Question

0.00/5 (No votes)

See more:

Hi community,

I managed to bind a string[][] to a datagridview like this:

SQL

dataGridView1.DataSource = (from arr in test select new { Data = arr[0], Dog = arr[1] }).ToArray();

DataGridView1 = a dataGridView and test is a string[x][2] (yes I am using a jagged array for a rectangular matrix). I am happy with that and would like to keep it that way.

Now lets picture the following:

current datagridviewContent:

C#

         Col1     Col2
Row1     Marc     John
Row2     Anna     Susi

during the next update of my string[][] Susi changes to Alex like :

changed datagridviewContent:

C#

         Col1     Col2
Row1     Marc     John
Row2     Anna     Alex

Due to the change I would like an event to be raised that will give me both the row and column index of all changed cells - or even better I would like EACH affected cell to raise an event so that I can f.e. change the affected cells background colour.

I have tried using the inbuilt CellValueChanged event, but I believe this does not work, because i am not changing the respective cells individually, but update the datagridview using a datasource.
I have tried the DataSourceChanged event, but its EventArgs are generic and do not implement a row or column property.

How do I raise an event in this case that will give me the mentioned properties?
I am aware of writing my own events, but I would assume that visual studio already has an event implemented for a situation like this and I must admit in this particular case I am not sure how I would implement an event.

Help is appreciated, thank you all in advance.
Regards,

-DK

Posted 2-Sep-14 11:47am

KergalBerlin

Add a Solution

Comments

kbrandwijk 2-Sep-14 17:58pm

Why are you reposting part of your original question as new question here?

KergalBerlin 2-Sep-14 18:13pm

posted that one before I read your answer.
Thruth be told, I felt that Sergey Kryukov was trolling me in the other thread and I wanted to avoid "fun" responses and confusion. Besides, I feel I phrased my question better this time.

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)

kbrandwijk · Accepted Answer · 2014-09-02T12:20:00

1. Keep your old array of values
2. Read your new array of values
3. Extend your LINQ query to compare the two
4. Use the PaintCell event of the grid to look at the '...Changed' boolean to change backgroundcolor etc.

C#

string[][] origArr =
    {
        new [] {"A", "B", "C"},
        new [] {"D", "E", "F"},
        new [] {"G", "H", "I"}
    };

string[][] newArr =
    {
        new [] {"A", "B", "C"},
        new [] {"D", "X", "F"},
        new [] {"G", "H", "K"}
    };

var datasource = (from arrOld in origArr
                  from arrNew in newArr
                  select new
                  {
                      First = arrOld[0],
                      FirstChanged = arrNew[0] != arrOld[0],
                      Second = arrOld[1],
                      SecondChanged = arrNew[1] != arrOld[1],
                      Third = arrOld[2],
                      ThirdChanged = arrNew[2] != arrOld[2]
                  });