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.
ADO.NET 3.5 Cookbook, Second Edition
Preface
Chapter 1. Connecting to Data
Recipe 1.0. Introduction
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
Recipe 1.10. Connecting to a Microsoft Access Database
Recipe 1.11. Connecting to a Password-Protected Microsoft Access Database
Recipe 1.12. Connecting to a Microsoft Access Database from ASP.NET
Recipe 1.13. Connecting to a Microsoft Excel Workbook
Recipe 1.14. Connecting to a Text File
Recipe 1.15. Changing the Database for an Open Connection
Recipe 1.16. Setting Connection Pooling Options
Recipe 1.17. Taking Advantage of Connection Pooling
Recipe 1.18. Using Transactions with Pooled Connections
Recipe 1.19. Displaying a Connection Property Dialog Box
Recipe 1.20. Displaying the Data Link Properties Dialog Box
Recipe 1.21. Monitoring Connections
Chapter 2. Working with Disconnected Data Objects
Recipe 2.0. Introduction
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
Recipe 2.9. Creating a Foreign Key Constraint
Recipe 2.10. Creating a Data Relation
Recipe 2.11. Building a DataSet Programmatically
Recipe 2.12. Adding a Column to a Child DataTable That Displays Data from the Parent Table
Recipe 2.13. Adding a Column to a Parent DataTable That Aggregates a Child Table's Column Values
Recipe 2.14. Converting Between a DataTable and a DataRow Array
Recipe 2.15. Accessing Data Values in a DataRow Array
Recipe 2.16. Creating a Strongly Typed DataSet
Recipe 2.17. Controlling the Names Used in a Strongly Typed DataSet
Recipe 2.18. Replacing Null Values in a Strongly Typed DataSet
Chapter 3. Querying and Retrieving Data
Recipe 3.0. Introduction
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
Recipe 3.10. Testing Whether a Query Returns an Empty Result Set
Recipe 3.11. Counting Records Meeting Criteria
Recipe 3.12. Determining the Number of Records Returned in a DataReader
Recipe 3.13. Executing a Query That Returns Multiple Result Sets
Recipe 3.14. Retrieving Schema and Constraints for a DataSet
Recipe 3.15. Retrieving Hierarchical Data
Recipe 3.16. Navigating Between Parent and Child Tables in an Untyped DataSet
Recipe 3.17. Executing a Parameterized Query
Recipe 3.18. Retrieving Data Using a SQL Server Stored Procedure
Recipe 3.19. Retrieving Multiple Result Sets Using the Oracle Provider
Recipe 3.20. Passing a Null Value to a Query Parameter
Recipe 3.21. Using Table-Valued Types As Parameters
Recipe 3.22. Retrieving a Return Value from a Stored Procedure
Recipe 3.23. Retrieving a Stored Procedure Output Parameter
Recipe 3.24. Raising and Handling Stored Procedure Errors
Recipe 3.25. Executing a SQL Server Scalar-Valued Function
Recipe 3.26. Executing a SQL Server Table-Valued Function
Recipe 3.27. Querying a DataSet Using LINQ
Recipe 3.28. Querying a SQL Server Database Using LINQ
Recipe 3.29. Retrieving Data from a Text File
Recipe 3.30. Retrieving Data from a Microsoft Excel Workbook
Recipe 3.31. Querying Data Asynchronously with Message Queuing
Chapter 4. Searching and Analyzing Data
Recipe 4.0. Introduction
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
Recipe 4.8. Selecting the Top N Rows in a DataTable
Recipe 4.9. Executing Queries That Use COMPUTE BY
Recipe 4.10. Using the Shape Language to Retrieve Hierarchical Data
Recipe 4.11. Retrieving a Random Sample of Records
Recipe 4.12. Using a Common Table Expression (CTE)
Recipe 4.13. Executing a Recursive Query
Recipe 4.14. Retrieving a Ranked Result Set
Recipe 4.15. Retrieving a Pivot and Unpivot Table
Recipe 4.16. Invoking a Function for Each Row in a Result Set
Chapter 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
Chapter 6. Copying and Transferring Data
Recipe 6.0. Introduction
Recipe 6.1. Copying Rows from One DataTable to Another
Recipe 6.2. Copying Tables from One DataSet to Another
Recipe 6.3. Converting a DataReader to a DataTable
Recipe 6.4. Converting a DataReader to a DataSet
Recipe 6.5. Converting a DataTable to a DataReader
Recipe 6.6. Converting a DataSet to a DataReader
Recipe 6.7. Serializing Data
Recipe 6.8. Deserializing Data
Recipe 6.9. Merging Data in Two DataSet Objects
Recipe 6.10. Merging Data in Two Database Tables
Recipe 6.11. Encrypting a DataSet
Recipe 6.12. Securing Login Credentials
Recipe 6.13. Exporting the Results of a Query As a String
Recipe 6.14. Exporting the Results of a Query to an Array
Recipe 6.15. Loading an ADO Recordset into a DataSet
Recipe 6.16. Converting a DataSet to an ADO Recordset
Chapter 7. Maintaining Database Integrity
Recipe 7.0. Introduction
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
Recipe 7.4. Using ADO.NET and SQL Server DBMS Transactions Together
Recipe 7.5. Using a Transaction with a DataAdapter
Recipe 7.6. Avoiding Referential Integrity Problems when Updating Data in Related Tables
Recipe 7.7. Enforcing Business Rules with Column Expressions
Recipe 7.8. Retrieving Constraints from a SQL Server Database
Recipe 7.9. Checking for Concurrency Violations
Recipe 7.10. Resolving Data Conflicts
Recipe 7.11. Using Transaction Isolation Levels to Protect Data
Recipe 7.12. Specifying Locking Hints in a SQL Server Database
Chapter 8. Programmatically Working with Data in .NET Windows and Web Forms User Interfaces
Recipe 8.0. Introduction
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
Recipe 8.8. Binding Data to a Web Forms FormView Control
Recipe 8.9. Synchronizing Master-Detail Data in a Web Forms Application
Recipe 8.10. Displaying an Image from a Database in a Web Forms Control
Recipe 8.11. Localizing Client-Side Data in a Web Forms Application
Recipe 8.12. Loading Data into and Binding a Field to a Windows Forms Control
Recipe 8.13. Binding Data to a Windows Forms Control
Recipe 8.14. Binding Data to a Windows Forms DataGridView Control
Recipe 8.15. Modifying and Updating Data in a Windows Forms DataGridView Control
Recipe 8.16. Using Windows Forms BindingNavigator and BindingSource Controls
Recipe 8.17. Synchronizing Master-Detail Data in a Windows Forms Application
Recipe 8.18. Displaying an Image from a Database in a Windows Forms Control
Recipe 8.19. Binding a Group of Radio Buttons to a Windows Forms Data Field
Recipe 8.20. Searching a Windows Forms DataGridView Control
Chapter 9. Working with XML Data
Recipe 9.0. Introduction
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
Recipe 9.4. Creating an XML File That Shows Changes Made to a DataSet
Recipe 9.5. Synchronizing a DataSet and an XML Document
Recipe 9.6. Storing and Retrieving XML with a Non-XML Data Type Column
Recipe 9.7. Working with a SQL Server XML Data Type Column
Recipe 9.8. Using an XPath Query to Retrieve Data
Recipe 9.9. Reading XML Data Directly from SQL Server
Recipe 9.10. Transforming a DataSet Using XSLT
Recipe 9.11. Filling a DataSet Using an XML Template Query
Recipe 9.12. Using OpenXML to Update Multiple Changes to SQL Server
Chapter 10. Optimizing .NET Data Access
Recipe 10.0. Introduction
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
Recipe 10.8. Improving Paging Performance
Recipe 10.9. XML Bulk Loading with SQL Server
Recipe 10.10. Bulk Copying with SQL Server
Recipe 10.11. Improving DataReader Performance with Typed Accessors
Recipe 10.12. Improving DataReader Performance with Column Ordinals
Recipe 10.13. Debugging a SQL Server Stored Procedure
Recipe 10.14. Improving Performance While Filling a DataSet
Recipe 10.15. Reading and Writing Large-Value Data with SQL Server
Recipe 10.16. Reading and Writing a SQL Server User-Defined Type (UDT)
Recipe 10.17. Reading and Writing Oracle Large Data
Recipe 10.18. Performing Batch Updates with a DataAdapter
Recipe 10.19. Automatically Refreshing a DataTable Periodically
Recipe 10.20. Automatically Refreshing a DataTable When Underlying Data Changes
Recipe 10.21. Retrieving SQL Server Runtime Statistics
Recipe 10.22. Writing Provider- and Database-Independent Code
Chapter 11. Enumerating and Maintaining Database Objects
Recipe 11.0. Introduction
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
Recipe 11.8. Creating a New SQL Server Database
Recipe 11.9. Adding a Table to a SQL Server Database
Recipe 11.10. Creating a Database Table from a DataTable Schema
Recipe 11.11. Creating DataSet Relationships from SQL Server Relationships
Recipe 11.12. Creating a New Microsoft Access Database
Recipe 11.13. Listing Tables in an Access Database
Recipe 11.14. Enumerating .NET Data Providers
Recipe 11.15. Enumerating OLE DB Providers
Recipe 11.16. Enumerating ODBC Drivers
Recipe 11.17. Changing a SQL Server User Password
Chapter 12. SQL Server CLR Integration
Recipe 12.0. Introduction
Recipe 12.1. Creating a Stored Procedure
Recipe 12.2. Creating a Scalar-Valued Function
Recipe 12.3. Creating a Table-Valued Function
Recipe 12.4. Creating an Aggregate Function
Recipe 12.5. Creating a User-Defined Type
Recipe 12.6. Creating a DML Trigger
Recipe 12.7. Creating a DDL Trigger
Appendix A. What's New in ADO.NET Since Version 1.0
Recipe A.1. ADO.NET 2.0
Recipe A.2. ADO.NET 3.5
Colophon
Index
Download:
Link_1
0 comments:
Posting Komentar