No announcements
Found 1053402 threads
-
2 VotesCatch SqlException
Harry, I think because you are opening the connection to SQL server outside (before) of the try-catch block.Answered | 4 Replies | 1318 Views | Created by harrytu - Friday, July 31, 2015 1:58 PM | Last reply by Berimi - Friday, July 31, 2015 5:09 PM
-
0 Votes
SqlException
You can also check the Number property of the sqlexception .Answered | 11 Replies | 3724 Views | Created by GoDaddy - Monday, January 12, 2009 3:27 PM | Last reply by CetinBasoz_Dont Trust Microsoft - Monday, January 12, 2009 7:04 PM -
2 Votes
RAISERROR not causing SqlException
RAISERROR causes a branch to the CATCH block which not surprisingly clears @@error.Answered | 6 Replies | 21648 Views | Created by Graham Hay - Tuesday, May 17, 2005 3:12 PM | Last reply by PetrKuzel - Wednesday, June 16, 2010 9:57 AM -
0 Votes
SqlException was unhandled
0) { //Atleast one row got affected by the query } } } } catch (SqlException ex) { //Log ...Answered | 5 Replies | 2769 Views | Created by sunil_sonu322 - Sunday, April 4, 2010 7:09 AM | Last reply by Yasser Zamani - Mr. Help - Sunday, April 4, 2010 10:31 AM -
0 Votes
SQLException in Exception Management Block
User-1502626911 posted Just make sure you specify that it is a SQL exception that you are catching.Unanswered | 1 Replies | 33 Views | Created by Anonymous - Monday, January 3, 2005 8:06 PM | Last reply by Anonymous - Friday, May 20, 2005 1:54 PM -
0 Votes
SqlException: Timeout expired error
to check, you can run sp_who or view the SQL Server Activity monitor if a service is blocking the other.Answered | 3 Replies | 9792 Views | Created by Sojborg - Wednesday, May 12, 2010 11:30 AM | Last reply by JuneT - Wednesday, May 26, 2010 10:53 AM -
0 Votes
Exception handling in blocks
That way you could make those blocks become faulted if an exception occurs deeper in the network.Answered | 9 Replies | 9618 Views | Created by Allan Lindqvist - Wednesday, February 9, 2011 12:16 AM | Last reply by Zlatko Michailov - MSFT - Thursday, February 10, 2011 9:24 PM -
0 Votes
code after the exception block
If the exception handler block does not Terminate / /Compensate / Throw Exception, the flow control is to the next shape after exception ...Answered | 3 Replies | 2556 Views | Created by Lakshmi Nag - Wednesday, February 1, 2012 3:23 PM | Last reply by Leonid Ganeline - Wednesday, February 1, 2012 5:16 PM -
0 Votes
Exception in finally block
Yes you can use another try catch block in the finally block, but what to do with the exception occurred in the finally block and handled in the catch ...Answered | 4 Replies | 2720 Views | Created by GurunGuns - Friday, June 25, 2010 8:54 AM | Last reply by Ashish Khandelwal - Friday, June 25, 2010 9:12 AM -
1 Votes
. + SQLException
You could copy this out and paste it into a query window in SQL Server Management Studio.Answered | 8 Replies | 10582 Views | Created by k amol - Wednesday, September 29, 2010 3:31 PM | Last reply by Dan Guzman - Thursday, February 6, 2020 2:25 PM -
0 Votes
SQLException not having instance of command that resulted into it
You can use the often overlooked Data property of the exception.Answered | 6 Replies | 2654 Views | Created by Hiral - Saturday, June 2, 2012 12:09 PM | Last reply by Hiral - Thursday, June 7, 2012 5:19 AM -
14 Votes
About the contracts in RX (exceptions and blocking)
If anything, you'll want to use try...finally blocks to ensure that state is cleaned up if an exception gets thrown.Answered | 26 Replies | 12333 Views | Created by Flavien Charlon - Friday, January 22, 2010 3:23 PM | Last reply by Dave Sexton - Tuesday, January 26, 2010 12:56 PM -
0 Votes
PSI: SqlException occurred in DAL
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at ...Answered | 19 Replies | 16157 Views | Created by fb75 - Monday, November 29, 2010 5:00 PM | Last reply by Devdumper - Friday, October 10, 2014 8:34 AM -
5 Votes
Question about Exception Handling.
In version 2003 I made often code like this for AdoNet Try AdoNetCode Catch exs as SQLException ..Handle ...Answered | 6 Replies | 3259 Views | Created by intertek - Saturday, March 13, 2010 2:09 AM | Last reply by intertek - Sunday, March 14, 2010 7:33 PM -
0 Votes
How to avoid Blocking Control exception?
If you can't avoid these pop up windows, you could work around them by catching the exception and adding the click in the catch block.Answered | 1 Replies | 3883 Views | Created by KChaitu - Monday, January 17, 2011 8:58 AM | Last reply by Srishti [MSFT] - Monday, January 17, 2011 9:15 AM -
1 Votes
c# exception handling
and these catch(es) should be in order, means lower catch block should NOT be a child of any catch block defined above.Answered | 5 Replies | 923 Views | Created by KAVITI LOKESH - Thursday, May 23, 2013 12:41 PM | Last reply by Faisal Ahmed Farooqui - Thursday, May 23, 2013 1:05 PM -
1 Votes
SqlException was unhandled by user code
Hello CodingBeginner, You should always be prepared to handle exceptions that may occur in your code by using Try catch ...Answered | 6 Replies | 5201 Views | Created by CodingBeginner - Friday, November 26, 2010 4:30 PM | Last reply by Mauro Castagnasso - Saturday, November 27, 2010 10:07 PM -
1 Votes
Accessing the Received filename into Biztalk exception block
Use the same file name variable in the exception block along with exception message or concatenation with required details, when you log the details, ...Answered | 3 Replies | 780 Views | Created by BizTalk1234 - Monday, May 23, 2016 1:51 PM | Last reply by SMSVikasK - Tuesday, May 24, 2016 6:26 AM -
2 Votes
Re-Throwing Exceptions and using a Finally block
using statement will do the proper cleaning even if an exception occurs inside the using block.Answered | 6 Replies | 10033 Views | Created by remarkpk11 - Tuesday, May 5, 2009 6:23 PM | Last reply by A.m.a.L Hashim - Tuesday, May 5, 2009 8:46 PM -
0 Votes
Catch a specific exception
You cannot create a separate catch block based on the exception details.Answered | 5 Replies | 1012 Views | Created by Girish Nehte - Tuesday, January 21, 2014 1:35 PM | Last reply by Molku - Wednesday, January 22, 2014 2:21 PM - Items 1 to 20 of 1053402 Next ›
No announcements
