asked on
How do I get the difference in 2 datatables
I have 2 datatables,
Table A Table B
1 3
2 4
3 5
6
I want the results to be
Table C
1
2
I thought this was called a left outer join but statement is not giving me the correct results
var results = (from rA in dtA.AsEnumerable()
join rB in dtB.AsEnumerable()
on rA.Field<string>(PrimaryKe
from ab in joinedRows.DefaultIfEmpty(
select ab);
Table A Table B
1 3
2 4
3 5
6
I want the results to be
Table C
1
2
I thought this was called a left outer join but statement is not giving me the correct results
var results = (from rA in dtA.AsEnumerable()
join rB in dtB.AsEnumerable()
on rA.Field<string>(PrimaryKe
from ab in joinedRows.DefaultIfEmpty(
select ab);
C#Microsoft SQL Server 2008LINQ QuerySQL
Last Comment
PadawanDBA
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Test code in SSMS..
IF EXISTS (SELECT name FROM sys.tables WHERE name='a')
DROP TABLE a
IF EXISTS (SELECT name FROM sys.tables WHERE name='b')
DROP TABLE b
CREATE TABLE a (val int)
INSERT INTO a (val) VALUES (1), (2), (3)
CREATE TABLE b (val int)
INSERT INTO b (val) VALUES (3), (4), (5), (6)
SELECT a.val
FROM a
LEFT JOIN b ON a.val = b.val
WHERE b.val IS NULL
-- or (SQL 2008 and beyond)
SELECT a.val
FROM a
EXCEPT
SELECT b.val
FROM b
dtA.Merge(dtB ); //Here we marge the datatables
dtA.GetChanges();// Get Changes
Now we find the Distinct records of DataTable dtA
dtC= dtA.DefaultView.ToTable(true, cols);
DefaultView returns the Distinct record but before that we have to pass the datatable as a column Array (cols) to this method.
~Tim
ASKER
I've requested that this question be deleted for the following reason:
My code was correct. My data was wrong.
My code was correct. My data was wrong.
Cancelling the delete request, as multiple experts answered the question as it was asked.
If your question did not accurately reflect requirements, then please accept answer(s) here, finalize your requirements, and ask them in a new question.
If your question did not accurately reflect requirements, then please accept answer(s) here, finalize your requirements, and ask them in a new question.
Accept http:#a40500975 since it was the first to give a correct answer based on information given.
~Tim
~Tim
^=== agree
Open in new window