Distributed Arch Guidance for DataAdapter and WS

Discussion in 'ASP .Net Web Services' started by Emre Aydinceren, Jul 8, 2003.

  1. 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
    Emre Aydinceren, Jul 8, 2003
    1. Advertisements

  2. Giri

    Giri Guest

    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..
    Giri, Jul 9, 2003
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?RHIuIFBhdWwgQ2Flc2FyIC0gQ291bGxCeXRlIChV

    ASP.NET 1.1 VERSION ON WIN SERVER 2003 SP1 & VS 2003 Arch.

    =?Utf-8?B?RHIuIFBhdWwgQ2Flc2FyIC0gQ291bGxCeXRlIChV, Apr 30, 2005, in forum: ASP .Net
    Aquila Deus
    Apr 30, 2005
  2. =?ISO-8859-1?Q?Gustavo_C=F3rdova_Avila?=

    Anybody using Arch?

    =?ISO-8859-1?Q?Gustavo_C=F3rdova_Avila?=, Nov 29, 2004, in forum: Python
    Nov 29, 2004
  3. Christopher Taylor

    Python RPM package arch compatability

    Christopher Taylor, Oct 18, 2006, in forum: Python
    Christopher Taylor
    Oct 18, 2006
  4. Replies:
    Paul Rubin
    Oct 23, 2006
  5. Martin DeMello

    1.8 and 1.9 on arch linux

    Martin DeMello, Apr 20, 2009, in forum: Ruby
    Daniel DeLorme
    Apr 20, 2009