How to use the InfoMessage event : SQL Events « Database ADO.net « C# / C Sharp

1. C# / C Sharp
2. Database ADO.net
3. SQL Events

How to use the InfoMessage event

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

class InfoMessage
{
  public static void InfoMessageHandler(object mySender, SqlInfoMessageEventArgs myEvent)
  {
    Console.WriteLine("The following message was produced:\n" + myEvent.Errors[0]);
  }

  public static void Main(){
    SqlConnection mySqlConnection = new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;");

    mySqlConnection.InfoMessage += new SqlInfoMessageEventHandler(InfoMessageHandler);

    mySqlConnection.Open();

    SqlCommand mySqlCommand = mySqlConnection.CreateCommand();

    mySqlCommand.CommandText = "PRINT 'This is the message from the PRINT statement'";
  
    mySqlCommand.ExecuteNonQuery();

    mySqlCommand.CommandText = "RAISERROR('This is the message from the RAISERROR statement', 10, 1)";
  
    mySqlCommand.ExecuteNonQuery();

    mySqlConnection.Close();
  }
}
           
       

Related examples in the same category