WebServices DataSet location

  • Thread starter Thread starter Gisa
  • Start date Start date
G

Gisa

Subject: Windows distributed app
Data layer: SQL Server ( on separate machine )
Middle layer: WebServices on IIS ( on separate machine )
Question: Where DataSet is located - on WebServices
machine or on Client machine ... Or, how to make DateSet
to be located only on Client machine.

Thank you in advance

Gisa
 
Gisa-

I'm not quite sure what you are asking.

Are you trying to have a WebService that exists on your webserver get data
from the sql server and then pass it to the client?

If so, this is a very common task. Here is the basic outline of how it
works. You can find lots of details on msdn.microsoft.com.

If you are doing this in Visual Studio .NET, you need to start by creating a
webservice project. In there you need a webservice which has a function
(and authorization) to query the data in the sql server. Most simply, the
function can RETURN the dataset.

Then you creat a client application (eg a windows form). In the client
application you will make a reference to the web application (again, simply
done in Visual Studio.net). Then your client code can call the function in
the webservice something like

dim ds as new dataset
ds=mywebservice.mywebservicefunction

What that will do make the webservice do it's thing: go to sql server, get
the data and return it to the client.

That is just a basic overview of how it works.

There are entire books on the topic.

Look at MSDN for some basic examples. There will be many many many.

hth

Julie Lerman
..NET MVP
 
Hi Julie,

thank you.

Seems that will do. I was simply wondering do the queried
data resides on Web server ( where Web Services are
located ) as well. I understood you as NO, and that is
good answer for me.

Now maybe you can halp me a bit more: how can assess
resources for Web server ( memory, first of all ) given
number of WinForm clients which will attack Web Services
on Web server. The case could be up to 200 clients.

Thank you once again.

Gisa
 
Back
Top