Mastering C# Database Programming

Jason Price, Sybex

ISBN:0782141838, Edition: 1, 2003-05-06

Price: $59.99

• Table of Contents
• BackCover
• Mastering C# Database Programming
• Introduction
  • How to Use This Book
  • Downloading the Example Programs
• Part 1: 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 2: 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
    • Using the Get* Methods to Read Column Values
    • An Example of Using the Get* Methods
    • 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 3: 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
  • Index_B
  • Index_C
  • Index_D
  • Index_E
  • Index_F
  • Index_G
  • Index_H
  • Index_I
  • Index_J
  • Index_K
  • Index_L
  • Index_M
  • Index_N
  • Index_O
  • Index_P
  • Index_Q
  • Index_R
  • Index_S
  • Index_T
  • Index_U
  • Index_V
  • Index_W
  • Index_X
  • Index_Y
• List of Figures
• List of Tables
• List of Listings
• List of Sidebars