get sql error code in code behind in asp.net C#

Question

So, I am getting an exception in Stored Procedure whose error code is 547. I have created a data diagram in sql server, where I have defined the relationships.when I run the any delete SP I get an error saying FK conflict, which is right. My problem is how do I get the number(i.e 547) in my C# code.

catch (Exception ex)
        {

            lblMessage.Text = ex.Message;
        }

I sthere any way where I can get this 547 code in my C# code.? Like

 ex.somethin (which gives me the error message's code).

Raghubar · Accepted Answer · 2013-08-19 06:49:02Z

4

Try This.

    try
    {

    }
    catch(SqlException ex)
    {
        lblMessage.Text = ex.Message;
    }

answered Aug 19, 2013 at 6:49

Raghubar

2,7981 gold badge23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ankur Over a year ago

but what if I get an exception other than sql exception.? Can I not use Exception and still get error code.?

Ankur · Accepted Answer · 2013-08-19 09:07:42Z

2

Multiple catches can be used:

 try
        {

        }
      catch(SqlException sqlex)
        {
          if(sqlex.Number ==547)
               {
                   //code
               }
        }
        catch(Exception ex)
        {
            lblMessage.Text = ex.Message;
        }

edited Aug 19, 2013 at 9:07

answered Aug 19, 2013 at 7:17

Ankur

1,0217 gold badges27 silver badges44 bronze badges

Comments

Alex · Accepted Answer · 2013-08-19 06:47:05Z

1

You can try using Elmah library (Error Logging Modules And Handlers)

Here is a step by step tutorial on how to use it: http://www.asp.net/web-forms/tutorials/deployment/deploying-web-site-projects/logging-error-details-with-elmah-cs

answered Aug 19, 2013 at 6:47

Alex

6,20913 gold badges46 silver badges81 bronze badges

1 Comment

Marco Over a year ago

Related to this: Take a look at bitbucket.org/wasp/elmahr/wiki/Home. This is a dashboard to observe errors in your applications in realtime and does not require you to implement more then Elmah into your application. Comes in real handy!

Ajay · Accepted Answer · 2013-08-19 07:27:42Z

1

For more details http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlexception.aspx

 try
 {
   ... 
   ...
 }
 catch(SqlException ex)
 {
    lblMessage.Text = ex.Message;
 }

answered Aug 19, 2013 at 7:27

Ajay

6,59818 gold badges83 silver badges135 bronze badges

Collectives™ on Stack Overflow

get sql error code in code behind in asp.net C#

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related