Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


    ADO.NET 3.5 Cookbook™, Second Edition
    Preface
    Ch. 1. Connecting to Data
    Ch. 2. Working with Disconnected Data Objects
    Ch. 3. Querying and Retrieving Data
    Ch. 4. Searching and Analyzing Data
    Ch. 5. Adding and Modifying Data
    Recipe 5.0. Introduction
    Recipe 5.1. Using Autoincrementing Columns Without Causing Conflicts
    Recipe 5.2. Getting an Identity Column Value from SQL Server
    Recipe 5.3. Getting an AutoNumber Value from Microsoft Access
    Recipe 5.4. Getting a Sequence Value from Oracle
    Recipe 5.5. Modifying Data in a Microsoft Excel Workbook
    Recipe 5.6. Modifying Data in a Text File
    Recipe 5.7. Retrieving Update Errors
    Recipe 5.8. Adding Parent/Child Rows with Autoincrementing Keys
    Recipe 5.9. Adding Records with a GUID Primary Key
    Recipe 5.10. Inserting Multiple Rows into a Database Table Using T-SQL Row Constructors
    Recipe 5.11. Updating a Data Source with Data from a Different Data Source
    Recipe 5.12. Updating a Primary Key Value
    Recipe 5.13. Getting Stored Procedure Parameter Information at Runtime
    Recipe 5.14. Updating a DataSet with a Many-to-Many Relationship
    Recipe 5.15. Updating Data Asynchronously Using Message Queuing
    Recipe 5.16. Controlling Edits, Deletions, or Additions to Data with a DataView
    Recipe 5.17. Overcoming Keyword Conflicts When Using a CommandBuilder
    Recipe 5.18. Capturing Changes to Data in a SQL Server Database
    Ch. 6. Copying and Transferring Data
    Ch. 7. Maintaining Database Integrity
    Ch. 8. Programmatically Working with Data in .NET Windows and Web Forms User Interfaces
    Ch. 9. Working with XML Data
    Ch. 10. Optimizing .NET Data Access
    Ch. 11. Enumerating and Maintaining Database Objects
    Ch. 12. SQL Server CLR Integration
    Appx. A. What's New in ADO.NET Since Version 1.0
    Colophon
    Index
    • Create BookmarkCreate Bookmark
    • Create Note or TagCreate Note or Tag
    • DownloadDownload
    • PrintPrint
    Share this Page URL
    Help

    Chapter 5. Adding and Modifying Data > Updating a DataSet with a Many-to-Many R...

    Recipe 5.14. Updating a DataSet with a Many-to-Many Relationship

    5.15.1. Problem

    You have a DataSet that contains two tables that have a many-to-many relationship between them using a third junction table. You get referential integrity errors when you try to update changes to the data in this DataSet back to the data source.

    5.15.2. Solution

    Use the techniques described in the discussion.


      

    You are currently reading a PREVIEW of this book.

                                                                                            

    Get instant access to over
    $1 million worth of books and videos.

      

    Start a Free Trial