Click here to Skip to main content
15,889,281 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have three datatables dt1,dt2 and dt3 i need to check the data in rows of first datatable matches with second and third datatable

If my second and third datatable has same names which are in first datatable then i should not display the unmatching names

if in case they are not same i need to display that first datatable has testdemo which is not there in second datatable if testdemo is there in second datatable but not in third datatable i need to show first datatable has testdemo but not there in third datatable

for example

My first datatable contains
column name

test
testdemo
testdemo1
testdemo2

my second datatable

test 
testupload
testdemo1
testdemo2

if we compare above two testupload is different in second data table then i need to show testdemo and test upload are different
my third datatable

test1
testuploaddemo
testdemo1
testdemo2

then in this case i need to show test and testdemo in datatable1 does not match with test1 and testuploaddemo in datatable3

that means i need to compare datatable1 with datable 2 and datatable 3 and datable 2 with datatable 1 and datatable3 and datatable 3 with datatable 1 and datatable 2 if different i need to show error message at last else no need how can i do this

What I have tried:

i am unable to get how to do this
Posted
Updated 23-Aug-17 10:07am
v2
Comments
Dave Kreskowiak 23-Aug-17 15:42pm    
Better question: Why are you storing the exact same data (be it a field, fields, or an entire row) in multiple tables? That just wastes space in the database because of the duplication of data.

1 solution

 
Share this answer
 
Comments
Karthik_Mahalingam 23-Aug-17 23:55pm    
5

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900