rainstone
asked on
Can Auto-Increment Column in DataTable decrement automatically?
hi guys,
Got a problem here when dealing with DataTable.
I have a datatable with an Auto-Increment Column that counts the number of rows in the datatable. It works perfect when I insert records to the datatable.
However, when I tried to delete some rows from the datatable, the Auto-Increment Column seems unwilling to decrement and the existing values in that column remain unchanged.
Is there anyway that the value can automatically increment and decrement as I insert or delete records into/from the datatable? Can somebody suggest?
Thanks heaps!
rainstone.
Got a problem here when dealing with DataTable.
I have a datatable with an Auto-Increment Column that counts the number of rows in the datatable. It works perfect when I insert records to the datatable.
However, when I tried to delete some rows from the datatable, the Auto-Increment Column seems unwilling to decrement and the existing values in that column remain unchanged.
Is there anyway that the value can automatically increment and decrement as I insert or delete records into/from the datatable? Can somebody suggest?
Thanks heaps!
rainstone.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have written my own codes to keep track of the sequence number of rows in the datatable. merci boucoup.