Mega Code Archive
How to use the InfoMessage event
<![CDATA[
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();
}
}
]]>