木子屋
 

标题: .NET事务处理使用示例

作者: dnawo

日期: 2009-01-19 02:53 PM

分类: Web编程

内容: 复制内容到剪贴板 程序代码using (SqlConnection conn = new SqlConnection("server=(local);database=pubs;user id=sa;password=sa;"))
{
    conn.Open();
    //事务开始
    using (SqlTransaction trans = conn.BeginTransaction())
    {
        try
        {
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = conn;
            cmd.CommandType = CommandType.Text;
            cmd.Transaction = trans;
            //添加
            cmd.CommandText = "Insert INTO test([name],[age]) VALUES('aaa',20)";
            cmd.ExecuteNonQuery();
            cmd.CommandText = "Insert INTO test([name],[age]) VALUES('bbb',21)";
            cmd.ExecuteNonQuery();
            cmd.CommandText = "Insert INTO test([name],[age]) VALUES('ccc',22)";
            cmd.ExecuteNonQuery();
            //throw new Exception("Error");
            //提交事务
            trans.Commit();
            Response.Write("ok");
        }
        catch(Exception ex)
        {
            //回滚事务
            trans.Rollback();
            Response.Write(ex.Message);
        }
    }
    conn.Close();
}

+ 查看当前日志评论 (0)

 

登录

────────────

木子屋

PJBlog3 v3.2.9.518 Inside.

Processed In 0.063 ms

标题: .NET事务处理使用示例

你没有权限发表评论

────────────

木子屋

PJBlog3 v3.2.9.518 Inside.

Processed In 0.063 ms

暂无评论

返回

────────────

木子屋

PJBlog3 v3.2.9.518 Inside.

Processed In 0.063 ms