Problem with Try/Catch/Finally

Lekker Ou

I;m a little new to C# and I've got the following problem. Any help will be really appreciated.

I'm reading a csv file and insering the data into a MySQL Database. I am not to concerned about
records that dont get added to the DB. Unfortunatly when there is an error on the insert due to
problems in the csv file my loop stops working.

Flow is as follows

try
{
  read loop
{
   set up SQL string and do insert
}
catch(ODBCexception)
{
   and in here I would like to go and read the next record in the read loop and continue processing.
}

I've tried putting a goto in the catch to a label inside the read loop but i get an error about the
goto not referencing a a label in its scope. So I'm a little bit stuck at the moment.

I'm kinda looking for something like VB6's "On error resume next".

Thanks in advance

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Lekker Ou21y ago
Thanks man,
Works like a charm.
I suppose its all about learning the complete structure of a language when doing things. I'm still a little
stuck on VB6's ways.
Andrew Wooster21y ago
Put the try/catch into the loop...then when there's an error you can log it (or whatever) but it will still go to the next part of the loop

ie

read loop
{
   try
   {
      'set up command text and do insert
   }
    catch
    {
        'log error or whatever
    }
}