I am having a strange problem when updating new added records in the grid.
I use the code below to cycle through the grid and change the ClientId to p_ClientId which works fine. This is why the msgbox is there to check the value which changes to the value in p_ClientId as expected. You can also see this reflected in the grid itself as the column is visible.
For i = 0 To Me.RadGridView1.RowCount - 1
Me.RadGridView1.Rows(i).Cells("ClientId").Value = p_ClientId
The problems comes when I save the grid to the database using the code below.
The database only reflects the change in the last record. The others are added with a NULL in ClientId. This only affect this one field and only when adding a new record. If you update other fields directly using the grid then they update correctly.
Thank you so much for your help