I have a column called PositionNumber in my grid. There
is also a button on my grid called "Renumber Positions."
When a user clicks on this button the value of PositionNumber
in all rows changes. This change is made through code by doing
grd(intRow, intCol) = <new value>.

The change appears in the grid and I save my changes through
a data adapter. But when I look at this data in the database
or even when I reload this data back into the grid, I still
see the old values. I even checked to see if the da.Update
method updates the right number of records and it does

But why isn't this change showing up the database??

Another thing I noticed is that if I manually go through the
grid and make changes to this column then I will see the new
values in the database, but not if I do it through code..
does anyone know why this happening??

Any help is greatly appreciated

Thanks
Parvee

Whoops!! This is a double post! Sorry...