how to handle exceptions of sqlserver in c# .net

Question

0.00/5 (No votes)

See more:

Hi,
This is dinakar. Please tell me how to handle exceptions of sql server using its error number while we are connecting to sqlserver using c#.net code...please help me out

Posted 23-Jun-11 23:15pm

Member 7962316

Add a Solution

3 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)

Dylan Morley · Accepted Answer · 2011-06-23T23:47:00

Solution 3

You can catch for SqlExceptions and check the numbers

The numbers are defined here
http://msdn.microsoft.com/en-us/library/aa937595%28v=sql.80%29.aspx[^]

C#

try
{
    // Code to access DB
}
catch (SqlException ex)
{
    switch (ex.Number)
    {
        case 2764:
            // do something when error 'Incorrect password supplied for application role' is thrown
            break;
    }
}

Posted 23-Jun-11 23:47pm

Dylan Morley

Comments

Member 7962316 24-Jun-11 5:49am

thanks you so much

thatraja 24-Jun-11 6:18am

BTW you can vote his answer.

thatraja 24-Jun-11 6:18am

Spot on, 5!

Christian Graus · Accepted Answer · 2011-06-23T23:34:00

Solution 1

If SQL Server throws an exception, you can catch it, and examine the exception for the error number. If a number occurs within a stored proc and you catch it in SQL Server, you can return the error number. I'm not sure what else you are trying to ask ?

Posted 23-Jun-11 23:34pm

Christian Graus

Comments

Member 7962316 24-Jun-11 5:41am

please give me example in c#.net for catching exception by using error number of sql server . for example i am opening sqlconnection as
try
{
sqlconnection con=new sqlconnection();
con.open();
------
con.close()
}

catch()
{

}
please tell me how to handle exception with error number for the above code

OriginalGriff · Accepted Answer · 2011-06-23T23:39:00

Solution 2

Put a try...catch block around teh code which is accessing it, and examine the exception in the catch block. There is no specific part of an exception that is the error number: you will have to work from the exception type and message.

try
   {
   // Code to access DB
   }
catch (Exception ex)
   {
   ///Handle error here
   }

Posted 23-Jun-11 23:39pm

OriginalGriff

Comments

Member 7962316 24-Jun-11 5:48am

i mean give example with error number and handling it