Data Grid View Control Record Update Issue
Posted on 2006-11-01
I have a Data Grid View Control that displays data. I reference all the rows programatically for that grid and then populate data in their appropriate fields. It uses the bound data adapter and creates a command and then uses the update command to update the appropriate record.
The problem that I have is when I first load up the grid, the cursor is set to the first record in the grid. I was initially having a problems during the update on that first record. The update command executes successfully and then does so on the latter records. However, when i check the table, the data isn't updated for that 1 particular row.
I created a workaround to where I set focus to a cell in a different row than the row that is currently being updated so I always have my cursor on a row that ISN'T being updated.
However, if my dataset only has 1 row, I cannot set it to a different row, because it is the only row. I cannot add new rows because it is bound. How can I make the change and have the changes take effect for the row that i currently have active.