ADO.NET事务

最新推荐文章于 2024-11-10 19:59:32 发布

jhlovett

最新推荐文章于 2024-11-10 19:59:32 发布

阅读量92

点赞数

分类专栏： C# 文章标签： .net Security

C# 专栏收录该内容

36 篇文章 0 订阅

订阅专栏

 private void DemoTranscation()
    {
        DataTable dt = new DataTable();
        SqlConnection conn = new SqlConnection(@"Data Source=XK\SQLEXPRESS;Initial Catalog=newssystem;Integrated Security=SSPI");
        conn.Open();
        SqlTransaction tran = conn.BeginTransaction();
        try
        {
            SqlCommand comm = new SqlCommand("select * from news", conn);
            comm.Transaction = tran;
            using (SqlDataReader sdr = comm.ExecuteReader())
            {
                dt.Load(sdr);
                tran.Commit();
            }
        }
        catch
        {
            tran.Rollback();
            throw new Exception("出错了!!!");
        }
        finally
        {
            conn.Close();
        }
    }