How do I continue execution after a primary key violation exception is returned?
I am executing multiple inserts and if an exception is returned I want to continue with the next insert.
'Setup Local Variables
For Each oRow as DataRow In datTable.Rows
'If a primary key exception occurs, how do I jump back into this loop?
'Insert into another table
Catch ex As SqlException
'Do I do something here?
Catch ex As Exception
Do I need to user a couter loop and hold the index and return?
Do I need to user and "On Error...Resume Next" block?