How To Rearrange The Auto Number Datatype Using C#

CHAITANYA KIRAN KASANI

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..

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

CHAITANYA KIRAN KASANI13y ago
ThanQ Vulpes For Your Information...I Will Refer It...
Vulpes13y ago
As you'll see from this Microsoft Support article, resetting an auto increment field in MS Access is not a simple matter:

http://support.microsoft.com/kb/812718

Rather than go through this rigmarole, it might be better not to physically delete rows but to find some other way of marking them as deleted such as blanking non-required columns or, if the row contains some sort of status column, setting it to 'deleted'.