how to use the InfoMessage event : SqlConnection Event : ADO.Net C# Examples

    
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=localhost;database=Northwind;uid=sa;pwd=sa");
                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();
        }
}