用ADO.NET来使用事务

代码 
 1 string connString = WebConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ConnectionString;
 2         SqlConnection conn = new SqlConnection(connString);
 3         conn.Open();
 4         SqlTransaction tran = conn.BeginTransaction();    //创建事务Transaction
 5  
 6         string strSQL = "INSERT INTO Employees(FirstName, LastName, City, Address) values (@paramFirstName,@paramLastName,@paramCity,@paramAddress)";
 7         SqlCommand cmd = new SqlCommand(strSQL, conn,tran);        //创建SqlCommand
 8 
 9         try
10         {
11             cmd.Parameters.Add("@paramFirstName", SqlDbType.NVarChar, 20).Value = txtFirstName.Text;
12             cmd.Parameters.Add("@paramLastName", SqlDbType.NVarChar, 10).Value = txtLastName.Text;
13             cmd.Parameters.Add("@paramCity", SqlDbType.NVarChar, 15).Value = txtCity.Text;
14             cmd.Parameters.Add("@paramAddress", SqlDbType.NVarChar, 60).Value = txtAddress.Text;
15             cmd.ExecuteNonQuery();
16             tran.Commit();        //确认事务
17             txtMsg.Text = "新增数据成功,事务确认!";
18         }
19         catch
20         {
21             tran.Rollback();   //事务回滚
22             txtMsg.Text = "新增数据失败,事务Rollback!";
23         }
24 
25         finally
26         {
27             conn.Close();
28             conn.Dispose();
29             tran.Dispose();
30             cmd.Dispose();
31         }

 

posted @ 2010-04-25 23:43  无聊程序员  阅读(62)  评论(0)    收藏  举报