Forums - C# Corner

Forum guidelines

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)

Download Free eBooks


Custom Software Development
MCN is your source for developing solutions involving websites, mobile apps, cloud-computing, databases, BI, back-end services and processes and client-server applications.