TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Farhan Shariff
NA
933
241.4k
Compare Datatables - Matching Rows and Columns by Id
May 15 2014 4:49 AM
I am comparing two datables and I get a 2 Datatable i need to match Columns and Row by D_ID and find the difference between the two values (columns are of string type)
I want to loop through table1 D_ID and find the same in table2 and then loop through column (match)and find the difference
Table 1
D_ID
Split
Value_1
Value_2
Value_3
N6K_12
Str
1.503
9.5E-03
-0.48
N6K_13
Ref
1.680
6.5E-03
-0.63
N6K_14
St
1.690
3.3E-03
-0.43
N6K_15
Ref
1.903
4.5E-03
-0.83
table 2 - column D_ID is not in same order as table1
D_ID
Value_2
Value_1
Value_3
N6K_14
3.503
2.5E-03
-3.48
N6K_13
5.680
2.5E-03
-1.63
N6K_15
4.690
5.3E-03
-0.63
N6K_12
8.903
5.5E-03
-4.83
Output table
D_ID
Split
Value_1
Value_2
Value_3
N6K_12
Str
(1.503)- ( 5.5E-03)
(-0.48)-( -4.83)
N6K_13
Ref
(1.680)-( 2.5E-03)
N6K_14
St
(1.690)-( 2.5E-03)
N6K_15
Ref
(-0.83)-( -0.63)
Reply
Answers (
12
)
textboxes read data from sqltable
organising lists using hashsets or better approach?