Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > ASP .Net Web Services > Distributed Arch Guidance for DataAdapter and WS

Thread Tools

Distributed Arch Guidance for DataAdapter and WS

Emre Aydinceren
Posts: n/a

My project involves editing a complex set of data
populated from 5-6 tables in a smart client WinForms

1. Clients requests data.
2. Server populates required data in datatables in a big
a dataset with relations.
3. DataSet (strongly typed) is serialized and pushed to
client via soap.
4. Client loads up dataset and binds datagrid controls.


How do you suggest I post back the data and apply
datadadapters Update method?
Posting back the whole dataset seems too inefficient.
Please feel free to suggest alternative approachs.

Emre Aydinceren
Reply With Quote
Posts: n/a
Interesting question, I like typed datasets and use them as a "logical"
representation of the underlying database, de-normalizing the data and
making it suitable for easy view and databinding. This removes complexity
of underlying database design for those writing ui code..

The issue of how to then update raises its head as you point out..

The problem with trying to update through the dataset and the associated
dataadaptor is trying to work with logical entities that are made up of more
than one equivalent table..

If you are just going to insert / update one record at a time how about just
doing that by passing down typed parameters, catching those at the server
and then invoking your stored procedure to do the update setting the
parameters along the way.. ie Forget the dataset completely...

The problem with this approach is how to the reflect the changes in your
dataset which is already client side?....

In that case how about making the add through the client side data set, and
only returning those rows that have been changed by using the GetChanges
method ? Server side use these rows to pluck out the parameters to do your
necessary updates etc...

hth, look forward to others comments too as this is something that intrigues
me at the moment..

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
1.8 and 1.9 on arch linux Martin DeMello Ruby 8 04-20-2009 10:51 PM
New Update - CCNA BSCI ARCH CCIE-SEC - Download Link ! CertCityForum.Com MCSE 4 06-07-2006 11:41 PM
Ques about 70-300 .NET Solns Arch c1sbc MCSD 3 05-20-2006 12:02 AM
ASP.NET 1.1 VERSION ON WIN SERVER 2003 SP1 & VS 2003 Arch. =?Utf-8?B?RHIuIFBhdWwgQ2Flc2FyIC0gQ291bGxCeXRlIChVSykgTGltaXRlZA==?= ASP .Net 1 04-30-2005 02:33 PM
Re: Thanks for arch advice - see my photos here Nehmo Sergheyev Computer Security 4 08-01-2003 02:11 PM