首页 > 代码库 > C# 数据回滚

C# 数据回滚

public  int GetExecteQuery(string strAddSql, string strUpdateSql, string strDelSql)        {            SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["GPSP_SQL"]);//实例化数据连接            //SqlConnection conn = new SqlConnection(CONN_STRING);            conn.Open();            SqlCommand command = conn.CreateCommand();            SqlTransaction transaction = null;            transaction = conn.BeginTransaction();            command.Connection = conn;            command.Transaction = transaction;            int count = 0;            try            {                if (strAddSql != "")                {                    command.CommandText = “insert into A.....”;                    command.ExecuteNonQuery();                }                if (strUpdateSql != "")                {                    command.CommandText = “insert into B.....”;                    count = command.ExecuteNonQuery();                }                if (strDelSql != "")                {                    command.CommandText = “insert into C.....”;                    count = command.ExecuteNonQuery();                }                transaction.Commit();            }            catch            {                transaction.Rollback();            }            return count;        }