giovanni

giovanni

  • NA
  • 4
  • 0

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

Feb 23 2011 6:38 AM
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

Answers (2)