I have xam grid which populates data as

ID   Field1     Field2   Field3

1  FName1 LName1  U

2  FName2 Lname2   E

3  FName3 LName3  U

Now the user updates the data for ID 1 from U to E

The database then makes a record with new entry as

4 FName1 Lname1 E

So if any of the entry with U is overwritten with E the grid is supposed to show record with E and not U

So I should get record in grid as

ID   Field1     Field2   Field3

4  FName1 LName1  E

2  FName2 Lname2   E

3  FName3 LName3  U

When he resets with button it should show

ID   Field1     Field2   Field3

1  FName1 LName1  U

2  FName2 Lname2   E

3  FName3 LName3  U

But this isnt happening

If the user edits data the id still in the UI is 1 and not 4 for the reset to work

What should be done how to refresh grid with the new ID?!