Hi,

I have a datagridview bound to a datatable, I want to check which rows have been updated and then update my database.

I have this

Dim dt As DataTable = dgMarketingWebsites.DataSource

For Each r As DataRow In dt.Rows
If r.RowState = DataRowState.Modified Then
' Do update here
End If
Next

The problem is that the state always seems to be added, even if changes have been made, am I missing something?


Thanks