-
sqlserver事务调用代码
- static void Main(string[] args)
- {
-
- SqlConnection sqlConn = new SqlConnection(
- ConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString);
- SqlTransaction sqlTrans = null;
- try
- {
- sqlConn.Open();
- sqlTrans = sqlConn.BeginTransaction();
- SqlCommand sqlComm = new SqlCommand("", sqlConn, sqlTrans);
- sqlComm.CommandTimeout = 120;
- sqlComm.CommandType = System.Data.CommandType.Text;
-
- string insertSql = "insert into dbo.TransTestTable values (66,'66');";
- string updateSql = "update dbo.TransTestTable set [Name] = '77' where [Id] = 66;";
-
- sqlComm.CommandText = insertSql;
- sqlComm.ExecuteNonQuery();
-
- sqlComm.CommandText = updateSql;
- sqlComm.ExecuteNonQuery();
-
-
- sqlTrans.Commit();
- }
- catch (Exception ex)
- {
- sqlTrans.Rollback();
- Console.WriteLine(ex.Message);
- }
- finally
- {
- if (sqlConn.State != System.Data.ConnectionState.Closed)
- sqlConn.Close();
- }
-
- Console.ReadLine();
- }
-
相关阅读:
Magento 安装时文件权限 设置
进度十(10.28)
进度九(10.27)
进度八(10.26)
进度六(10.24)
进度五(10.23)
进度四(10.22)
进度三(10.21)
进度二(10.20)
进度一(10.19)
-
原文地址:https://www.cnblogs.com/majiabin/p/4885587.html
Copyright © 2020-2023
润新知