C#中的一个简单事务
1
<%@ Page Language="C#"%>
2
<%@ Import Namespace="System.Data" %>
3
<%@ Import Namespace="System.Data.SqlClient" %>
4![](/Images/OutliningIndicators/None.gif)
5
<script runat=server>
6![](/Images/OutliningIndicators/None.gif)
7
void Page_Load(Object sender , EventArgs e)
8
{
9
SqlTransaction objTransaction;
10
SqlConnection conBank;
11
string strUpdateAccountA;
12
string strUpdateAccountB;
13
SqlCommand cmdUpdateAccountA;
14
SqlCommand cmdUpdateAccountB;
15![](/Images/OutliningIndicators/InBlock.gif)
16
// Initialize objects
17
conBank = new SqlConnection( "Server=localhost;Integrated Security=SSPI;database=Bank" );
18![](/Images/OutliningIndicators/InBlock.gif)
19
strUpdateAccountA = "Update AccountA set { Balance = Balance - 999.99 WHERE Customer=//Smith//";
20
cmdUpdateAccountA = new SqlCommand( strUpdateAccountA, conBank );
21![](/Images/OutliningIndicators/InBlock.gif)
22
strUpdateAccountB = "Update AccountB set { Balance = Balance + 999.99 WHERE Customer=//Smith//";
23
cmdUpdateAccountB = new SqlCommand( strUpdateAccountB, conBank );
24![](/Images/OutliningIndicators/InBlock.gif)
25
// Open connection
26
conBank.Open();
27![](/Images/OutliningIndicators/InBlock.gif)
28
// Retrieve transaction from connection
29
objTransaction = conBank.BeginTransaction();
30![](/Images/OutliningIndicators/InBlock.gif)
31
// Assign Transaction to commands
32
cmdUpdateAccountA.Transaction = objTransaction;
33
cmdUpdateAccountB.Transaction = objTransaction;
34![](/Images/OutliningIndicators/InBlock.gif)
35
// try { executing both commands
36
try {
37
cmdUpdateAccountA.ExecuteNonQuery();
38
cmdUpdateAccountB.ExecuteNonQuery();
39![](/Images/OutliningIndicators/InBlock.gif)
40
// Commit the transaction
41
objTransaction.Commit();
42
Response.Write( "Transaction Successful!" );
43
}
44
catch (Exception eX)
45
{
46
objTransaction.Rollback();
47
Response.Write( "Transaction Failed!" );
48
}
49
finally
50
{
51
conBank.Close();
52
}
53
}
54
</script>
55![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
2
![](/Images/OutliningIndicators/None.gif)
3
![](/Images/OutliningIndicators/None.gif)
4
![](/Images/OutliningIndicators/None.gif)
5
![](/Images/OutliningIndicators/None.gif)
6
![](/Images/OutliningIndicators/None.gif)
7
![](/Images/OutliningIndicators/None.gif)
8
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
9
![](/Images/OutliningIndicators/InBlock.gif)
10
![](/Images/OutliningIndicators/InBlock.gif)
11
![](/Images/OutliningIndicators/InBlock.gif)
12
![](/Images/OutliningIndicators/InBlock.gif)
13
![](/Images/OutliningIndicators/InBlock.gif)
14
![](/Images/OutliningIndicators/InBlock.gif)
15
![](/Images/OutliningIndicators/InBlock.gif)
16
![](/Images/OutliningIndicators/InBlock.gif)
17
![](/Images/OutliningIndicators/InBlock.gif)
18
![](/Images/OutliningIndicators/InBlock.gif)
19
![](/Images/OutliningIndicators/InBlock.gif)
20
![](/Images/OutliningIndicators/InBlock.gif)
21
![](/Images/OutliningIndicators/InBlock.gif)
22
![](/Images/OutliningIndicators/InBlock.gif)
23
![](/Images/OutliningIndicators/InBlock.gif)
24
![](/Images/OutliningIndicators/InBlock.gif)
25
![](/Images/OutliningIndicators/InBlock.gif)
26
![](/Images/OutliningIndicators/InBlock.gif)
27
![](/Images/OutliningIndicators/InBlock.gif)
28
![](/Images/OutliningIndicators/InBlock.gif)
29
![](/Images/OutliningIndicators/InBlock.gif)
30
![](/Images/OutliningIndicators/InBlock.gif)
31
![](/Images/OutliningIndicators/InBlock.gif)
32
![](/Images/OutliningIndicators/InBlock.gif)
33
![](/Images/OutliningIndicators/InBlock.gif)
34
![](/Images/OutliningIndicators/InBlock.gif)
35
![](/Images/OutliningIndicators/InBlock.gif)
36
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
37
![](/Images/OutliningIndicators/InBlock.gif)
38
![](/Images/OutliningIndicators/InBlock.gif)
39
![](/Images/OutliningIndicators/InBlock.gif)
40
![](/Images/OutliningIndicators/InBlock.gif)
41
![](/Images/OutliningIndicators/InBlock.gif)
42
![](/Images/OutliningIndicators/InBlock.gif)
43
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
44
![](/Images/OutliningIndicators/InBlock.gif)
45
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
46
![](/Images/OutliningIndicators/InBlock.gif)
47
![](/Images/OutliningIndicators/InBlock.gif)
48
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
49
![](/Images/OutliningIndicators/InBlock.gif)
50
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
51
![](/Images/OutliningIndicators/InBlock.gif)
52
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
53
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
54
![](/Images/OutliningIndicators/None.gif)
55
![](/Images/OutliningIndicators/None.gif)