Ado.net2.0中的事务处理

 SqlConnection myConnection = new SqlConnection("Server=(local);Initial Catalog=Demo24;uid=sa;pwd=111;"); myConnection.Open(); // 启动一个事务 SqlTransaction myTrans = myConnection.BeginTransaction(); // 为事务创建一个命令 SqlCommand myCommand = new SqlCommand(); myCommand.Connection = myConnection; myCommand.Transaction = myTrans; try { myCommand.CommandText = "Insert into tbUserInfo (UserName, UserPass,Birthday,Score) VALUES ('成龙', '111','1966-1-1',540)"; myCommand.ExecuteNonQuery(); //myTrans.Commit(); myCommand.CommandText = "Insert into tbUserInfo (UserName, UserPass,Birthday,Score) VALUES ('王五', '222','198834',550)"; myCommand.ExecuteNonQuery(); myTrans.Commit(); MessageBox.Show("成功写入记录！"); } catch { myTrans.Rollback(); MessageBox.Show("写入数据库失败！"); } finally { myConnection.Close(); }