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.


    Copyright
    Preface
    Ch. 1. Connecting to Data
    Ch. 2. Retrieving and Managing Data
    Introduction
    Recipe 2.1. Retrieving Hierarchical Data into a DataSet
    Recipe 2.2. Building a DataSet Programmatically
    Recipe 2.3. Creating a Strongly Typed DataSet
    Recipe 2.4. Processing a Batch SQL Statement
    Recipe 2.5. Using a Web Service as a Data Source
    Recipe 2.6. Accessing Deleted Rows in a DataTable
    Recipe 2.7. Counting Records in a DataReader
    Recipe 2.8. Mapping .NET Data Provider Data Types to .NET Framework Data Types
    Recipe 2.9. Returning an Output Parameter Using a DataReader
    Recipe 2.10. Raising and Handling Stored Procedure Errors
    Recipe 2.11. Testing for No Records
    Recipe 2.12. Retrieving Stored Procedure Return Values Using a DataReader
    Recipe 2.13. Executing SQL Server User-Defined Scalar Functions
    Recipe 2.14. Passing Null Values to Parameters
    Recipe 2.15. Retrieving Update Errors
    Recipe 2.16. Mapping Table and Column Names Between the Data Source and DataSet
    Recipe 2.17. Displaying Columns from a Related DataTable
    Recipe 2.18. Controlling the Names Used in a Strongly Typed DataSet
    Recipe 2.19. Replacing Null Values in a Strongly Typed DataSet
    Recipe 2.20. Retrieving Data from an Oracle Package
    Recipe 2.21. Using Parameterized SQL Statements
    Recipe 2.22. Querying Data Asynchronously with Message Queuing
    Ch. 3. Searching and Analyzing Data
    Ch. 4. Adding and Modifying Data
    Ch. 5. Copying and Transferring Data
    Ch. 6. Maintaining Database Integrity
    Ch. 7. Binding Data to .NET User Interfaces
    Ch. 8. Working with XML
    Ch. 9. Optimizing .NET Data Access
    Ch. 10. Enumerating and Maintaining Database Objects
    Appx. A. Converting from C# to VB Syntax
    Colophon
    Index
    • Create BookmarkCreate Bookmark
    • Create Note or TagCreate Note or Tag
    • DownloadDownload
    • PrintPrint
    Share this Page URL
    Help

    Chapter 2. Retrieving and Managing Data

    Chapter 2. Retrieving and Managing Data

    Introduction

    Retrieving Hierarchical Data into a DataSet


      

    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