ADO.NET.3.5.Cookbook.2nd.Edition (O'Reilly)

This book is strikingly different from other books on Microsoft ADO.NET. Rather than load you down with theory, the new edition of ADO.NET 3.5 Cookbook gives you more than 200 coding solutions and best practices for real problems you're likely to face with this technology using Visual Studio 2008 and the .NET 3.5 platform.Organized to help you find the topic and specific recipe you need quickly and easily, this book is more than just a handy compilation of cut-and-paste C# code.

Chapter 1. Connecting to Data
Recipe 1.1. Storing Connection Strings
Recipe 1.2. Building a Connection String
Recipe 1.3. Connecting to SQL Server
Recipe 1.4. Connecting to a Named Instance of SQL Server
Recipe 1.5. Connecting to SQL Server Using an IP Address
Recipe 1.6. Connecting to SQL Server Using Integrated Security from ASP.NET
Recipe 1.7. Connecting to an Oracle Database
Recipe 1.8. Connecting to an OLE DB Data Source
Recipe 1.9. Connecting to an ODBC Data Source
Chapter 2. Working with Disconnected Data Objects
Recipe 2.1. Creating a DataColumn and Adding It to a DataTable
Recipe 2.2. Creating a DataTable and Adding It to a DataSet
Recipe 2.3. Mapping Table and Column Names Between a Data Source and DataSet
Recipe 2.4. Mapping .NET Data Provider Data Types to .NET Framework Data Types
Recipe 2.5. Adding a Calculated Column to a DataTable
Recipe 2.6. Creating a Unique Constraint
Recipe 2.7. Creating Single- and Multi-Column Primary Keys
Recipe 2.8. Creating an Autoincrementing Primary Key
Chapter 3. Querying and Retrieving Data
Recipe 3.1. Executing a Query That Does Not Return a Result Set
Recipe 3.2. Executing a Query That Returns a Single Value
Recipe 3.3. Retrieving a Result Set Stream Using a DataReader
Recipe 3.4. Accessing Data Values in a DataReader
Recipe 3.5. Retrieving a Result Set Using a DataTable or a DataSet
Recipe 3.6. Accessing Data Values in a DataTable or DataSet
Recipe 3.7. Working with Data in a Strongly Typed DataSet
Recipe 3.8. Working with Parent-Child Relations in a Strongly Typed DataSet
Recipe 3.9. Using a DataView with a Strongly Typed DataSet
Chapter 4. Searching and Analyzing Data
Recipe 4.1. Determining the Differences in Data Between Two DataSet Objects
Recipe 4.2. Combining Data from Heterogeneous Data Sources
Recipe 4.3. Filtering Rows in a DataTable or DataView
Recipe 4.4. Finding Rows in a DataTable or DataView
Recipe 4.5. Filtering and Sorting Data in a DataTable
Recipe 4.6. Filtering Null Field Values in a DataTable
Recipe 4.7. Accessing Deleted Rows in a DataTable
Chapter 5. Adding and Modifying Data
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
Chapter 7. Maintaining Database Integrity
Recipe 7.1. Using Distributed Transactions
Recipe 7.2. Using Manual Transactions
Recipe 7.3. Nesting Manual Transactions with the SQL Server .NET Data Provider
Chapter 8. Programmatically Working with Data in .NET Windows and Web Forms User Interfaces
Recipe 8.1. Loading Data into and Binding a Field to a Web Forms Control
Recipe 8.2. Binding Data to a Web Forms Control
Recipe 8.3. Binding Data to a Web Forms DetailsView Control
Recipe 8.4. Binding Data to a Web Forms Repeater Control
Recipe 8.5. Binding Data to a Web Forms DataList Control
Recipe 8.6. Binding Data to a Web Forms GridView Control
Recipe 8.7. Modifying and Updating Data in a Web Forms GridView Control
Chapter 9. Working with XML Data
Recipe 9.1. Using an XML File to Save and Load a DataSet or a DataTable
Recipe 9.2. Using XSD Schema Files to Save and Load a DataSet Structure
Recipe 9.3. Formatting Column Values When Saving Data As XML
Chapter 10. Optimizing .NET Data Access
Recipe 10.1. Executing Multiple Commands on a Single Connection
Recipe 10.2. Executing a SQL Statement Asynchronously
Recipe 10.3. Executing Simultaneous SQL Statements Asynchronously
Recipe 10.4. Creating a DataReader Asynchronously
Recipe 10.5. Filling a DataSet Asynchronously
Recipe 10.6. Canceling an Asynchronous Query
Recipe 10.7. Caching Data
Chapter 11. Enumerating and Maintaining Database Objects
Recipe 11.1. Enumerating SQL Servers
Recipe 11.2. Retrieving Database Metadata
Recipe 11.3. Retrieving Database Schema Information from SQL Server
Recipe 11.4. Retrieving Column Default Values from SQL Server
Recipe 11.5. Determining the Length of Columns in a SQL Server Table
Recipe 11.6. Retrieving a SQL Server Query Plan
Recipe 11.7. Retrieving SQL Server Column Metadata Without Returning Data
Chapter 12. SQL Server CLR Integration
Appendix A. What's New in ADO.NET Since Version 1.0

Download free ebook on .net: ADO.NET.3.5.Cookbook.2nd.Edition (O'Reilly)