continue execution after try/catch

  • Thread starter Thread starter E. Kwong
  • Start date Start date
E

E. Kwong

I have a For loop to insert record to a SQL server database, like:


For Each item As ListItem In cblxyz.Items
If (item.Selected) Then
.... do something
Try
srcxyz.Insert()
Catch SQLExp As SqlException
....display error
End Try
End If
Next



Now when a duplicate record is encountered, it displays the error and then
stops. I need the loop to go on after displaying the database error. Is
there any way to do that? Or do I have to check whether the record is
already existing in the database every single time before doing the Insert?



Any insight appreciated.



I'm using VS2005, SQL Server 2000, .Net 2.0
 
What do you mean by "it stops".

If the Catch doesn't do anything to cause execution to go anywhere
else, execution should resume after the End Try.

Set a breakpoint on the Catch and step it to see what happens.
 
E. Kwong said:
I have a For loop to insert record to a SQL server database, like:


For Each item As ListItem In cblxyz.Items
If (item.Selected) Then
... do something
Try
srcxyz.Insert()
Catch SQLExp As SqlException
....display error
End Try
End If
Next



Now when a duplicate record is encountered, it displays the error and then
stops. I need the loop to go on after displaying the database error.
Is there any way to do that? Or do I have to check whether the record is
already existing in the database every single time before doing the
Insert?



Any insight appreciated.



I'm using VS2005, SQL Server 2000, .Net 2.0
Click to expand...
How do you "display error"? In a message box, by any chance?
 
Thanks Jack Jackson and PvdG42.

It turns out that I did not get the correct checkboxlist value to create the
record.
 
Back
Top