Catch SqlClient.SqlException : SqlException « ADO.Net « C# / CSharp Tutorial






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();
            }
         }
   }
}








32.27.SqlException
32.27.1.Catch SqlClient.SqlException
32.27.2.Catch SqlException when opening connection
32.27.3.Loop through all errors