'Microsoft Sql Server Decrement [duplicate]

So I have this C# applicaiton and it uses a SQL Server database to show information on a DataGridView. My autoincrement column works fine but when I delete a value it doesn't get decremented by one.

For example I add one value lets say its ID=1 the next value is ID=2 then I delete a value using a winforms button. And the next value I add instead of being ID=2 its ID=3

So my question is, how do I decrement by one after I delete a value using C#? I have read I can do it through the SQLquery but I want it to be automatic so when a user deletes a value it auto decrements.

c++sharpsql-serverdatabasewinformsdatagridview


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions