Re-arrange the datatable

See more:

SQL

Microsoft

hello everybody,

i am sakshi.
i am creating a c#.net windows based project with ms sql 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 primary key 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.