"John" <jo**@nospam.in fovis.co.uk> wrote in message
news:u7******** *****@tk2msftng p13.phx.gbl...
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?
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.
