how to use the InfoMessage event : SqlConnection Event « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. SqlConnection 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=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();
    }
}