怎么使用net事务

Question

怎么使用net事务

Answer 1

/// <summary>
    /// 一般的ADO.net 事务
    /// </summary>
    public void ADONetTran1()
    {
        SqlConnection conn = new SqlConnection("Data Source=127.0.0.1;Initial Catalog=Northwind;Persist Security Info=True;User ID=sa;Password=123;");
        SqlCommand cmd = new SqlCommand();
        try
        {
            cmd.CommandText = "Update Region Set RegionDescription=@UpdateValue where RegionID=@UpdateID";
            cmd.CommandType = CommandType.Text;
            cmd.Connection = conn;
            conn.Open();
            SqlParameter[] paras = new SqlParameter[]{
                                        new SqlParameter ("@UpdateID",SqlDbType.Int,32),
                                        new SqlParameter ("@UpdateValue",SqlDbType .NChar,50)};
            paras[0].Value = "2";
            paras[1].Value = "Update Value12";            foreach (SqlParameter para in paras)
            {
                cmd.Parameters.Add(para);
            }
            //开始事务
            cmd.Transaction = conn.BeginTransaction();
            cmd.ExecuteNonQuery();
            cmd.CommandText = "insert into Region values(@InsertID,@InsertValue)";
            cmd.CommandType = CommandType.Text;            paras = new SqlParameter[]{
                                        new SqlParameter ("@InsertID",SqlDbType.Int ,32),
                                        new SqlParameter ("@InsertValue",SqlDbType.NChar ,50)};
            paras[0].Value = "7";
            paras[1].Value = "Insert Value";            cmd.Parameters.Clear();
            foreach (SqlParameter para in paras)
            {
                cmd.Parameters.Add(para);
            }            cmd.ExecuteNonQuery();
            //提交事务
            cmd.Transaction.Commit();
        }
        catch
        {
            //回滚事务
            cmd.Transaction.Rollback();
            throw;
        }
        finally
        {
            conn.Close();
        }    }