Re: WebServices and Datasets

"So you think that passing a diffgram dataset to a webservice would be
fine?
And if I call the GetChanges Method on the dataset that only the
changes will
be shown in the dataset and to pass that to the web service, correct? I

probably don't need to use a diffgram dataset, just a basic one will be
fine. "

well ther GetChanges method creates a new dataset object with only rows
and atbels with changed data.


"Now to make sure the remote database is updated with changes should I
just create another webmethod that checks the database for
inserts/updates
and relays a message back to the rich client app? If so I would suppose
their
would be a way to create a custom event to fire when database has been
updated. Should I write a separate method for this custom event to
monitor
the webmethod doing the ins/up's for completion? What design do you
think I
should use here? "

Thats a good question, this depends on the requirements of your
application such as location, number of users, service level
agreements, etc... As for the custom event to fire you will need to
poll the database, supposedly with Sql 2005 there wiull be an easier
mechanism to use to determine a change, but remember a web service is
not really a part of an application. A web service can not notify a
client a change as occurred unless the client is constantly polling it.
Same way a web application can't tell a web browser a change as
occured, the web browser must keep polling for the change. I suggest
if you are looking to determine if any updates were made to the data.
That you use a dattime stamp on the rows of data in your tables. Wehn
you make your first query get a datetime stamp from the databse server
(unless you know for sure that all the server clocks are synced up).
Pull that dattime satmp down to the client, now when you make
anyupds/ins, or just want to see if data has been refreshed. Send the
datetime stamp up with the webservice call. ON the database, pull any
records that have a datetime stamp greater then the one sent up from
the client. Then pull just those records back and merge them with your
dataset (DataSet.Merge()). If anyone has a better way using web
services, please chime in.

.

Relevant Pages

  • Re: WebServices and Datasets
    ... > be shown in the dataset and to pass that to the web service, ... > well ther GetChanges method creates a new dataset object with only rows ... > "Now to make sure the remote database is updated with changes should I ... > client a change as occurred unless the client is constantly polling it. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: I need an advice...
    ... there are a few people working on it and it has to run in intranet. ... just need to store some data in a database which is on a server and they ... need to access this database from some other computers, with client ... Web service? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: When To Use .NET Remoting?
    ... I'm now going to learn .NET Remoting and have a plan to modify my ... Database directly. ... retrieving/formatting of data from the database in the client itself. ... if you create a Web Service that offers functions such as 'int ...
    (microsoft.public.dotnet.distributed_apps)
  • Re: user Authentication through webservice
    ... You could just use integrated security for the web service, ... Is there anyway that the client portion of the application ... > user so that I could athenticate that user before accessing the database? ... > company can push out the client app to it's users using Zenworks. ...
    (microsoft.public.dotnet.framework.webservices)
  • Distributed model date time strategy
    ... service, and client application tiers. ... web service and database server. ... and then convert them to local date/time values on ... client will *always* go through an ASP.NET web service tier to ...
    (microsoft.public.dotnet.framework.webservices)