dotnet web services: Hi

I have a dataset from a web service. I want to use a dataadapter with the
dataset. What connection string should I use so the da knows that it is
acting on the remote db associated with the web service dataset?

Thanks

Regards

[quoted text, click to view]

Hi John!

You sure are persistent, aren't you? You keep asking the same question.
I will continue to try to answer it, in different ways. Maybe one of us
will surrender....

Here's the thing: if you get a dataset from a webservice, in general there
is no way to find a connection string you can apply to a DataAdapter, for
use with that DataSet, to get back to the original database.

Imagine this scenario. You are riding the train to work in the morning.
Someone walks up to you and hands you a dataset.
Now, where did this dataset come from? You don't know. In fact the DataSet
is a DISCONNECTED DATA CACHE, and there is no indication in the DataSet
itself as to the originating source of the data. The person who handed you
the DataSet may know where the data came from. But just by virtue of your
possession of that DataSet, you cannot say where it came from.

The same applies if you obtain the DataSet from a webservice. The
webservice may have a connection string that can get to the original store
of the data, but you, as possessor of the DataSet, don't. Just because you
have a cache of data (the DataSet), doesn't give you the right or the
authorization or the capability to update the original store of that data.

In fact, we can go further. It is possible to create a DataSet without any
DataAdapter (or connection string) at all. You can manufacture a DataSet
out of the ether, as it were. Now suppose your friend on the train, or your
webservice, handed you such a contrived DataSet. Where is the connection
string?

What is the sound of one hand clapping?

Translation:
There is no answer to your question, John.

There is no connection string. Just be happy you have the data. do with it
what you want.

Hi Dino and John,

[quoted text, click to view]

I read John's previous post and i think that i begin to understand what he
wants to do. John, correct me if i am wrong:
1) You call a WebService method that returns a Dataset
2) You then want to execute a SELECT query on the data contained in the
dataset and put the result of this query in another (local) database located
on the client computer.

Am i right? I can't really tell you how to do this, my knowledge of DataSet
is too limited for that, but it is surely possible. Dino, you can maybe help
me on this one.

Yes Elp. That is exactly I want.

Regards

[quoted text, click to view]