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

最新推荐文章于 2026-03-27 03:50:41 发布

原创最新推荐文章于 2026-03-27 03:50:41 发布 · 2k 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#dataset #command #user #exception #database

随笔集专栏收录该内容

22 篇文章

订阅专栏

本文介绍了一种通过存储过程更新数据库中用户权限的方法。具体包括从数据集中删除特定权限、添加新权限，并通过存储过程进行更新。文章提供了两个示例，分别展示了如何删除和添加规则及用户的权限。

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; }