Description:
I use MySQL Connector/NET 5.0.1 with VS.NET 2005 and i'm trying to insert a new row in a table with DataAdapter.Update(DataDable) method.
I take the max value of the auto increment column and i put it to the corresponding field of the new row, increasing that value by 1(+1).
The update completes succesfully, but when i reload tha data, i see that the value of the field in the last new inserted row is different.
I Catch that, an auto increment column is not accepted values different than the sequence of increment when new row added in a table.
I inform you that the step of the auto increment column is 1 (step=1) and (column.AutoIncrementSeed=MaxValue+1), besides i was running the same source code with MySQL Connector/NET 1.0.7 and there was no problem.
I hope to help me with that because the new MySQL Connector/NET 5.0.1 is more powerfull and has many features that is very usefull.
Keep going with good works.
How to repeat:
You must have VS.NET 2005, MySQL Connector/NET 5.0.1, MySQL Server 5.0.24a, Windows XP sp2.
Create a table with primary key auto increment column and more other columns, bind it in a Windows Form DataGridView and insert new rows increasing the coresponding field of the auto increment column with the max value plus 1, then call the DataAdapter.Update(DataDable) after that delete some rows, repeat that a few times and reload the datatable.
You'll see that the auto increment column insists it's own way increment...
