re arrange number

See more:

VB

hello everybody,

i am Jyotin.
i am creating a vb windows based project with ms access database.
i am using delete query which is working well.
but my problem is------
i want to re-arrange the datatable after deletion.
as-i have rows having slno 1,2,3,4,5,6.
after delting 1,5 row,it becomes 2,3,4,6.
i want that it should be 1,2,3,4 means remaining rows should be re-arrange staring from 1.

please reply.

thanks alot.