Updating modified rows in a dataset

[discovery]

Hi All,

I have a dataset which is bind to a datagridview. When changes are made and that dataset is modified, i want to edit the dataset and update two datarow with WHO did the change and WHEN did the change occur.

Plz help. Thanks

[discovery]

Solution found !!
What i did is create a new dataset and stored only modified rows in it. Then edit the new dataset modify the two datarows.

myds = ds.GetChanges(DataRowState.Modified)
            For Each dr In myds.Tables("mytablename").Rows
                dr.BeginEdit()
                dr("UpdatedBy") =loggedUsername
                dr("UpdatedWhen") = tday.now()
                dr.EndEdit()
            Next

*****
Hope it will someone else.