How to use command reader - multiple database ??

[Agnes]

I need to query two tables between two database, I don't know How to do it
in command reader ??
please help.. thanks a lot

 

[W.G. Ryan eMVP]

What DB Are you using? Do you only need to read from it? If so, i'd create
a stored procedure that does this. Or, just create two connections and two
command objects filling two separate datatables (if you need to update the
data - this is probably the way to go) then just use a DataRelation object
to ensure that everything is kosher.
http://www.knowdotnet.com/articles/datarelation.html

 

[Agnes]

I will use SQL server, after complete "select " query, i need to put the
result in another SQL table,
Should I use store procedure to do it ??

 

[Agnes]

I just try store procedure, in vb.net , i need to set the connection string,
for the command text.
BUT I got 2 database (2 connection, how can i set it up) ??

 

[Cor Ligthert]

Agnes,

A stored procedure has nothing to do with the method you use, it is the way
how you manage your procedures on the SQL server. When you have a problem
how to do something you can better not start with it, because than you have
everytime to clean them up, but just do it without those. When you are ready
than one of the last things you do is transform your inbuild procedures to
stored procedures.

However you are for me not clear with your problem, what I have seen from
you it cannot be anymore a simple question, so maybe you can explain it a
little bit more?

When it is about copying tables than there are a lot of answers posible and
is it important if the schema of the data you want to load is knowed on the
server where you want to do that.

Cor

 

[Cor Ligthert]

Agnes,

Just build two connections and two dataadapters what is the problem with
that?

You maybe even can use one dataset

And I hope you saw what I wrote about the stored procedure.


Cor