/// <summary> /// 执行数据集更新到数据库,指定inserted, updated, or deleted命令. /// </summary> /// <remarks> /// 示例: /// UpdateDataset(conn, insertCommand, deleteCommand, updateCommand, dataSet, "Order"); /// </remarks> /// <param name="insertCommand">[追加记录]一个有效的T-SQL语句或存储过程</param> /// <param name="deleteCommand">[删除记录]一个有效的T-SQL语句或存储过程</param> /// <param name="updateCommand">[更新记录]一个有效的T-SQL语句或存储过程</param> /// <param name="dataSet">要更新到数据库的DataSet</param> /// <param name="tableName">要更新到数据库的DataTable</param> public static void UpdateDataset(DB2Command insertCommand, DB2Command deleteCommand, DB2Command updateCommand, DataSet dataSet, string tableName) { if (insertCommand == null) throw new ArgumentNullException("insertCommand"); if (deleteCommand == null) throw new ArgumentNullException("deleteCommand"); if (updateCommand == null) throw new ArgumentNullException("updateCommand"); if (tableName == null || tableName.Length == 0) throw new ArgumentNullException("tableName"); // 创建DB2DataAdapter,当操作完成后释放. using (DB2DataAdapter dataAdapter = new DB2DataAdapter()) { // 设置数据适配器命令 dataAdapter.UpdateCommand = updateCommand; dataAdapter.InsertCommand = insertCommand; dataAdapter.DeleteCommand = deleteCommand; // 更新数据集改变到数据库 dataAdapter.Update(dataSet, tableName); // 提交所有改变到数据集. dataSet.AcceptChanges(); } }