数据访问的一个小应用（ db.LoadDataSet / db.UpdateDataSet）

dataset 更新数据库

删除 实例：

public bool UpdateRuleRight(int ruleId, int[] delRightId)
        {
            bool isSuc = false;
            DataBase db = DataBaseFactory.CreateDataBase(DBConnectionString.DB_ADMIN);
            DataSet dsRuleRight = new DataSet();
            try
            {
                DbCommand command = db.GetStoredProcCommand("spa_sys_get_rule_right");
                string tbName = "rule_right";
                db.LoadDataSet(command, dsRuleRight, tbName);
                DataTable dtUserRight = dsRuleRight.Tables[tbName];
              
                foreach (int intId in delRightId)
                {
                    if (intId != 0)
                    {
                        dtUserRight.Select(string.Format("rule_id='{0}' and right_id='{1}'", ruleId, intId))[0].Delete();
                    }
                }
                DbCommand deleteCommand = db.GetStoredProcCommand("spa_sys_delete_rule_right");
                db.AddInParameter(deleteCommand, "rule_id", DbType.Int32, "rule_id", DataRowVersion.Current);
                db.AddInParameter(deleteCommand, "right_id", DbType.Int32, "right_id", DataRowVersion.Current);
                int rowsAffected = db.UpdateDataSet(dsRuleRight, tbName, null, null, deleteCommand, UpdateBehavior.Standard);
                if (rowsAffected > 0)
                {
                    isSuc = true;
                }
            }
            catch (Exception ex)
            {
                LogUtility.Add(ex);
                isSuc = false;
            }
            return isSuc;
        }

综合实例：（部分源码）

public bool UpdateUserRight(int userId,int[] addRightId, int[] delRightId)
        {
            bool isSuc = false;
            DataBase db = DataBaseFactory.CreateDataBase(DBConnectionString.DB_ADMIN);
            DataSet dsUserRight = new DataSet();
            try
            {
                DbCommand command = db.GetStoredProcCommand("spa_sys_get_user_right");
                string tbName = "user_right";
                db.LoadDataSet(command, dsUserRight, tbName);
                DataTable dtUserRight = dsUserRight.Tables[tbName];
                foreach (int intId in addRightId)
                {
                    if (intId != 0)
                    {
                        dtUserRight.Rows.Add(new object[] { userId, intId });
                    }
                }
                foreach (int intId in delRightId)
                {
                    if (intId != 0)
                    {
                        dtUserRight.Select(string.Format("user_id='{0}' and right_id='{1}'", userId, intId))[0].Delete();
                    }
                }
                //dtUserRule.AcceptChanges(); //加后报错 注意
                DbCommand insertCommand = db.GetStoredProcCommand("spa_sys_add_user_right");
                db.AddInParameter(insertCommand, "user_id", DbType.Int32, "user_id", DataRowVersion.Current);
                db.AddInParameter(insertCommand, "right_id", DbType.Int32, "right_id", DataRowVersion.Current);
                DbCommand deleteCommand = db.GetStoredProcCommand("spa_sys_delete_user_right");
                db.AddInParameter(deleteCommand, "user_id", DbType.Int32, "user_id", DataRowVersion.Current);
                db.AddInParameter(deleteCommand, "right_id", DbType.Int32, "right_id", DataRowVersion.Current);
                int rowsAffected = db.UpdateDataSet(dsUserRight, tbName, insertCommand, null, deleteCommand, UpdateBehavior.Standard);
                if (rowsAffected > 0)
                {
                    isSuc = true;
                }
            }
            catch (Exception ex)
            {
                LogUtility.Add(ex);
                isSuc = false;
            }
            return isSuc;
        }