Chapter 14. Database Programming with ADO.NET

Section 14.0.   Introduction

Section 14.1.   Creating a Database Connection

Section 14.2.   Creating and Filling DataSet s

Section 14.3.   Generating an XML Schema for an Untyped DataSet

Section 14.4.   Reading Database Records Using SqlDataReader

Section 14.5.   Creating Forms with the Data Form Wizard

Section 14.6.   Using Commands and Stored Procedures

Section 14.7.   Displaying a DataGrid

Section 14.8.   Databinding Windows Form Controls

Section 14.9.   Using CommandBuilder to Automatically Generate Commands

Section 14.10.   Creating Different DataView s of a Table

Section 14.11.   Adding New Tables to a DataSet

Section 14.12.   Creating Unique Constraints

Section 14.13.   Creating ForeignKey Constraints

Section 14.14.   Inserting New Rows into a DataTable

Section 14.15.   Modifying Rows in a DataTable

Section 14.16.   Navigating Tables Using DataRelations

Section 14.17.   Saving DataSet Information to an XML File

Section 14.18.   Restoring a DataSet from an XML File

Section 14.19.   Merging DataSet s

Section 14.20.   Modifying Pooling Behavior for SQL Server Connections

Section 14.21.   Ensuring Data Integrity Using Transactions