eTutorials.org
Free programming tutorials
Chapter:
Part I: ADO.NET Tutorial
Part I: ADO.NET Tutorial
Ado.net
Preface
Audience
Contents of This Book
What's on the CD-ROM
Conventions Used in This Book
Comments and Questions
Acknowledgments
Part I: ADO.NET Tutorial
Chapter 1. Introduction
1.1 ADO.NET Data Providers
1.2 Connected and Disconnected Data
Chapter 2. .NET Data Providers
2.1 Data Providers
2.2 Selecting a Data Provider
2.3 Creating a Custom Data Provider
Chapter 3. Connections
3.1 Connection Object Overview
3.2 The Connection String
3.3 Opening and Closing Connections
3.4 Connection Pooling
Chapter 4. Commands
4.1 Command Object Overview
4.2 Creating and Executing a Command
4.3 Parameter Object Overview
4.4 Parameterized Commands
4.5 Commands with Stored Procedures
4.6 Commands and Data Definition Language (DDL)
Chapter 5. DataReaders
5.1 DataReader Object Overview
5.2 Performing a Query with a DataReader
5.3 Stored Procedures with the DataReader
5.4 DataReaders and Schema Information
Chapter 6. DataSets
6.1 Creating an Untyped DataSet
6.2 Working with Tables in the DataSet
6.3 Adding and Removing Relations
6.4 Adding Custom Information
6.5 Cloning the Schema
6.6 Copying the DataSet
6.7 Merging Two DataSets
6.8 Removing All Data
6.9 Resetting the DataSet
6.10 Committing and Discarding Changes
Chapter 7. DataTables
7.1 Creating a DataTable
7.2 Working with Columns
7.3 Constraints
7.4 Primary Key
7.5 Rows
7.6 Loading Data
7.7 Committing and Discarding Changes
7.8 Cloning the Schema of the Table
7.9 Copying the Table
7.10 Selecting a Subset of Rows
7.11 Performing Aggregate Calculations
7.12 Removing All Data
7.13 Resetting the Table
7.14 Identifying Errors in the Table
7.15 DataTable Events
Chapter 8. DataColumns
8.1 Creating DataColumns
8.2 Creating AutoIncrement Columns
8.3 Creating Expression Columns
8.4 Handling Null Values
8.5 Mapping .NET Data Provider Types to .NET Framework Types
Chapter 9. DataRows
9.1 Creating a DataRow
9.2 Updating Rows
9.3 Deleting Rows
9.4 Using Row State Information
9.5 Using Row Version Information
9.6 Accepting or Rejecting Changes to Rows
9.7 Navigating Parent and Child Rows
9.8 Using Row Error Information
Chapter 10. Constraints
10.1 Constraint Object Overview
10.2 The UniqueConstraint
10.3 The ForeignKeyConstraint
Chapter 11. DataRelations
11.1 DataRelation Object Overview
11.2 Navigating Relational Data
Chapter 12. DataViews and Data Binding
12.1 The DataView and DataViewManager
12.2 Sorting and Filtering
12.3 Accessing Data Through a DataView
12.4 Windows Data Binding
12.5 ASP.NET Data Binding
Chapter 13. Strongly Typed DataSets
13.1 Creating a Strongly Typed DataSet
13.2 Adding a Row
13.3 Editing a Row
13.4 Finding a Row
13.5 Null Data
13.6 Navigating Hierarchical Data
13.7 Annotations
Chapter 14. DataAdapters
14.1 Creating DataAdapter Object
14.2 Retrieving Data from the Data Source
14.3 Retrieving Schema Information from the Data Source
14.4 Updating the Data Source
14.5 Mapping Tables and Columns
14.6 AcceptChangesDuringFill
14.7 ContinueUpdateOnError
14.8 DataAdapter Events
Chapter 15. Updating the Data Source
15.1 SqlCommandBuilder Class Overview
15.2 Updating a Data Source Using Command Builder
15.3 Updating a Data Source Using Custom Logic
15.4 Refreshing Data After Updating
15.5 Retrieving Updated Values from the Data Source
15.6 Updating Data in Related Tables
15.7 Handling Concurrency Issues
15.8 Optimization
Chapter 16. Transactions
16.1 Manual Transactions
16.2 Isolation Levels
16.3 Savepoints
16.4 Nested Transactions
16.5 Transactions Using a DataAdapter
16.6 Automatic Transactions
Chapter 17. XML and the DataSet
17.1 DataSet XML Methods
17.2 Shaping DataSet XML
17.3 Other .NET XML Classes
17.4 XmlDataDocument Object Overview
17.5 Using the Data Objects to Edit XML
17.6 SQL Server 2000 XML
Part II: ADO.NET Core Classes
Chapter 18. The Connection Class
18.1 Comments/Troubleshooting
18.2 Properties Reference
18.3 Methods Reference
18.4 Events Reference
Chapter 19. The Command Class
19.1 Comments/Troubleshooting
19.2 Properties Reference
19.3 Collections Reference
19.4 Methods Reference
Chapter 20. The Parameter Class
20.1 Comments/Troubleshooting
20.2 Properties Reference
Chapter 21. The DataReader Class
21.1 Comments/Troubleshooting
21.2 Properties Reference
21.3 Methods Reference
Chapter 22. The DataSet Class
22.1 Comments/Troubleshooting
22.2 Properties Reference
22.3 Collections Reference
22.4 Methods Reference
22.5 Events Reference
Chapter 23. The DataTable Class
23.1 Comments/Troubleshooting
23.2 Properties Reference
23.3 Collections Reference
23.4 Methods Reference
23.5 Events Reference
Chapter 24. The DataColumn Class
24.1 Comments/Troubleshooting
24.2 Properties Reference
24.3 Collections Reference
Chapter 25. The DataRow Class
25.1 Comments/Troubleshooting
25.2 Properties Reference
25.3 Collections Reference
25.4 Methods Reference
Chapter 26. The Constraint Class
26.1 Comments/Troubleshooting
26.2 Properties Reference
26.3 Collections Reference
Chapter 27. The DataRelation Class
27.1 Comments/Troubleshooting
27.2 Properties Reference
27.3 Collections Reference
Chapter 28. The DataView Class
28.1 Comments/Troubleshooting
28.2 Properties Reference
28.3 Methods Reference
28.4 Events Reference
Chapter 29. The DataAdapter Class
29.1 Comments/Troubleshooting
29.2 Properties Reference
29.3 Collections Reference
29.4 Methods Reference
29.5 Events Reference
Chapter 30. The CommandBuilder Class
30.1 Comments/Troubleshooting
30.2 Properties Reference
30.3 Methods Reference
Chapter 31. The Transaction Class
31.1 Comments/Troubleshooting
31.2 Properties Reference
31.3 Methods Reference
Part III: API Quick Reference
Chapter 32. How to Use This Quick Reference
32.1 Finding a Quick-Reference Entry
32.2 Reading a Quick-Reference Entry
Chapter 33. Converting from C# to VB Syntax
33.1 General Considerations
33.2 Classes
33.3 Structures
33.4 Interfaces
33.5 Class, Structure, and Interface Members
33.6 Delegates
33.7 Enumerations
Chapter 34. The System.Data Namespace
''AcceptRejectRule'' ''serializable'
''CommandBehavior'' ''serializable, flag'
''CommandType'' ''serializable'
''ConnectionState'' ''serializable, flag'
''Constraint'' ''serializable'
''ConstraintCollection'' ''serializable'
''ConstraintException'' ''serializable'
''DataColumn'' ''diposable'
''DataColumnChangeEventArgs'' '''
''DataColumnChangeEventHandler'' ''serializable'
''DataColumnCollection'' ''serializable'
''DataException'' ''serializable'
''DataRelation'' ''serializable'
''DataRelationCollection'' ''serializable'
''DataRow'' ''serializable'
''DataRowAction'' ''serializable, flag'
''DataRowChangeEventArgs'' '''
''DataRowChangeEventHandler'' ''serializable'
''DataRowCollection'' ''serializable'
''DataRowState'' ''serializable, flag'
''DataRowVersion'' ''serializable'
''DataRowView'' '''
''DataSet'' ''serializable, diposable'
''DataSysDescriptionAttribute'' '''
''DataTable'' ''serializable, disposable'
''DataTableCollection'' ''serializable'
''DataView'' ''disposable'
''DataViewManager'' ''disposable'
''DataViewRowState'' ''serializable, flag'
''DataViewSetting'' ''serializable'
''DataViewSettingCollection'' ''serializable'
''DBConcurrencyException'' ''serializable'
''DbType'' ''serializable'
''DeletedRowInaccessibleException'' ''serializable'
''DuplicateNameException'' ''serializable'
''EvaluateException'' ''serializable'
''FillErrorEventArgs'' '''
''FillErrorEventHandler'' ''serializable'
''ForeignKeyConstraint'' ''serializable'
''IColumnMapping'' '''
''IColumnMappingCollection'' '''
''IDataAdapter'' '''
''IDataParameter'' '''
''IDataParameterCollection'' '''
''IDataReader'' ''dispoable'
''IDataRecord'' '''
''IDbCommand'' ''diposable'
''IDbConnection'' ''disposable'
''IDbDataAdapter'' '''
''IDbDataParameter'' '''
''IDbTransaction'' ''disposable'
''InRowChangingEventException'' ''serializable'
''InternalDataCollectionBase'' '''
''InvalidConstraintException'' ''serializable'
''InvalidExpressionException'' ''serializable'
''IsolationLevel'' ''serializable, flag'
''ITableMapping'' '''
''ITableMappingCollection'' '''
''MappingType'' ''serializable'
''MergeFailedEventArgs'' '''
''MergeFailedEventHandler'' ''serializable'
''MissingMappingAction'' ''serializable'
''MissingPrimaryKeyException'' ''serializable'
''MissingSchemaAction'' ''serializable'
''NoNullAllowedException'' ''serializable'
''ParameterDirection'' ''serializable'
''PropertyAttributes'' ''serializable, flag'
''PropertyCollection'' '''
''ReadOnlyException'' ''serializable'
''RowNotInTableException'' ''serializable'
''Rule'' ''serializable'
''SchemaType'' ''serializable'
