ADO Transaction Control

2. In ADO, you can use connection and transaction objects to control transactions. To perform a transaction, follow these steps:
6. 1. Call the BeginTransaction method of the Connection object to mark the beginning of the transaction.
10. 2. Assign the transaction object to the transaction property of the command to be executed.
14. 3. Execute the required command.
18. 4. Call the Commit method of the transaction object to complete the transaction, or call the Rollback method to cancel the transaction. Of course, there are advantages and disadvantages to the processing of ADO, and we use them to see the situation.
22. Pros: – Simplicity – almost as fast as data transactions – database-independent, proprietary code for different databases is hidden
26. Cons: – A transaction cannot span multiple database connections – The transaction executes on the database connection layer, so a database connection needs to be maintained during the transaction.
30. Below we look at an example, create a page, the same simple, just need a button, and then programming:
34. 1 using System;
38. 2 using System.Data;
42. 3 using System.Configuration;
46. 4 using System.Collections;
50. 5 using System.Web;
54. 6 using System.Web.Security;
58. 7 using System.Web.UI;
62. 8 using System.Web.UI.WebControls;
66. 9 using System.Web.UI.WebControls.WebParts;
70. Ten using System.Web.UI.HtmlControls;
74. One using System.Data.SqlClient;
78. 12
82. namespace WebApplication1
86. 14 {
90. Public partial class AdoAction:System.Web.UI.Page
94. 16 {
98. protected void Page_Load ( object sender, EventArgs e)
102. 18 {
106. 19
110. 20}
114. 21st
118. protected void Btn_click ( object sender, EventArgs e)
122. 23 {
126. SqlConnection con = new SqlConnection ();
130. -Con. ConnectionString = configurationmanager.connectionstrings[ "DSN"].   ConnectionString;
134. -Con. Open ();
138. //Start a transaction.
142. SqlTransaction Mytran = con. BeginTransaction ();
146. //Create a command for a transaction, note that we execute a double command, and the first execution is of course successful.   We do it again, fail.
150. The third time we change one of the orders, the other does not change, this time the transaction will error, this is the transaction mechanism.
154. SqlCommand mycom = new SqlCommand ();
158. Mycom.connection = con;
162. Mycom.transaction = Mytran;
166. Try
170. 35 {
174. Mycom.commandtext = "INSERT into sqlaction values (' Test 2 ', ' 111 ')";
178. Panax Notoginseng mycom.executenonquery ();
182. Mycom.commandtext = "INSERT into sqlaction values (' Test 3 ', ' 111 ')";
186. Mycom.executenonquery ();
190. Mytran.commit ();
194. Response.Write ( "Successful Execution");
198. 42
202. 43}
206. (Exception Ex)
210. 45 {
214. Mytran.rollback ();
218. I //Create and return an exception error message
222. Response.Write (Ex.tostring ());
226. Response.Write ( "write database Failed");
230. 50}
234. Wuyi finally
238. 52 {
242. The con. Close ();
246. 54}

ADO Transaction Control