How to catch a stored procedures exceptions in a code behind using C#.Net?

        public voidDisable_Grid_Contents()

        {

            strcon = GetConnectionString(DB);



            con = new SqlConnection(strcon);



            cmdselect = new SqlCommand();



            cmdselect.CommandText = "dbo.Get_Pattern";



            cmdselect.CommandTimeout = 0;



            cmdselect.CommandType = CommandType.StoredProcedure;



            cmdselect.Connection = con;

 



            try

            {

                con.Open();



                cmdselect.ExecuteNonQuery();

            }

            catch (SqlException ex) 

            {

                lblErrorMessage.Text = ex.Message;  //Your Error willl be display in a Label

            }

            finally

            {

                if (con != null)

                {

                    con.Close();

                }



            }

        }

Thank you for posting at Dotnetfunda
[Administrator]