一,在数据查询过程中实现事物处理 程序很简单,两个按钮一个开始连接,一个结束连接,画面忽略代码如下 SqlConnection conn; private void Form1_Load(object sender, EventArgs e) { conn = new SqlConnection("Data Source=localhost;Initial Catalog=PMS;Integrated Security=SSPI;"); conn.StateChange += new StateChangeEventHandler(conn_StateChange); } void conn_StateChange(object sender, StateChangeEventArgs e) { MessageBox.Show("Original State:" + e.OriginalState.ToString() + "/nCurrent State:" + e.CurrentState.ToString()); switch (e.CurrentState) { case ConnectionState.Open: this.btnOpen.Enabled = false; this.btnClose.Enabled = true; break; case ConnectionState.Cl