Solved

How to neglect exceptions?????????

Posted on 2008-10-25
1
219 Views
Last Modified: 2013-12-17
Hi Experts,

              In my code i am fetching some records from a table and doing some task on the fetched data in a loop. I am doing it in try catch block.

             Suppose 100 records are fetched by the query and processing is being done in a loop. now after processing suppose 20 records an exception occurs(SQL exception or any general exception due to wrong data in the record) while processing 21st. Then the execution of the loop will transfer to catch block. so next 80 records will  remain unprocessed.

            What I want is to continue the loop for processing next record instead of breaking it when exception occurs.

I am not sure it is possible or not. If it is then how to do it?


Thanx in advance.

Regards,
Paramhans
0
Comment
Question by:Paramhans
1 Comment
 
LVL 13

Accepted Solution

by:
TechTiger007 earned 500 total points
ID: 22802065
add a try catch block inside the loop and ignore the exception there

for(...)
{
 try{
//your code goes here
}
catch
{
 continue;
}
}
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now