title: auto number ID column in datagridview from sql column and become auto count after delete any rows c#?
body: <ul>
  <li><p>hello all , i wanna create Table in sql Server (Ex: employe) this table have columns (ID, FName, LName, age ..etc</p>
  
  <ul>
  <li>i need ID column add auto number for each new row automatic.
  i Set the Identity specification to yes like this :
  <a href="https://stackoverflow.com/a/5669229/6084936">Identity specification</a></li>
  </ul></li>
  </ul>
  
  <p>but if did this setting in ID column i will face another issue like this picture :  <a href="https://i.stack.imgur.com/5xWsi.jpg" rel="nofollow noreferrer">open this picture</a></p>
  
  <ul>
  <li>now how to make ID column become auto count after delete any rows?</li>
  </ul>
  
  <p>so i thought i should make a loop to add new number in ID value every new record .
  and count the ID column every deleting row to reset the list of number in ID column .</p>
  
  <p>i think my idea is clear now . so any help in this to make it work . i'm using c# .</p>