如何使用LINQ比较两个不同的结构数据表 [英] How to compare two different structure datatable by using LINQ

查看:136
本文介绍了如何使用LINQ比较两个不同的结构数据表的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

  我在我的应用程序中关注了senario

DataTable1具有以下结构

依赖项                        

Workflow1 Lorem1 lpsum               

Workflow2 Lorem1 lpsum            25

 

数据表2

Dep_Type         检查   依赖项

明星工作流程" " false"; " Workflow1 Lorem1 lpsum";

明星工作流程" " false"; " Workflow2 Lorem1 lpsum";

 

"false" "Workflow4 Lorem lpsum"

Star Workflow"

 

"false" "Workflow5 Lorem lpsum"

 

 

 

我想比较两个数据表,在这里我要显示不同的记录 数据表2.我如何实现它.

 

我的输出应该是这样的,我如何通过LINQ实现它

Star Workflow" "false" "Workflow4 Lorem lpsum"

Star Workflow"

 

"false" "Workflow5 Lorem lpsum"

解决方案

很抱歉给您带来不便,这是正确的结构

依赖项                        

Workflow1 Lorem1 lpsum               

Workflow2 Lorem1 lpsum            25

 

数据表2

Dep_Type         检查   依赖项

明星工作流程" " false"; " Workflow1 Lorem1 lpsum";

明星工作流程" " false"; " Workflow2 Lorem1 lpsum";

 

 

Star Workflow" <字体face ="Consolas" size ="2" color =#a31515">

 

 

"false" "Workflow4 Lorem lpsum"

Star Workflow"

<字体face ="Consolas" size ="2" color =#a31515">

 

 

"false" "Workflow5 Lorem lpsum"
"false" "Workflow5 Lorem lpsum"
"false" "Workflow4 Lorem lpsum"  

Star Workflow" <字体face ="Consolas" size ="2" color =#a31515">


Hi

   i have following senario in my application

DataTable1 have following structure

Dependencies                                      Tolerance

Workflow1 Lorem1 lpsum           150     

Workflow2 Lorem1 lpsum            25

 

DataTable 2

Dep_Type         Check      Dependencies

"Star Workflow" "false" "Workflow1 Lorem1 lpsum"

"Star Workflow" "false" "Workflow2 Lorem1 lpsum"

Star Workflow"

 

 

, "false", "Workflow4 Lorem lpsum"

Star Workflow"

 

 

, "false", "Workflow5 Lorem lpsum"

 

 

 

 

I want to compare two datatable, here i want to display different records from DataTable 2. how i can achieve it.

 

My Output should come like that, how i can achieve it through LINQ

Star Workflow", "false", "Workflow4 Lorem lpsum"

Star Workflow"

 

 

, "false", "Workflow5 Lorem lpsum"

解决方案

Sorry for the inconvenience, this is the correct structure

Dependencies                                      Tolerance

Workflow1 Lorem1 lpsum           150     

Workflow2 Lorem1 lpsum            25

 

DataTable 2

Dep_Type         Check      Dependencies

"Star Workflow" "false" "Workflow1 Lorem1 lpsum"

"Star Workflow" "false" "Workflow2 Lorem1 lpsum"

Star Workflow" 

 

 

 

Star Workflow" 

 

 

 

I want to compare two datatable, here i want to display different records from DataTable 2. how i can achieve it. 

My Output should come like that, how i can achieve it through LINQ

Star Workflow" "false" "Workflow4 Lorem lpsum"

Star Workflow"

 

 

 

"false" "Workflow5 Lorem lpsum"
"false" "Workflow5 Lorem lpsum"
"false" "Workflow4 Lorem lpsum"
 


这篇关于如何使用LINQ比较两个不同的结构数据表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆