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?