I have a question about updating a Data Grid control from a linked Data Table, usually an easy task. I guess I should begin by saying I know .Net 1.1 and VB 2003 are really old, but this is what the client is using and I'm stuck using it. Once this problem is solved, we start the upgrade to a newer version. Coding is in VB.

I have a data table where rows can be inserted at a location (index) other than at the end. The linked data grid always shows the insertion at the end of the grid. The order of contents in the grid is critical for this application and must match the order of rows in the table including the inserted rows that are not at the end of the table.

The table starts out with entries of the form
a
b
c
d

Then along comes a new entry and the table can look like
a
b
g (new entry)
c
d

The grid will then look like
a
b
c
d
g

Does anyone know how to make the grid update so that it reflects the order of the rows in the table after insertion at an arbitrary location (index)? In the example, the grid should show g following b, not at the end.

I've tried a number of things that seemed "obvious", but nothing has worked.

All replies welcome.