Catch SqlClient.SqlException : SqlException : ADO.Net C# Examples

    
using  System;
using  System.Data;
using  System.Data.SqlClient;

class  MainClass
{
      static  void  Main()
      {
                  SqlConnection  conn  =  new  SqlConnection(@"data  source  =  .\sqlexpress;integrated  security  =  true;database  =  northwind");

                  SqlCommand  cmd  =  conn.CreateCommand();

                  cmd.CommandType  =  CommandType.StoredProcedure;
                  cmd.CommandText  =  "sp_DbException_1";

                  try
                  {
                        conn.Open();
                        cmd.ExecuteNonQuery();
                  }
                  catch  (System.Data.SqlClient.SqlException  ex)
                  {
                        Console.WriteLine("Source:  "  +  ex.Source);
                        Console.WriteLine("Number:  "+  ex.Number.ToString());
                        Console.WriteLine("Message:  "+  ex.Message);
                        Console.WriteLine("Class:  "+  ex.Class.ToString  ());
                        Console.WriteLine("Procedure:  "+  ex.Procedure.ToString());
                        Console.WriteLine("Line  Number:  "+ex.LineNumber.ToString());
                        Console.WriteLine("Server:  "+  ex.Server.ToString());

                  }
                  catch  (System.Exception  ex)
                  {
                        Console.WriteLine("Source:  "  +  ex.Source);
                        Console.WriteLine("Exception  Message:  "  +  ex.Message);
                  }
                  finally
                  {
                        if  (conn.State  ==  ConnectionState.Open)
                        {
                              Console.WriteLine("Finally  block  closing  the  connection");
                              conn.Close();
                        }
                  }
      }
}