add a row in a specific position in a bound datagridview and ACCESS DB

giovanni

Hi there,

my problem, I guess, is very simple. I've implemented a record Copy&Paste mechanism in a bound DataGridView.
When paste a record (by means of InsertAt(DataRow, pos)) the record is inserted in the correct "pos" position in the DataGridView.
However, phisically, in the MS ACCESS DB the position is not retained and the record is appended to the bottom.
So when the DataGridView is closed and then reopened the record appears as last record, while I would like to keep the original inserting position in the DGV.

Is there any way to solve this problem, without adding a new column to the database table and handle the inserting order?

Thanks in advance & Ciao

Giovanni

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair15y ago
If the query got resolved, then mark the post that helped you as Answer so will be helpful for others.
Sam Hobbs15y ago
Is there no primary key for the table? It will be much easier if you let the software do the details by specifying a primary key and sort the DataGridView's data source by the primary key. If that is not possible, then you can sort the DataGridView's data source by some other data and if there is not some other data to do that with, then yes create a new column. Note however that it sounds like you intend to make it more work than it needs to be.