Table Data Compariosn in c#

Except



SqlDataAdapter oDatAdop1 = new SqlDataAdapter("select 1 as tablename ,* from ( select * from [" + txtfromserver.Trim() + "]." + FromDb.Trim() + ".dbo." + FromTable.Trim() + " with(nolock) except select * from [" + ToServer.Trim() + "]." + ToDb.Trim() + ".dbo." + ToTable.Trim() + " with(nolock) ) as x union all select 2 as tablename ,* from ( select * from [" + ToServer.Trim() + "]." + ToDb.Trim() + ".dbo." + ToTable.Trim() + " with(nolock) except select * from [" + txtfromserver.Trim() + "]." + FromDb.Trim() + ".dbo." + FromTable.Trim() + " with(nolock)) as y order by " + Columnlist1.Trim() + " ", oCon);DataSet odtSet1 = new DataSet();SqlDataAdapter oDatAdop2 = new SqlDataAdapter(" select * from [" + txtfromserver.Trim() + "]." + FromDb.Trim() + ".dbo." + FromTable.Trim() + " with(nolock) intersect select * from [" + ToServer.Trim() + "]." + ToDb.Trim() + ".dbo." + ToTable.Trim() + " with(nolock) order by " + Columnlist1.Trim() + " ", oCon);DataSet odtSet2 = new DataSet();

oDatAdop1.Fill(odtSet1);


Intersect






oDatAdop2.Fill(odtSet2);