So i am trying to clear a datatable using the .clear() method for the table.
The issue i am running into is even though the table is cleared and there is no data in it i am getting an exception when i try to add data back into it.
Column 'DelayId' is constrained to be unique. Value '2440' is already present.
so it seems like there is data already there, but when i check the row count before this code is executed it is 0. also i have tried .AcceptChanges() after the clear and it doesnt seem to make a difference.
I must be missing somethign stupid. Please help Thanks