'Is it possible to reset sql auto increment that connected with vb net updated upon delete

I have this datagridview that connected to localdb and I have this ID column with primary key and auto increment When I delete a record, I want, from 1 2 3 4 5 6 7(Deleted) -> 1 2 3 4 5 6 8

to

1 2 3 4 5 6 7 8(Deleted) to keep the 8 for the next record and so on thank you



Sources

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

Source: Stack Overflow

Solution Source