比较两个DataSet [英] Comparing Two DataSets

问题描述

在我正在开发的一个应用程序中，我有2套构建不同数据集的

函数。


想象一下4列数据网格。在这4列中，我已经嵌套了

数据列表。其中两个数据库的数据源指向数据库A，另外两个数据源指向数据库B.这个效果允许客户端进行并行比较
相同的产品，以便记录

可以相应更新。这很容易向下滚动并查看

的差异，但我被要求让客户更容易。

最终目标是进行任何更改以红色或粗体显示

，以便乍看之下可以发现差异。一个例子是

，如果数据库A的产品XYZ的最新版本为3而数据库B

的产品XYZ的最新版本是4，那么4将显示在

红色或粗体类型中。


我认为cookie可能是要走的路但我可能错了。

有没有人有任何我可以查看的建议或参考资料

逐行比较数据集？有没有比这更简单的方法呢？

In one of the applications that I''m working on I have 2 sets of
functions that build different datasets.

Imagine 4 columns in a datagrid. Inside those 4 columns I have nested
datalists. Two of the datalists'' datasources point to database A and
the other two point to database B. This effect allows the client to
perform a side-by-side comparison of the same product so that records
can be updated accordingly. It''s easy enough to scroll down and look
for differences but I was asked to make it even easier for the client.
The ultimate goal is to have any changes displayed in red or bold type
so that differences can be spotted at first glance. An example would be
that if Database A has product XYZ''s latest version at 3 and Database B
has product XYZ''s latest version at 4, then the 4 would be displayed in
red or bold type.

I''m thinking that a cookie might be the way to go but I could be wrong.
Does anyone have any suggestions or references that I can check out to
compare datasets row-by-row? Is there an easier way to go about doing
this?

推荐答案

你能加入相关的表吗？在SQL？如果您拥有必要的权限，则跨数据库连接非常简单。

。这样你就可以使用计算列来标记你的兴趣。可能比定期编码更有效。


" Will Lastname"写道：

Can you join the relevant tables in SQL? Cross database joins are quite
straight forward if you have the necessary permissions. That way you could
flag your interest using computed columns. Probably more efficient than
regular coding.

"Will Lastname" wrote:

在我正在研究的其中一个应用程序中，我有2套构建不同数据集的
函数。

想象一下数据网格中的4列。在这4列中我嵌套了
数据列表。其中两个数据库的数据源指向数据库A，另外两个指向数据库B.此效果允许客户端对同一产品进行并排比较，以便记录
可以相应更新。向下滚动并查看差异很容易，但我被要求让客户更容易。
最终目标是以红色或粗体显示任何更改产品XYZ的最新版本为4，那么4将显示在
红色或粗体型。

我在想，可能是一个cookie，但我可能是错的。
有没有人有任何我可以查看的建议或参考资料逐行比较数据集？是否有更简单的方法来做这个？

In one of the applications that I''m working on I have 2 sets of
functions that build different datasets.

Imagine 4 columns in a datagrid. Inside those 4 columns I have nested
datalists. Two of the datalists'' datasources point to database A and
the other two point to database B. This effect allows the client to
perform a side-by-side comparison of the same product so that records
can be updated accordingly. It''s easy enough to scroll down and look
for differences but I was asked to make it even easier for the client.
The ultimate goal is to have any changes displayed in red or bold type
so that differences can be spotted at first glance. An example would be
that if Database A has product XYZ''s latest version at 3 and Database B
has product XYZ''s latest version at 4, then the 4 would be displayed in
red or bold type.

I''m thinking that a cookie might be the way to go but I could be wrong.
Does anyone have any suggestions or references that I can check out to
compare datasets row-by-row? Is there an easier way to go about doing
this?

Jeb：我希望我能够做到这一点感。唯一的问题

是一个数据库是MS Access，一个是SQL。

Jeb: I wish I could as this would make the most sense. The only problem
is that one database is MS Access and one is SQL.

Will，


将两个表放入同一数据集并创建

关系怎么样？


-

此致，


S. Justin Gengo，MCP

网站开发人员/程序员

www.aboutfortunate.com


混乱无序。

Nietzsche

" Will Lastname" < Wh是**** @ brinkster.net>在消息中写道

news：11 ********************** @ g43g2000cwa.googlegr oups.com ...

Will,

What about putting both tables into the same dataset and creating a
relationship?

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"Will Lastname" <wh****@brinkster.net> wrote in message
news:11**********************@g43g2000cwa.googlegr oups.com...

在我正在开发的其中一个应用程序中，我有2套构建不同数据集的
函数。

想象一下数据网格中的4列。在这4列中我嵌套了
数据列表。其中两个数据库的数据源指向数据库A，另外两个指向数据库B.此效果允许客户端对同一产品进行并排比较，以便记录
可以相应更新。向下滚动并查看差异很容易，但我被要求让客户更容易。
最终目标是以红色或粗体显示任何更改产品XYZ的最新版本为4，那么4将显示在
红色或粗体型。

我在想，可能是一个cookie，但我可能是错的。
有没有人有任何我可以查看的建议或参考资料逐行比较数据集？是否有更简单的方法来做这个？

In one of the applications that I''m working on I have 2 sets of
functions that build different datasets.

Imagine 4 columns in a datagrid. Inside those 4 columns I have nested
datalists. Two of the datalists'' datasources point to database A and
the other two point to database B. This effect allows the client to
perform a side-by-side comparison of the same product so that records
can be updated accordingly. It''s easy enough to scroll down and look
for differences but I was asked to make it even easier for the client.
The ultimate goal is to have any changes displayed in red or bold type
so that differences can be spotted at first glance. An example would be
that if Database A has product XYZ''s latest version at 3 and Database B
has product XYZ''s latest version at 4, then the 4 would be displayed in
red or bold type.

I''m thinking that a cookie might be the way to go but I could be wrong.
Does anyone have any suggestions or references that I can check out to
compare datasets row-by-row? Is there an easier way to go about doing
this?

这篇关于比较两个DataSet的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！