Csharp/CSharp Tutorial/ADO.Net/SqlConnection Event

Материал из .Net Framework эксперт
Версия от 12:19, 26 мая 2010; Admin (обсуждение | вклад) (1 версия)
(разн.) ← Предыдущая | Текущая версия (разн.) | Следующая → (разн.)
Перейти к: навигация, поиск

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=localhost;database=Northwind;uid=sa;pwd=sa");
        mySqlConnection.InfoMessage += new SqlInfoMessageEventHandler(InfoMessageHandler);
        mySqlConnection.Open();
        SqlCommand mySqlCommand = mySqlConnection.CreateCommand();
        mySqlCommand.rumandText = "PRINT "This is the message from the PRINT statement"";
        mySqlCommand.ExecuteNonQuery();
        mySqlCommand.rumandText = "RAISERROR("This is the message from the RAISERROR statement", 10, 1)";
        mySqlCommand.ExecuteNonQuery();
        mySqlConnection.Close();
    }
}

Listen to Connection state changed event

using System;
using System.Data;
using System.Data.SqlClient;
    class Program
    {
        static void Main(string[] args)
        {
            string sqlConnectString = "Data Source=(local);Integrated security=SSPI;Initial Catalog=AdventureWorks;";
            SqlConnection connection = new SqlConnection(  );
            connection.StateChange += new StateChangeEventHandler(connection_StateChange);
            connection.ConnectionString = sqlConnectString +
                "Connection Timeout=15;Connection Lifetime=0;" +
                "Min Pool Size=0;Max Pool Size=100;Pooling=true;";
            Console.WriteLine("Connection string = {0}",connection.ConnectionString);
            connection.Open();
            connection.Close();
            connection.ConnectionString = sqlConnectString +
                "Connection Timeout=30;Connection Lifetime=0;" +
                "Min Pool Size=0;Max Pool Size=200;Pooling=true;";
            Console.WriteLine("\nConnection string = {0}",connection.ConnectionString);
            connection.Open();
            connection.Close();
        }
        static void connection_StateChange(object sender, StateChangeEventArgs e)
        {
            Console.WriteLine("\tOriginalState = {0}", e.OriginalState.ToString());
            Console.WriteLine("\tCurrentState = {0}", e.CurrentState.ToString());
        }
    }

Using ADO.NET Events

using System;
using System.Data;
using System.Data.SqlClient;
class MainClass
{
  static void Main(string[] args)
  {
    SqlConnection MyConnection = new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;");
    MyConnection.StateChange += new StateChangeEventHandler(OnStateChange);
    MyConnection.Open(); //Trigger Open Event
    MyConnection.Close();
  }
  public static void OnStateChange(object sender, System.Data.StateChangeEventArgs e)
  {
    Console.WriteLine("Connection State Chnaged: {0}", ((SqlConnection)sender).State);
  }
}
Connection State Chnaged: Open
Connection State Chnaged: Closed