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

Applied ADO. NET(c) Building Data-Driven Solutions
Applied ADO.NET: Building Data-Driven Solutions
ISBN: 1590590732
EAN: 2147483647
Year: 2006
Pages: 214 © 2008-2017.
If you may any questions please contact us: