如何比较两个数据表并将不同的记录放入第三个数据表中。 [英] How to compare two data tables and get the different records into third data table.

问题描述

我有两个来自C＃数据库的数据表。每个数据表有59列。我必须比较这两个数据表并将第三个数据表返回到第三个表中，其中新记录插入table1中，并在table1中更新。我尝试了很多方法。我没有找到任何解决方案。我已经尝试过数据关系逻辑来比较和检索结果。除了包含超过32列的表之外，它适用于任何表。请帮帮我。在此先感谢。

I have two datatables from databases in C#.Each data table have 59 columns. I have to compare those two data tables and return the third datatable into third table with new records inserted in table1, and updates in table1. I have tried many ways. I did not find any solution. I have tried Data relation logic to compare and retrieve the result. It worked for any tables except for the tables with more than 32 columns. Please help me on this. Thanks in advance.

推荐答案

尝试以下链接



包含两个数据表 [ ^ ]

我把表分成两个，少于32列，另一个用剩余的列。我比较了两个数据库中的两个表，最后将它们合并为单个。

I did table splitting into two one with less than 32 columns and the other with remaining columns. I compared the two tables from two databases and finally joined them into single.

这篇关于如何比较两个数据表并将不同的记录放入第三个数据表中。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！