Updating multiple Tables

Discussion in 'ASP .Net' started by =?Utf-8?B?SnVzdGlu?=, Nov 21, 2004.

  1. What is the best/easiest way to update multiple tables at a time?

    Can you recommend any tutorials?

    Thanks, Justin.
     
    =?Utf-8?B?SnVzdGlu?=, Nov 21, 2004
    #1
    1. Advertising

  2. Hi Justin

    > What is the best/easiest way to update multiple tables at a time?

    I guess you mean tables in a database....

    It depends on how you access your data.

    a) DataSet: you can load multiple tables to a dataset add relations to them
    (just like in the db) and call the dataadapter.Update() to update multiple
    tables.

    b) DataReader/Command: You have to fire each sqlcommand yourself.

    c) ORM: Just load the objects change them call object.Update() or
    objectmanager.Save()


    So the question is: where are u?

    --
    Daniel Fisher(lennybacon)
    MCP ASP.NET C#
    Blog: http://www.lennybacon.com/
     
    Daniel Fisher\(lennybacon\), Nov 22, 2004
    #2
    1. Advertising

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. Shiv
    Replies:
    0
    Views:
    426
  2. updating multiple tables

    , Mar 21, 2006, in forum: ASP .Net
    Replies:
    1
    Views:
    5,267
    S. Justin Gengo
    Mar 21, 2006
  3. MRW

    Updating 2 Tables at once

    MRW, Aug 20, 2006, in forum: ASP .Net
    Replies:
    10
    Views:
    602
  4. news.rcn.com
    Replies:
    2
    Views:
    1,180
    Roedy Green
    Dec 10, 2007
  5. aspshadow

    ASP Gridview Updating Two Tables

    aspshadow, Mar 16, 2009, in forum: .NET
    Replies:
    0
    Views:
    502
    aspshadow
    Mar 16, 2009
Loading...

Share This Page