c# 窗体开发4 数据库访问技术

 1  private void button1_Click(object sender, EventArgs e)
 2         {
 3             SqlConnection conn = new SqlConnection();
 4             conn.ConnectionString = "Data Source=(local);Initial Catalog=school;User ID=sa";
 5             conn.Open();
 6 //开始事务
 7             SqlTransaction sqltran = conn.BeginTransaction();
 8             string sqlstring = "insert into student(sno,sname) values(3390220,‘张三‘)";
 9             SqlCommand comm = new SqlCommand(sqlstring, conn);
10             comm.Transaction = sqltran;
11             int p = comm.ExecuteNonQuery();
12 //事务提交
13             sqltran.Commit();
14             comm.Dispose();
15             comm.Clone();
16             conn.Dispose();
17             conn.Close();
18         }

 1 static void Main(string[] args)    
 2          {    
 3    
 4              SqlConnection sqlConn = new SqlConnection(    
 5                  ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString);    
 6              SqlTransaction sqlTrans = null;    
 7             try   
 8              {    
 9                  sqlConn.Open();    
10                  sqlTrans = sqlConn.BeginTransaction();//事务开始    
11                  SqlCommand sqlComm = new SqlCommand("", sqlConn, sqlTrans);    
12                  sqlComm.CommandTimeout = 120;    
13                  sqlComm.CommandType = System.Data.CommandType.Text;    
14    
15                 string insertSql = "insert into dbo.TransTestTable values (66,‘66‘);";    
16                 string updateSql = "update dbo.TransTestTable set [Name] = ‘77‘ where [Id] = 66;";    
17    
18                  sqlComm.CommandText = insertSql;    
19                  sqlComm.ExecuteNonQuery();//执行insert    
20    
21                  sqlComm.CommandText = updateSql;    
22                  sqlComm.ExecuteNonQuery();//执行update    
23                 //throw new Exception("test exception.the transaction must rollback");    
24    
25                  sqlTrans.Commit();//事务提交    
26              }    
27             catch (Exception ex)    
28              {    
29                  sqlTrans.Rollback();//事务回滚    
30                  Console.WriteLine(ex.Message);    
31              }    
32             finally   
33              {    
34                 if (sqlConn.State != System.Data.ConnectionState.Closed)    
35                      sqlConn.Close();    
36              }    
37    
38              Console.ReadLine();    
39          }  

https://www.cnblogs.com/ldy_ai/p/3644619.html

private void button1_Click(object sender, EventArgs e)
        {
            SqlConnection conn = new SqlConnection();
            conn.ConnectionString = "Data Source=(local);Initial Catalog=school;User ID=sa";
            conn.Open();
            //注意此处为一个事务开始之处
            SqlTransaction sqltran = conn.BeginTransaction();
            string sqlstring = "insert into student(sno,sname) values(3390220,‘张三‘)";
            SqlCommand comm = new SqlCommand(sqlstring, conn);
            comm.Transaction = sqltran;
            int p = comm.ExecuteNonQuery();
            sqltran.Commit();
            //此处为一个事务正常结束之处
            comm.Dispose();
            comm.Clone();
            conn.Dispose();
            conn.Close();
        }
/*
第一步：通过连接对象产生事务对象sqltran；
第二步：将事务对象sqltran绑定到命令对象的Transaction属性；
 第三步：执行命令对象；
第四步：通过事务对象sqltran的Commit（）方法，提交事务，或者通过事务对象sqltran的Rollback（）方法回滚事务。


*/