识别修改后的记录 [英] identify modified records

问题描述

我想要比较两个表格，如

[被许可人]，[ENGINENO]，[HULLNO]，[ENGINETYPE]，[所有者]，[YARD]，[规范]，[ORDATE ]，[DLDATE]



一张桌子有修改过的记录



我想要显示两张桌子的记录被修改为gridview。

我无法为它编写正确的代码。

I want to compare two tables having columns like
[Licensee],[ENGINENO],[HULLNO],[ENGINETYPE],[OWNER],[YARD],[Spec],[ORDATE],[DLDATE]

one table had modified records

I want to show both tables's record which are modified into gridview.
I am not able to write proper code for it.

推荐答案

具体如何做到这一点取决于你：我们不知道你的UI设计或者你想如何呈现它。

但它最基本的并不是太复杂：

识别不同的记录：那是只是比较行值并仅提取不完全匹配的行的情况。排序'em，循环'，比较'em。创建一个或两个新结果表。

向用户显示数据：我们可以提供帮助;因为我们不知道您希望如何发生这种情况。两个网格是最明显的方式，滚动同步和保持此列 - 但这取决于你。

删除不需要的记录。



对不起，如果它含糊不清 - 但我们可以看到你的屏幕，访问你的硬盘或读你的想法 - 所以我们可以给出一般问题的具体答案。

Exactly how you do this is down to you: we have no idea of your UI design or how you want to present this.
But it's not too complex at it's most basic:
Identify records which are different: that's just a case of comparing the row values and only extracting ones that don't match exactly. Sort 'em, loop 'em, compare 'em. Create one or two new tables of the results.
Display the data to the user: Here we can;t help much, as we have no idea how you want this to happen. Two grids is the most obvious way, with the scrolling synched and a "keep this" column - but that's up to you.
Delete the unwanted records.

Sorry if it's vague - but we can'r see your screen, access your HDD or read your mind - so we can;t give specific answers to general questions.

这篇关于识别修改后的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！