title: Add a new Column in database which should have auto increment property
body: <p>I need to add a column name Serial Number to my one of the database table,so that it should increment for each data,How to write this code in asp.net with c# </p>
  
  <p>My connection string is as shown below</p>
  
  <pre><code>    cn.ConnectionString = @"Data Source=BOPSERVER;Initial Catalog=Project;Integrated Security=True";
  </code></pre>
  
  <p>My database table is shown as below</p>
  
  <pre><code>   FID          varchar(10) Checked
     Placework    varchar(50) Checked
     DOJ          datetime    Checked
     Institute    varchar(50) Checked
     Year         numeric(18, 0)  Checked
    Duration          varchar(50) Checked
    Lastpost          varchar(50) Checked
    WorkingArea   varchar(50) Checked
    UpdateDate    datetime    Checked
  </code></pre>
  
  <p>In this table i need to add another column Sr.no that should automatically increment for every input and also FID and Sr.no should be composite primary key</p>