c# mssql事物开始，事物赋值，事物提交，事物回滚

来源：互联网发布：新网域名过户方法编辑：程序博客网时间：2024/05/21 17:18

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using System.ComponentModel;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace ZBXT.Controls
{
    public class database
    {
        public static String Strcnn = "Data Source=.;Initial Catalog=zbgl;User ID=sa";
        public database()
        {
        }
        public static String select(String StrSQL)
        {

            SqlConnection SqlConnection1 = new SqlConnection();
            SqlDataAdapter SqlDataAdapter1 = new SqlDataAdapter();
            SqlCommand SqlCommand1 = new SqlCommand();

SqlTransaction SqlTrans;//定义事物

                SqlCommand1.CommandText = StrSQL;
                SqlCommand1.Connection = SqlConnection1;
                //打开数据库连接
                SqlConnection1.ConnectionString = Strcnn;
                SqlConnection1.Open();
                SqlTrans = SqlConnection1.BeginTransaction();//开始事物
                SqlCommand1.Transaction = SqlTrans;//将cmd对象的事物属性赋值
            try
            {
                object a = new object();
                a = SqlCommand1.ExecuteScalar();
                if (a == null)
                {
                    return (null);
                }
                String b = (String)a.ToString();
                SqlTrans.Commit();//事物提交
                SqlConnection1.Dispose();
                SqlConnection1.Close();
                return (b);
            }
            catch (Exception Err)
            {
                SqlTrans.Rollback();//事物回滚
                return ("增加数据集记录操作失败：" + Err.Message);
            }
            finally
            {
                SqlConnection1.Dispose();
                SqlConnection1.Close();
            }

}