With SQL Server you can use Linked Servers: http://msdn.microsoft.com/en-us/library/aa213778(SQL.80).aspx
Or you can just import their data every night or every 12 hours etc. Jim On Fri, Jun 19, 2009 at 2: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?
