Capture which cell in dgv is changed using bindingsource

Question

0.00/5 (No votes)

See more:

I have a Datagridview binded to bindingsoure

after I do manipulation on the data in bindingsource and refresh the datagridview some cells value is changed, I want to know which cell is changed

'ID Name Age << DATA
' 1 ABC   17
' 2 DEF   20
' 3 GHI   30

Dim dt = GetDataFromSqlServerForTableCustomer()
Dim bs As New BindingSource
bs.DataSource = dt

dgv.DataSource = bs




'If I code this for example
bs(2)("Age") = 33
bs.ResetBindings(False)
'row(2).cell(2) will changed and became 33

'ID Name Age << DGV
' 1 ABC   17
' 2 DEF   20
' 3 GHI   33



'If I code this for example
bs(1)("Age") = 25
bs.ResetBindings(False)
'row(1).cell(2) will changed and became 25
'ID Name Age << DGV
' 1 ABC   17
' 2 DEF   25
' 3 GHI   30

I want to capture which cell in the dgv is changed and make its backcolor to red
How to capture which cell is changed?

What I have tried:

CellValueChanged or CellValueNeeded are not triggerd when dgv cell value changed

Posted 16-Apr-21 22:31pm

Samir Ibrahim

Updated 17-Apr-21 0:49am

Add a Solution

Comments

Jo_vb.net 17-Apr-21 5:37am

CellValueChanged or CellValueNeeded are not triggerd when you refresh the datagridview.

Try manipulation on the data in the datagridview.

Samir Ibrahim 17-Apr-21 6:34am

@jo_vb.net : That will be a little hard since I give an example, but my actual need requite finding max depending on criteria so my actual manipulation is on the data

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)

Samir Ibrahim · Answer 1 · 2021-04-17T00:49:00

I Solve it using a collection, but I have to loop twice to all datagridview cells

Dim dt = GetDataFromSqlServerForTableCustomer()
Dim bs As New BindingSource
bs.DataSource = dt
dgv1.DataSource = bs

coll = New Collection

'Read DGV into Collection
For i = 0 To dgv1.Rows.Count -1
   For j = 0 To dgv1.ColumnCount -1
        coll.Add(dgv1(j,i).Value,i.ToString+j.ToString)
   Next
Next

' DO Data Manipulation
bs.ResetBindings(False)

' Compare DGV after update with Collection
For i = 0 To dgv1.Rows.Count - 1
    For j = 0 To dgv1.ColumnCount - 1
        If coll(i.ToString+j.ToString) <> dgv1(j,i).Value
            dgv1(j,i).Style.BackColor = Color.MistyRose
        End If
    Next
Next

I wonder if there is better way to do it.