How to handle sql exception in C#?

Question

I am using catch block with SqlException, but I want to show custom messages rather than exception itself. So how do I filter out the messages. Like say I want to catch a Unique Key Constraint Violation. Is there some error code which i can use to determine the error.

 protected void Button1_Click(object sender, EventArgs e)
        {
            try
            {

                objuser.username = txt_email.Text;
                objuser.email = txt_username.Text;
                objuser.password = txt_password.Text;
                int i = BusinessUser.BusinessRegisterUser(objuser);
                if (i > 0)
                {
                    Session["user_authenticate"] = "Verified";
                    Session["user_email"] = objuser.email; //  sql exception handle for uniqe key
                    Response.Redirect("user_registration.aspx");
                }
            }
            catch (SqlException ex)
            { 
              // Handle Exception here if e-mail already exists
            }
            catch (Exception ex)
            {

            }

        }

nvoigt · Accepted Answer · 2013-10-21 10:56:50Z

2

You can check the Number property of your SqlException. A full list of possible errors can be found here.

answered Oct 21, 2013 at 10:56

nvoigt

77.7k28 gold badges103 silver badges156 bronze badges

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

Collectives™ on Stack Overflow

How to handle sql exception in C#?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related