System.Data.SQLite

Hi, i have made a data source connection to a very simple database, UserID, Firstname and Lastname. I dragged the dataset onto the form and all looks well, i can add users and save records correctly.

But if i enter a new row, enter some details, then click to enter a new row the autonumber is incremented correctly, for example to 6. I then click off (and cancel the insert), i click back into the row to enter a new record and the number is now 7, even though the last row was not commited.

Is this by design, my bad code, or a bug? Any ideas?

Cheers,

Chris

Sorry what i mean is this:

I have a number of rows entered, IDs 0-5 used, with name details for each row, thats ok. I then click to add a new row in the bottom of the datagrid, the ID is incremented to 6. I dont enter any data but instead click elsewhere thus canceling the comit. I then click back into the bottom of the datagrid and instead of 6 being used the ID is now 7, (i think it should be 6 as that record was never actually comitted).

Furthermore, if the form is closed and re-opened, when i click to enter a new row it will go back to using the ID 6 which is correct. sorry for the confusing explanation.

Chris