HTTP/2 302 server: nginx date: Tue, 05 Aug 2025 12:52:00 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20100105185336 location: https://web.archive.org/web/20100105185336/https://safari.oreilly.com/9780596101404 server-timing: captures_list;dur=0.706872, exclusion.robots;dur=0.026621, exclusion.robots.policy;dur=0.013424, esindex;dur=0.015346, cdx.remote;dur=29.614294, LoadShardBlock;dur=486.518726, PetaboxLoader3.datanode;dur=68.079058, PetaboxLoader3.resolve;dur=307.725599 x-app-server: wwwb-app214 x-ts: 302 x-tr: 541 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: wb-p-SERVER=wwwb-app214; path=/ x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 301 server: nginx date: Tue, 05 Aug 2025 12:52:02 GMT content-length: 0 x-archive-orig-content-length: 0 location: https://web.archive.org/web/20100105185336/https://my.safaribooksonline.com/9780596101404?portal=oreilly x-archive-orig-server: SWS + Microsoft-HTTPAPI/2.0 x-archive-orig-date: Tue, 05 Jan 2010 18:53:37 GMT x-archive-orig-connection: close x-archive-orig-set-cookie: Safari=cookieversion=2&portal=oreilly&key=&sessionid=267414a8-0f65-4954-b795-aab091ad0ec8&ref=Undefined&oref=http%3a%2f%2foreilly.com%2f; Path=/; Domain=safari.oreilly.com cache-control: max-age=1800 memento-datetime: Tue, 05 Jan 2010 18:53:36 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Sun, 11 May 2008 20:02:54 GMT", ; rel="prev memento"; datetime="Sat, 05 Sep 2009 06:21:12 GMT", ; rel="memento"; datetime="Tue, 05 Jan 2010 18:53:36 GMT", ; rel="next memento"; datetime="Thu, 21 Oct 2010 08:42:32 GMT", ; rel="last memento"; datetime="Wed, 31 Aug 2011 11:22:33 GMT" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: TLA-20100105183421-00315-00324-ia360913-20100114113045-00000-c/TLA-20100105184320-00397-ia360906.us.archive.org.warc.gz server-timing: captures_list;dur=0.567434, exclusion.robots;dur=0.023093, exclusion.robots.policy;dur=0.010295, esindex;dur=0.011986, cdx.remote;dur=166.425252, LoadShardBlock;dur=335.165996, PetaboxLoader3.datanode;dur=128.099352, PetaboxLoader3.resolve;dur=721.867204, load_resource;dur=528.988220 x-app-server: wwwb-app214 x-ts: 301 x-tr: 1071 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 302 server: nginx date: Tue, 05 Aug 2025 12:52:03 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20110812040820 location: https://web.archive.org/web/20110812040820/https://my.safaribooksonline.com/9780596101404?portal=oreilly server-timing: captures_list;dur=0.705509, exclusion.robots;dur=0.028323, exclusion.robots.policy;dur=0.013424, esindex;dur=0.015358, cdx.remote;dur=18.815788, LoadShardBlock;dur=773.909179, PetaboxLoader3.datanode;dur=600.706609, PetaboxLoader3.resolve;dur=66.991210 x-app-server: wwwb-app214 x-ts: 302 x-tr: 825 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 200 server: nginx date: Tue, 05 Aug 2025 12:52:03 GMT content-type: text/html; charset=utf-8 x-archive-orig-expires: Mon, 05 Apr 1970 03:12:07 GMT x-archive-orig-server: SWS + Microsoft-HTTPAPI/2.0 x-archive-orig-cache-control: private x-archive-orig-p3p: CP="CAO DSP COR LAW CUR ADMi DEVi PSAi IVAi IVDi CONo HISi TELo OUR IND UNI" x-archive-orig-date: Fri, 12 Aug 2011 04:08:21 GMT x-archive-orig-connection: close x-archive-orig-set-cookie: Safari=cookieversion=2&cookie-monster=false&portal=oreilly&key=&sessionid=5185b201-3df7-44e2-90ef-2e1f19dc7f6f&ref=Undefined&oref=%2f; Path=/; Domain=my.safaribooksonline.com x-archive-orig-set-cookie: cookie-monster=true; Path=/; Expires=Thu, 12 Aug 2021 04:08:21 GMT x-archive-guessed-content-type: text/html x-archive-guessed-charset: utf-8 memento-datetime: Fri, 12 Aug 2011 04:08:20 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate", ; rel="first memento"; datetime="Fri, 12 Aug 2011 04:08:20 GMT", ; rel="memento"; datetime="Fri, 12 Aug 2011 04:08:20 GMT", ; rel="last memento"; datetime="Fri, 12 Aug 2011 04:08:20 GMT" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: WIDE-20110812032005-crawl416/WIDE-20110812035617-00213.warc.gz server-timing: captures_list;dur=0.685038, exclusion.robots;dur=0.015307, exclusion.robots.policy;dur=0.007771, esindex;dur=0.010483, cdx.remote;dur=196.429042, LoadShardBlock;dur=94.696840, PetaboxLoader3.datanode;dur=105.150269, load_resource;dur=134.633806, PetaboxLoader3.resolve;dur=72.322078 x-app-server: wwwb-app214 x-ts: 200 x-tr: 621 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() content-encoding: gzip

Content Tabs

• Home
• Subscribe
• Free Trial

• Category Map
• My Quick Links
  • Books
  • Video
  • Rough Cuts
  • Short Cuts
  • Tools

Search:criteria:Entire SiteBook/Video TitlesShort CutsRough Cuts

Sign In

• ADO.NET 3.5 Cookbook, 2nd Edition

• By: Bill Hamilton

• Publisher: O'Reilly Media, Inc.

• Pub. Date: March 28, 2008

• Print ISBN-13: 978-0-596-10140-4

• Pages in Print Edition: 992

• Amazon.com® Reviews

• Subscriber Rating: [1 Rating]

• Overview
• Table of Contents
• Extras
• Search This Book
• Help

Amazon.com Reader Reviews • Subscriber Reviews • Browse Similar Topics

Overview

Other Readers Also Read...

C# 3.0 Cookbook, 3rd Edition
by Jay Hilyard; Stephen Teilhet

Top Sellers in this Category

Windows 7: The Missing Manual
by David Pogue

Excel® 2010 Bible
by John Walkenbach

Pro C# 2010 and the .NET 4 Platform
by Andrew Troelsen

Pro ASP.NET MVC 3 Framework, Third Edition
by Adam Freeman; Steven Sanderson

MCTS Self-Paced Training Kit (Exam 70-516): Accessing Data with Microsoft® .NET Framework 4
by Glenn Johnson

This guide 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 also offers clear explanations of how and why each code solution works, and warns you of potential pitfalls so you can learn to adapt the book's problem-solving techniques to different situations. This collection of timesaving recipes covers vital topics including:

• Connecting to data

• Retrieving and managing data

• Transforming and analyzing data

• Modifying data

• Binding data to .NET user interfaces

• Optimizing .NET data access

• Enumerating and maintaining database objects

• Maintaining database integrity

Ideal for ADO.NET programmers at all levels, from the relatively inexperienced to the most sophisticated, this new edition covers the significant 3.5 upgrade, including new programming tools such as LINQ. ADO.NET 3.5 Cookbook offers a painless way for those of you who prefer to learn by doing when it comes to expanding your skills and productivity.

Subscriber Reviews

Average Rating:  Based on 1 Rating

No Subscribers have provided a review for this book.

Browse Similar Topics

Top Level Categories:
Information Technology & Software Development
Product
Vendor

Sub-Categories:
Information Technology & Software Development > Programming
Programming > Microsoft ADO.NET
Product > Microsoft .NET
Vendor > Microsoft

Some information on this page was provided using data from Amazon.com®. View at Amazon >

Table of Contents

 

ADO.NET 3.5 Cookbook™, Second Edition

Preface

Section P2.1. What's New in the Second Edition

Section P2.2. Who This Book Is For

Section P2.3. What You Need to Use This Book

Section P2.4. How This Book Is Organized

Section P2.5. What Was Left Out

Section P2.6. Conventions Used in This Book

Section P2.7. About the Code

Section P2.8. Using Code Examples

Section P2.9. Comments and Questions

Section P2.10. Safari® Books Online

Section P2.11. Acknowledgments

Download Chapter
1 TokenChapter 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

Download Chapter
1 TokenChapter 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

Download Chapter
1 TokenChapter 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

Download Chapter
1 TokenChapter 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

Download Chapter
1 TokenChapter 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

Download Chapter
1 TokenChapter 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

Download Chapter
1 TokenChapter 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

Download Chapter
1 TokenChapter 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

Download Chapter
1 TokenChapter 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

Download Chapter
1 TokenChapter 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

Download Chapter
1 TokenChapter 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

Download Chapter
1 TokenAppendix 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

Extras

The publisher has provided additional content related to this title.

Description	Content
These links have been provided by the publisher.	catalog-page errata examples

---

About Safari Books Online • Terms of Service • Gift Subscriptions • Privacy Policy • Contact Us • Corporate Licenses • Help • Accessibility |

Copyright 2011Safari Books Online. All rights reserved.