List of Tables

Chapter 3: ADO.NET in Disconnected Environments

Table 3-1: The System.Data Namespace Classes

Table 3-2: The System.Data.Common Namespace Classes

Table 3-3: The DataColumn Class Properties

Table 3-4: The DataRow Class Properties

Table 3-5: The DataRow Class Methods

Table 3-6: The DataRowState Enumeration Members

Table 3-7: The DataTable Class Properties

Table 3-8: The DataTable Class Methods

Table 3-9: The DataView Class Properties

Table 3-10: The DataView Class Methods

Table 3-11: DataSetView Properties

Chapter 4: ADO.NET in Connected Environments

Table 4-1: Sql Data Provider Classes

Table 4-2: Connection Object Properties

Table 4-3: The ConnectionType Enumeration Members

Table 4-4: The Connection Class Members

Table 4-5: The OLE DB Services Settings

Table 4-6: Connection Pooling Settings

Table 4-7: The Command Properties

Table 4-8: The CommandType Enumeration Members

Table 4-9: The DataReader Properties

Table 4-10: The DataReader Methods

Table 4-11: The SqlDataAdpater Class Properties

Table 4-12: OleDbDataAdapter Command Properties with Examples

Table 4-13: The DataAdapter Methods

Table 4-14: The SqlParameter Class Properties

Table 4-15: Methods of the Transaction Class

Table 4-16: Isolation Levels Available for Transactions

Table 4-17: Transaction Methods in the Sql Data Provider

Chapter 5: Handling ADO.NET Events

Table 5-1: InfoMessageEventArgs Properties

Table 5-2: The ConnectionState Enumeration Members

Table 5-3: The FillErrorEventArgs Members

Table 5-4: The SqlRowUpdatedEventArgs Members

Table 5-5: The DataTable Events

Table 5-6: XmlDataDocument Events

Table 5-7: The XmlNodeChangedEventArgs Properties

Table 5-8: The ListChangedEventArgs Members

Chapter 6: Integrating XML with ADO.NET

Table 6-1: The XmlNodeType Enumeration's Members

Table 6-2: The XmlReader Class Properties

Table 6-3: The XmlReader Class Methods

Table 6-4: Some XmlElement Class Methods

Table 6-5: The XmlReadMode Members

Table 6-6: The XmlWriteMode Members

Table 6-7: XPathNavigator Members

Chapter 7: Data Binding and Windows Forms Data-Bound Controls

Table 7-1: The BindingManagerBase Class Methods

Table 7-2: The DataGrid Class Properties

Table 7-3: The DataGrid Class Methods

Table 7-4: The DataGrid Class Protected Methods

Table 7-5: The DataGridColumnStyle Properties

Table 7-6: The DataGridColumnStyle Methods

Table 7-7: The DataGridBoolColumn Properties

Table 7-8: The DaaGrid.HitTestType Enumeration

Chapter 8: Constraints and Data Relations

Table 8-1: The ForeignKeyConstraint Class Properties

Table 8-2: The UniqueConstraint Class Properties

Table 8-3: The ConstraintCollection Class Methods

Table 8-4: The DataRelation Class Properties

Table 8-5: The DataRelationCollection Class Methods

Chapter 9: ADO.NET Exception Handling

Table 9-1: Exception Class Properties

Table 9-2: The System.Data Exception Classes

Table 9-3: Severity Levels

Table 9-4: The SqlException Class Properties

Chapter 10: Working with the ODBC .NET Data Provider

Table 10-1: The ODBC .NET Data Provider Classes

Chapter 11: Stored Procedures and Views

Table 11-1: The ParameterDirection Members

Chapter 12: Oracle, SQLXML, and Other .NET Data Providers

Table 12-1: Oracle Data Provider Classes

Table 12-2: The SqlXmlCommand Properties

Table 12-3: The SqlXmlCommandType Members

Chapter 13: Developing a Custom Data Provider

Table 13-1: The Properties of the IDbConnection Interface

Table 13-2: The Methods of the IDbConnection Interface

Table 13-3: The Properties of the IDbCommand Interface

Table 13-4: The Methods of the IDbCommand Interface

Table 13-5: The Properties of the IDataReader Interface

Table 13-6: The Methods of the IDataReader Interface

Table 13-7: The Properties of the IDataRecord Interface

Table 13-8: The Methods of the IDataRecord Interface

Table 13-9: The Properties of the IDbDataAdapter Interface

Table 13-10: The Properties of the IDbDataAdapter Object

Table 13-11: The Methods of the IDbDataAdapter Object

Chapter 14: Developing Database Web Applications using ASP.NET

Table 14-1: HTML Server Controls

Table 14-2: Web Server Controls

Table 14-3: Validation Controls

Table 14-4: ASP.NET Data-Bound Controls

Table 14-5: DataGrid Control Properties

Table 14-6: Web Controls on MyGuestBook.aspx Page

Table 14-7: Web Controls of ViewGuestBook.aspx

Table 14-8: Controls of Thanks.aspx Page

Chapter 16: ASP.NET Server Controls and Data Binding

Table 16-1: The Calendar Class Properties

Table 16-2: ASP.NET Templates

Table 16-3: Templates Supported by the Repeater Control

Table 16-4: The Values of the B Part of the Data Format String of ListControl

Table 16-5: The BaseDataList Class Properties

Table 16-6: The DataList Class Properties

Table 16-7: The TableItemStyle Class Properties

Table 16-8: The DataGrid Control Events

Chapter 18: Object-Relational Mapping in .NET

Table 18-1: The VideoTape Table

Table 18-2: The VideoCheckIn Table

Table 18-3: The VideoCheckOut Table

Table 18-4: The Users Table

Chapter 19: Mapped Objects: Performance Considerations and Data Binding

Table 19-1: The VideoCategory Table, the Poor Performance Way

Table 19-2: The VideoCategory Table, the High Performance Way

Table 19-3: The BlockedTree Table

Table 19-4: An Indexed Table

Chapter 20: COM Interoperability and ADO.NET

Table 20-1: Tlbimp.exe Options

Table 20-2: Tlbexp.exe Options

Chapter 21: Messaging

Table 21-1: The MessageQueue Class Properties

Table 21-2: The MessageQueueCriteria Class Properties

Table 21-3: Path for Different Types of Queues

Table 21-4: The MessagePriority Enumeration Members

Appendix A: Relational Databases: Some Basic Concepts

Table A-1: Recordset Cursor Type and Their Values in ADO

Table A-2: Isolation Levels

Table A-3: Isolation Levels and Data Consistency

Table A-4: Locking Types

Appendix B: Commonly Used SQL Statements

Table B-1: Conditional Statements Used in SQL

Appendix C: ADO.NET Frequently Asked Questions

Table C-1: IDataReader Meta-Data

Table C-2: The Registry Class Members

Table C-3: The RegistryKey Class Properties

Table C-4: The RegistryKey Class Methods

Table C-5: The DiffGram Elements

Table C-6: The DataRowState Members

Table C-7: The CommandBehavior Enumeration