How to compare two different table in sql server 2005 using the primary key in csharp?

Question

I have a problem in comparing two different tables in one database in sql server 2005 in csharp to prevent duplication entries....can anybody help to code my problem?thanks and godbless..

Suthish Nair · Answer

Before insertion/updation you want to check the data exists in table or not? If yes using IF EXISTS you can refer

Black Diamond · Answer

Thanks Suthish Nair....The link is good i can use this one...thank a lot..

Black Diamond · Answer

hi Suthish Nair I just want to compare only the data that is stored in my two tables in one database to prevent duplicate entries i want the data in the two tables is not similar....thank you Suthish Nair...

Suthish Nair · Answer

Explain with more information what you want to compare.. only table structure or data?