I want to display the missing (non-matching) records

Posted by Eric on Stack Overflow See other posts from Stack Overflow or by Eric
Published on 2010-04-20T13:08:15Z Indexed on 2010/04/20 13:13 UTC
Read the original article Hit count: 239

Filed under:
|

Is there a way to program the following SQL query

SELECT     dbo.Assets_Master.Serial_Number, dbo.Assets_Master.Account_Ident, dbo.Assets_Master.Disposition_Ident
FROM         dbo.Assets_Master LEFT OUTER JOIN
                      dbo.Assets ON dbo.Assets_Master.Serial_Number = dbo.Assets.Serial_Number
WHERE     (dbo.Assets.Serial_Number IS NULL)

in c# .net code using dataviews or data relation or something else?

I have a spreadsheet of about 4k rows and a data table that should have the same records but if not I want to display the missing (non-matching) records from the table.

Thanks, Eric

© Stack Overflow or respective owner

Related posts about c#

Related posts about .net-3.5