最近在學習.net中遇到一個關于事務處理例子。 代碼如下（） protected void Button1_Click(object sender, EventArgs e) { string accountStrA = TextBox1.Text.ToString(); string accountStrB = TextBox2.Text.ToString(); float fundA = (float)Convert.ToSingle(Label1.Text) - (float)Convert.ToSingle(TextBox3.Text); float fundB = (float)Convert.ToSingle(Label2.Text) - (float)Convert.ToSingle(TextBox3.Text); SqlConnection sqlConn = new SqlConnection(); sqlConn.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString(); sqlConn.Open(); SqlTransaction myTran = sqlConn.BeginTransaction(); SqlCommand myCom = new SqlCommand(); myCom.Transaction = myTran; try { myCom.CommandText = "update yinhang set jine = '" + fundA + "'where zhanghu = '" + accountStrA + "'"; myCom.ExecuteNonQuery(); myCom.CommandText = "update yinhang set jine = '" + fundB + "'where zhanghu = '" + accountStrB + "'"; myCom.ExecuteNonQuery(); myTran.Commit(); Response.Write("alert('轉賬成功');location='Default.aspx'"); } catch (Exception ex) { myTran.Rollback(); Response.Write(ex.ToString()); Response.Write("alert('轉賬錯誤');location='Default.aspx'"); } finally { sqlConn.Close(); } ? ? 其中我運行Button1_Click后就顯示轉賬錯誤并說明是myCom.ExecuteNonQuery();這里的錯誤 所以我注釋了myCom.ExecuteNonQuery();這兩行代碼后能顯示轉賬成功。但是數(shù)據(jù)中的數(shù)據(jù)卻沒有改變。。。。。糾結中，請求各位老鳥教導一下