By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,967 Members | 1,596 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,967 IT Pros & Developers. It's quick & easy.

Webservice Connection String

P: n/a
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
Nov 21 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"John" <jo**@nospam.infovis.co.uk> wrote in message
news:u7*************@tk2msftngp13.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.

Nov 21 '05 #2

P: n/a
Elp
Hi Dino and John,

"Dino Chiesa [Microsoft]" <di****@online.microsoft.com> wrote in message
news:u8**************@tk2msftngp13.phx.gbl...

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


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....


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.
Nov 21 '05 #3

P: n/a
Yes Elp. That is exactly I want.

Regards

"Elp" <ro********@REMOVEME.hotmail.com> wrote in message
news:uX**************@TK2MSFTNGP09.phx.gbl...
Hi Dino and John,

"Dino Chiesa [Microsoft]" <di****@online.microsoft.com> wrote in message
news:u8**************@tk2msftngp13.phx.gbl...

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


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.

Nov 21 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.