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

Question

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

Suthish Nair · Answer

If the query got resolved then mark the post that helped you as Answer so will be helpful for others.

Sam Hobbs · Answer

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.