Mega Code Archive

 

Categories / C# Tutorial / ADO Net

 

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