How To Rearrange The Auto Number Datatype Using C#

Dec 9 2012 3:26 AM
I Have A Database Of MS-Access.In That I Have Taken S.No. As Auto Number DataType..
I Had Inserted Some Data..Now For Each Row An Auto Number Is Generated In A Sequencial Order For Example: 1,2,3 To so on...Now If I Delete A Row Which Is In The Middle Of All The Rows(Record), For Suppose I Have 1 2 3 4 5 6 7 8 9 10 Records Are There. If I Deleted 5th Record,Then In The S.No. Column(AutoNumber DataType) It Shows Only 1 2 3 4 6 7 8 9 10 by Missing The Deleted Number.

Now My Question Is That Can We Rearrange The S.No. Column Order As 1 2 3 4 5 6 7 8 9  in The MS- Access Database Using C# Windows Application.

pls Help Me..


Answers (2)