c＃win表单中的Access Utility [英] Access Utility in c# win forms

问题描述

我正在开发一个访问实用程序应用程序，我想在其中插入缺少的查询，表和字段。如何实现这一目标。到目前为止，我只能获取表和查询的名称。在此先感谢。

解决方案

基本上我想创建一个应用程序，将目标数据库中的所有缺失值都发送到主数据库。如何实现这一目标我不知道。通过网上搜索，我可以获得表格和查询的名称。



哎哟！这不是一项简单的任务，需要在数据库设计中进行大量思考和一些规划。它并不像查找此数据库中不包含在该数据库中的所有记录并插入它们那么简单 - 它更加复杂，因为更新通常必须处理两个方向的数据，并记录删除，更新和等等。



你需要先看看数据库复制 [ ^ ] - 按照几个链接来了解您需要的系统有多复杂，然后开始深入阅读如何设计它并将其添加到你的系统。但是 - 使用数据库的备份，并且不要期望这是十分钟的操作！ ：笑：

i am developing an access utility application in which i want to insert the missing query, tables and fields. How to achieve this. So far, i just can get names of tables and queries. Thanks in advance.

解决方案

"basically i want to make an app that gets all missing values from target database to the main database. How to achieve this i have no idea.By searching on net i just can get names of tables and queries."

Ouch! This is not a simple task, and it requires a lot of thinking and some planning in the database design. It's not as simple as "Find all records in this DB that aren't in that DB and insert them" - it's a lot more complex, as the updates normally have to cope with data in both directions, and record deletes, updates, and so forth.

You need to start by look at Database Replication[^] - follow a couple of the links to get a feel for how complex a system you need, and then start reading in depth as to how to design for it and add it to your system. But - work with backups of your DB, and don't expect this to be a ten minute operation! :laugh:

这篇关于c＃win表单中的Access Utility的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！