Re: Linking multiple databases
From: William Ryan eMVP (dotnetguru_at_comcast.nospam.net)
Date: 05/04/04
- Next message: William Ryan eMVP: "Re: Simple(?) Question..."
- Previous message: David Sceppa: "RE: problem adding child records"
- In reply to: Tim Almond: "Re: Linking multiple databases"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 4 May 2004 12:43:58 -0400
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.
"Tim Almond" <timdotalmondatlibermensdotcomspamtrap> wrote in message
news:uz$dW#eMEHA.3052@TK2MSFTNGP12.phx.gbl...
> 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.
>
>
>
> "William Ryan eMVP" <dotnetguru@comcast.nospam.net> wrote in message
> news:%23cNFMoeMEHA.3052@TK2MSFTNGP12.phx.gbl...
> > 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
> > "Tim Almond" <timdotalmondatlibermensdotcomspamtrap> wrote in message
> > news:#Vm#FmeMEHA.3016@tk2msftngp13.phx.gbl...
> > > 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?
> > >
> > >
> >
> >
>
>
- Next message: William Ryan eMVP: "Re: Simple(?) Question..."
- Previous message: David Sceppa: "RE: problem adding child records"
- In reply to: Tim Almond: "Re: Linking multiple databases"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
