Quote Originally Posted by ebellounisoft View Post
Please read this of my post:

Before exit I Delete row, Save and Refresh Data.

4. Select row 78 and click X button (Delete row). Refresh DataSet in DataCode window. Checked with query SELECT * FROM Products in Microsoft SQL Management Studio. It is ok. Only 77 rows as the original database.
Refreshing the dataset doesn't do anything except update it with any changes from the database, such as adding or removing columns. So that isn't doing anything at this point.

Quote Originally Posted by ebellounisoft View Post
Done that every time I open again. When I click save instead of 78 it keeps increasing , and changes the database. Right now I in row 130 !!!. But if I Delete, Save and Refresh the Database is the original. I Checked it with query SELECT * FROM Products in Microsoft SQL Management Studio
Putting your posts in bold doesn't do anything either except it's just short of shouting (all caps) ... But it also still doesn't change the fact that the ID is being generated by the database, as has been explained time and time again to you. When you delete a record, that ID is gone. G.O.N.E. It doesn't come back. You still haven't explained why this is a problem. Usually by this point in the discussion, the poster that has had a "problem" with is has gotten a clue and understands that that's how they work and moves on... for some reason you won't let it go. There must be a reason why. Instead you just keep restating that your ID keeps increasing, which we all get because we understand that's how it works. So we fail to see the problem.

-tg