Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > ADO.NET
|
ADO.NET For discussion about ADO.NET.  Topics such as question regarding the System.Data namespace are appropriate.  Questions specific to a particular application should be posted in a forum specific to the application .
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ADO.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 7th, 2004, 10:28 AM
Authorized User
 
Join Date: May 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jitu
Default Comparing DataSets.

Hi all,

Does anyone know how to compare the values in two datasets?

example i have got invoice numbers from two different database and i would like to know which database has less invoice numbers? After i get this information i would like to add them to the database.

Any help is greatly appreciated.

thanks


Jitu Tivari
__________________
Jitu Tivari
 
Old June 7th, 2004, 11:18 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Hello,

Parse the two datasets and get the value and make the calculation. If it is the row counts that you are trying to compare, you can do:

if ( ds1.Tables(0).Rows.Count > ds2.Tables(0).Rows.Count ) then

and compare that way. Is this what you were looking for?

Brian





Similar Threads
Thread Thread Starter Forum Replies Last Post
How i can join two datasets in only one Nosfe_X VB Databases Basics 0 June 19th, 2006 12:43 PM
Comparing two datasets vip1976 ADO.NET 1 December 2nd, 2005 01:42 AM
comparing 2 DataSets content .Net ochanarachel General .NET 1 March 22nd, 2005 09:54 AM
Datasets Louisa VB.NET 2002/2003 Basics 1 October 6th, 2004 07:38 AM
DataSets CodeMonkeys C# 1 September 7th, 2004 09:48 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.