ADO.NET 3.5 Cookbook (Cookbooks (OReilly)) - page 1
- Main Page
- Main Page
- Table of content
- Copyright
- Preface
- Who This Book Is For
- What You Need to Use This Book
- How This Book Is Organized
- What Was Left Out
- Conventions Used in This Book
- About the Code
- Configuration Files
- Platform Notes
- Comments and Questions
- Acknowledgments
- Chapter 1. Connecting to Data
- Introduction
- Recipe 1.1 Connecting to an ODBC Data Source
- Recipe 1.2 Connecting to a Microsoft Excel Workbook
- Recipe 1.3 Connecting to a Password-Protected Access Database
- Recipe 1.4 Connecting to a Secured Access Database
- Recipe 1.5 Connecting to an Access Databasefrom ASP.NET
- Recipe 1.6 Using an IP Address to Connect to SQL Server
- Recipe 1.7 Connecting to a Named Instance of SQL Server or Microsoft Data Engine (MSDE)
- Recipe 1.8 Connecting to SQL Server Using Integrated Security from ASP.NET
- Recipe 1.9 Connecting to an Oracle Database
- Recipe 1.10 Connecting to Exchange or Outlook
- Recipe 1.11 Writing Database-Independent Code
- Recipe 1.12 Storing Connection Strings
- Recipe 1.13 Using the Data Link Properties Dialog Box
- Recipe 1.14 Monitoring Connections
- Recipe 1.15 Taking Advantage of Connection Pooling
- Recipe 1.16 Setting Connection Pooling Options
- Recipe 1.17 Using Transactions with Pooled Connections
- Recipe 1.18 Changing the Database for an Open Connection
- Recipe 1.19 Connecting to a Text File
- Chapter 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
- Chapter 3. Searching and Analyzing Data
- Introduction
- Recipe 3.1 Filtering and Sorting Data
- Recipe 3.2 Using Expression Columns to Display Calculated Values
- Recipe 3.3 Determining the Differences in Data Between Two DataSet Objects
- Recipe 3.4 Navigating Between Parent and Child Records Using a DataRelation
- Recipe 3.5 Localizing Client-Side Data in a Web Forms Application
- Recipe 3.6 Combining Data in Tables from Heterogeneous Data Sources
- Recipe 3.7 Using Expression Columns to Display Aggregate Values
- Recipe 3.8 Finding Rows in a DataTable
- Recipe 3.9 Finding Rows in a DataView
- Recipe 3.10 Selecting the Top n Rows in a DataTable
- Recipe 3.11 Getting Typed DataRows from DataViews
- Recipe 3.12 Filtering for Null Values
- Recipe 3.13 Executing Queries That Use COMPUTE BY
- Recipe 3.14 Using the Shape Language to Retrieve Hierarchical Data
- Chapter 4. Adding and Modifying Data
- Introduction
- Recipe 4.1 Using Auto-Incrementing Columns Without Causing Conflicts
- Recipe 4.2 Getting an Identity Column Value from SQL Server
