System.Data.OleDbException (0x80004005): The changes you requested to the table were not successful because they would create duplicate values in the index, primary key..."
I know how to catch all exceptions. But I want to catch THIS SPECIFIC ONE so I can call one of my subroutines to generate a different ID that will not violate the primary key.
One TEMPORARY solution I've already applied was to query the database to find all existing distinct IDs, and them to a list, and continuously generate an ID that hasn't been used yet by checking if the list .contains it already (via a do while loop). However, I don't want to create a data type that could possibly house thousands of IDs.
Thanks in advance!