Home
Programming

Ado.net

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.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.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.3 Structures

33.4 Interfaces

33.5 Class, Structure, and Interface Members

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'

''SqlDbType'' ''serializable'

''StateChangeEventArgs'' '''

''StateChangeEventHandler'' ''serializable'

''StatementType'' ''serializable'

''StrongTypingException'' ''serializable'

''SyntaxErrorException'' ''serializable'

''TypedDataSetGenerator'' '''

''TypedDataSetGeneratorException'' ''serializable'

''UniqueConstraint'' ''serializable'

''UpdateRowSource'' ''serializable'

''UpdateStatus'' ''serializable'

''VersionNotFoundException'' ''serializable'

''XmlReadMode'' ''serializable'

''XmlWriteMode'' ''serializable'

Chapter 35. The System.Data.Common Namespace

''DataAdapter'' ''marshal by reference, disposable'

''DataColumnMapping'' ''marshal by reference'

''DataColumnMappingCollection'' ''marshal by reference'

''DataTableMapping'' ''marshal by reference'

''DataTableMappingCollection'' ''marshal by reference'

''DbDataAdapter'' ''marshal by reference, disposable'

''DBDataPermission'' ''serializable'

''DBDataPermissionAttribute'' ''serializable'

''DbDataRecord'' '''

''DbEnumerator'' '''

''RowUpdatedEventArgs'' '''

''RowUpdatingEventArgs'' '''

Chapter 36. The System.Data.SqlClient Namespace

''SqlClientPermission'' ''serializable'

''SqlClientPermissionAttribute'' ''serializable'

''SqlCommand'' ''marshal by reference, disposable'

''SqlCommandBuilder'' ''marshal by reference, disposable'

''SqlConnection'' ''marshal by reference, disposable'

''SqlDataAdapter'' ''marshal by reference, disposable'

''SqlDataReader'' ''marshal by reference, disposable'

''SqlError'' ''serializable'

''SqlErrorCollection'' ''serializable'

''SqlException'' ''serializable'

''SqlInfoMessageEventArgs'' '''

''SqlInfoMessageEventHandler'' ''serializable'

''SqlParameter'' ''marshal by reference'

''SqlParameterCollection'' ''marshal by reference'

''SqlRowUpdatedEventArgs'' '''

''SqlRowUpdatedEventHandler'' ''serializable'

''SqlRowUpdatingEventArgs'' '''

''SqlRowUpdatingEventHandler'' ''serializable'

''SqlTransaction'' ''marshal by reference, disposable'

Chapter 37. The System.Data.OleDb Namespace

'OleDbCommand'' ''marshal by reference, disposable''

'OleDbCommandBuilder'' ''marshal by reference, disposable''

''OleDbConnection'' ''marshal by reference, disposable'

''OleDbDataAdapter'' ''marshal by reference, disposable'

''OleDbDataReader'' ''marshal by reference, disposable'

''OleDbError'' ''serializable'

''OleDbErrorCollection'' ''serializable'

''OleDbException'' ''serializable'

''OleDbInfoMessageEventArgs'' '''

''OleDbInfoMessageEventHandler'' ''serializable'

''OleDbParameter'' ''marshal by reference'

''OleDbParameterCollection'' ''marshal by reference'

''OleDbPermission'' ''serializable'

''OleDbPermissionAttribute'' ''serializable'

''OleDbRowUpdatedEventArgs'' '''

''OleDbRowUpdatedEventHandler'' ''serializable'

''OleDbRowUpdatingEventArgs'' '''

''OleDbRowUpdatingEventHandler'' ''serializable'

''OleDbSchemaGuid'' '''

''OleDbTransaction'' ''marshal by reference, disposable'

''OleDbType'' ''serializable'

Chapter 38. The System.Data.SqlTypes Namespace

''INullable'' '''

''SqlBinary'' '''

''SqlBoolean'' '''

''SqlByte'' '''

''SqlCompareOptions'' ''serializable, flag'

''SqlDateTime'' '''

''SqlDecimal'' '''

''SqlDouble'' '''

''SqlGuid'' '''

''SqlInt16'' '''

''SqlInt32'' '''

''SqlInt64'' '''

''SqlMoney'' '''

''SqlNullValueException'' ''serializable'

''SqlSingle'' '''

''SqlString'' '''

''SqlTruncateException'' ''serializable'

''SqlTypeException'' ''serializable'

Part IV: Appendixes

Appendix A. ADO.NET Providers

A.1 The SQL Server Provider

A.2 The OLE DB Provider

A.3 The ODBC .NET Provider

A.4 The Oracle .NET Provider

A.5 The ODP.NET Provider

Appendix B. ADO.NET XML Extensions

B.1 codegen Namespace

B.2 msdata Namespace

B.3 diffgr Namespace

Appendix C. Microsoft Data Engine (MSDE)

C.1 Installing MSDE

C.2 MSDE Essentials

C.3 Adding the Northwind Data

C.4 Migrating MSDE to SQL Server

Type, Method, Property, and Field Index

Remember the name: eTutorials.org

Copyright eTutorials.org 2008-2023. All rights reserved.