Mastering C# Database Programming -- Acknowledgments -- Contents at a Glance -- Contents -- Introduction -- Who Should Read This Book? -- How to Use This Book -- Downloading the Example Programs -- Part I: Introduction to ADO.NET and Databases -- Chapter 1: Introduction to Database Programming with ADO.NET -- Obtaining the Required Software -- Developing Your First ADO.NET Program -- Connecting to Access and Oracle Databases -- Introducing Visual Studio .NET -- Using the .NET Documentation -- Using the SQL Server Documentation -- Summary -- Chapter 2: Introduction to Databases -- Introducing Databases -- Using SQL Server -- Exploring the Northwind Database -- Building Queries Using Enterprise Manager -- Creating a Table -- Summary -- Chapter 3: Introduction to Structured Query Language (SQL) -- Using SQL -- Accessing a Database Using Visual Studio .NET -- Summary -- Chapter 4: Introduction to Transact-SQL Programming -- Fundamentals of Transact-SQL -- Using Cursors -- Using Functions -- Creating User-Defined Functions -- Introducing Stored Procedures -- Introducing Triggers -- Summary -- Chapter 5: Overview of the ADO.NET Classes -- The Managed Provider and Generic Data Set Classes -- Performing a SQL SELECT Statement and Storing the Rows Locally -- Summary -- Chapter 6: Introducing Windows Applications and ADO.NET -- Developing a Simple Windows Application -- Using Windows Controls -- Using a DataGrid Control to Access a Database -- Using the Data Form Wizard to Create a Windows Form -- Summary -- Part II: Fundamental Database Programming with ADO.NET -- Chapter 7: Connecting to a Database -- Understanding the SqlConnection Class -- Using a SqlConnection Object to Connect to a SQL Server Database -- Creating a Connection Object Using Visual Studio .NET -- Summary -- Chapter 8: Executing Database Commands -- The SqlCommand Class.

Creating a SqlCommand Object -- Executing SELECT Statements and TableDirect Commands -- Executing Commands that Modify Information in the Database -- Introducing Transactions -- Supplying Parameters to Commands -- Executing SQL Server Stored Procedures -- Creating a Command Object Using Visual Studio .NET -- Summary -- Chapter 9: Using DataReader Objects to Read Results -- The SqlDataReader Class -- Creating a SqlDataReader Object -- Reading Rows from a SqlDataReader Object -- Returning Strongly Typed Column Values -- Reading Null Values -- Executing Multiple SQL Statements -- Using a DataReader Object in Visual Studio .NET -- Summary -- Chapter 10: Using DataSet Objects to Store Data -- The SqlDataAdapter Class -- The DataSet Class -- Writing and Reading XML Using a DataSet Object -- Mapping Tables and Columns -- Reading a Column Value Using Strongly Typed DataSet Classes -- Creating a DataAdapter Object Using Visual Studio .NET -- Creating a DataSet Object Using Visual Studio .NET -- Summary -- Chapter 11: Using DataSet Objects to Modify Data -- The DataTable Class -- The DataRow Class -- The DataColumn Class -- Adding Restrictions to DataTable and DataColumn Objects -- Finding, Filtering, and Sorting Rows in a DataTable -- Modifying Rows in a DataTable -- Retrieving New Identity Column Values -- Using Stored Procedures to Add, Modify, and Remove Rows from the Database -- Automatically Generating SQL Statements -- Exploring the DataAdapter and DataTable Events -- Dealing with Update Failures -- Using Transactions with a DataSet (SQL) -- Modifying Data Using a Strongly Typed DataSet -- Summary -- Chapter 12: Navigating and Modifying Related Data -- The UniqueConstraint Class -- Creating a UniqueConstraint Object -- The ForeignKeyConstraint Class -- Creating a ForeignKeyConstraint Object -- The DataRelation Class.

Creating and Using a DataRelation Object -- Adding, Updating, and Deleting Related Rows -- Issues Involved When Updating the Primary Key of a Parent Row -- Nested XML -- Defining a Relationship Using Visual Studio .NET -- Summary -- Chapter 13: Using DataView Objects -- The DataView Class -- Creating and Using a DataView Object -- Using the Default Sort Algorithm -- Performing Advanced Filtering -- The DataRowView Class -- Finding DataRowView Objects in a DataView -- Adding, Modifying, and Removing DataRowView Objects from a DataView -- Creating Child DataView Objects -- The DataViewManager Class -- Creating and Using a DataViewManager Object -- Creating a DataView Using Visual Studio .NET -- Summary -- Part III: Advanced Database Programming with ADO.NET -- Chapter 14: Advanced Transaction Control -- The SqlTransaction Class -- Setting a Savepoint -- Setting the Transaction Isolation Level -- Understanding SQL Server Locks -- Summary -- Chapter 15: Introducing Web Applications-ASP.NET -- Creating a Simple ASP.NET Web Application Using VS .NET -- The Web Form Controls -- Building a More Complex Application -- Using a DataGrid Control to Access a Database -- Using a DataList Control to Access a Database -- Maintaining State in a Web Application -- Creating a Simple Shopping Cart Application -- Summary -- Chapter 16: Using SQL Server's XML Support -- Using the SQL Server FOR XML Clause -- Introducing XPath -- Introducing XSLT -- Accessing SQL Server Using HTTP -- Using the SQL Server OPENXML() Function -- Using an XmlDocument Object to Store an XML Document -- Using an XmlDataDocument Object to Store an XML Document -- Summary -- Chapter 17: Web Services -- Creating a Web Service -- Viewing a WSDL File and Testing a Web Service -- Using a Web Service -- Registering a Web Service -- Summary -- Index.