using System; using System.Data; using System.Data.SqlClient; class SqlExceptionDemo { static void Main(){ string connString = "server=(local)SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI"; SqlConnection conn = new SqlConnection(connString); SqlCommand cmd = conn.CreateCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "wrong command"; try { conn.Open(); cmd.ExecuteNonQuery(); } catch (System.Data.SqlClient.SqlException ex) { string str; str = "Source:"+ ex.Source; str += " "+ "Number:"+ ex.Number.ToString(); str += " "+ "Message:"+ ex.Message; str += " "+ "Class:"+ ex.Class.ToString (); str += " "+ "Procedure:"+ ex.Procedure.ToString(); str += " "+ "Line Number:"+ex.LineNumber.ToString(); str += " "+ "Server:"+ ex.Server.ToString(); Console.WriteLine (str, "Database Exception"); } catch (System.Exception ex) { string str; str = "Source:"+ ex.Source; str += " "+ "Error Message:"+ ex.Message; Console.WriteLine (str, "General Exception"); } finally { if (conn.State == ConnectionState.Open) { Console.WriteLine ("Finally block closing the connection", "Finally"); conn.Close(); } } } }