It appears to me that you're already past the stage of retreiving data from both the data sources... i.e., you already have the data in two separate objects and you're asking how to consolidate those objects into a single one.
In such a scenario, the DataTable.Merge() method sounds like a good option. On Jun 19, 11:25 pm, Snoopy33 <[email protected]> wrote: > Thanks for the reply > > > Do these tables come from the *same* database? If they are, you can > > use > > sql joins and have the resultset stored in a dataset or a collection. > > Then take > > only the fields that you want to be displayed in your datagridview. > > One table resides in a total different DB on a total different server > (SQL). It belongs to a third party application. They are very anal > about not writing directly to their DB (rightly so i'm sure). I need > to have that pool of customers show within the pool of customers that > reside on the app that i'm developing. My app's data resides on a > total different DB on a total different SQL Server. > > Any thoughts?
