C# 数据回滚实例

private void save_db(){
    SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["..."].ToString());
    SqlCommand comm = new SqlCommand();
    conn.Open();
    SqlTransaction rollbk2= conn.BeginTransaction();
    comm.Connection=conn;
    comm.Transaction=rollbk2;
    try
    {
        for(i...){
        comm.CommandText="insert into ...";
        comm.ExecuteNonQuery();
        }
        rollbk2.Commit();
    }
    catch(Exception exp)
    {
        rollbk2.Rollback();
        Response.Write("save_fail");
        return;
    }
    finally
    {
        conn.Close();
    }
    Response.Write("save_ok");
}

转载于:https://www.cnblogs.com/gaoyoubo/archive/2010/03/24/1965036.html