Hi all

i am developing web apps using C# and asp.net 2.0. I am using framework 2.0
i have two datatables both of them are having equal no. of columns namely EmployeeId,Designation and Remarks. Tables are T1 and T2. I want to have records from both of them and need to store in a new datatable. I have the following query which actually needs to be used here:

Please throw some light how to do it in C#/ado.net

Hi...

That query will show records that are the same on the two tables.. you need differents ones only???

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========

Use LINQ if you are coding under with C# 3 and or .NET. It’s a very powerful language feature, with support for quering objects and memory. So you can just do simple queries from you DB o your app with SELECT * FROM ..., then fill them in their respective collections then you can use LINQ to manage and compare them very easily. If that sounds simpler to you.