error handler in c#/sql

Question

1.00/5 (1 vote)

See more:

Hi,
My stored procedures have error handling as follows:

SQL

BEGIN TRY
--sql UPDATE...
END TRY
BEGIN CATCH 
	declare @msg nvarchar(200)
	SET @msg = ('Error during population of data...')

	SELECT
        	ERROR_NUMBER() AS ErrorNumber,
		ERROR_MESSAGE() AS ErrorMessage
		@msg;
END CATCH

Question:
From the C# code, I execute the SP.
If there is an error in the update query, then the C# code does not seem to ge the error_mesage from the SP.
So, should I use the raiserror or something similar instead of the select in the begin catch section?
Thanks

Posted 5-Mar-13 3:31am

arkiboys

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

willington.d · Answer 1 · 2013-03-05T03:41:00

Solution 1

use SqlException in Catch section to get Sql error.

C#

try
{
 //Call your SP here
}
catch (SqlException ex)
{
    lblEreMsg.Text = ex.Message;
}
<pre></pre>

Posted 5-Mar-13 3:41am

willington.d

S. M. Ahasan Habib · Answer 2 · 2013-03-05T16:09:00

Yes actually you handle exception from your stored procedure. So you are not getting that exception from .NET application. Yes you are correct. If your application need to know the exception then you can use raiseerror function.
Raise Error Details

You can also your throw statement. tsql throw Example

SQL

declare @i int;
begin try
	set @i = 'a';
end try
begin catch
 print 'Error: ' + error_message();
 throw;
end catch