Linking multiple databases

  • Thread starter Thread starter Tim Almond
  • Start date Start date
T

Tim Almond

We have a database of print requests, and I need to get one piece of
information from some other databases for each request to show in a datagrid
(they are linked by an account number).

I could do it in a stored procedure, but was thinking of using code as I'd
like to be able to change the database locations in one place only.

The print requests database is quite small, but the databases to link to are
massive. I was wondering about passing in the list of account numbers to
another query, but don't know the best way.

Any thoughts on best approach in code?
 
Pull each table into a different table in a dataset. You can add
datarelations if they correspond or whatever else. Use a different adapter
to fill each one, that way, whatever changes are made, all you need to do is
call DataAdapter.Update on the respective adapter and you'll be good to go.

Cheers,

Bill
 
I would, except that the other tables to like to have over 6m records in
each, so retrieving all the data for the sake of 20-100 records is going to
be very slow.
 
I'm not following you. You can still use a Where on each to restrict he
number of rows, in fact, you 'should' use a where if you have tables of that
size.
 
Back
Top