DataAdapter in

Posted on 2006-05-25
Last Modified: 2008-01-09
when this code is used.

does it update just the data that has been retrieved to the dataset, or does it update the data located in the database also?

Question by:jskfan
    LVL 8

    Expert Comment

    The dataset.

    LVL 8

    Accepted Solution


    The dataset is updated, then commited to database.

    When using Update, the order of execution is as follows:

       1.     The values in the DataRow are moved to the parameter values.
       2.     The OnRowUpdating event is raised.
       3.     The command executes.
       4.     If the command is set to FirstReturnedRecord, then the first returned result is placed in the DataRow.
       5.     If there are output parameters, they are placed in the DataRow.
       6.     The OnRowUpdated event is raised.
       7.     AcceptChanges is called.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    matchUp  challenge 6 36
    map interface methods 3 46
    zeroFront challenge 7 58
    add text to end of existing text in file 16 54
    Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now