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