home movie radio music chord lyrics book game Dictionary clip
HOME HAND MADE RADIO SHOP CHORD LYRICS BOOKS GAME Dictionary Clip
[ Team LiB ] Previous Section Next Section

   
•  Table of Contents
•  Index
•  Reviews
•  Examples
•  Reader Reviews
•  Errata
ADO.NET in a Nutshell
By Bill Hamilton, Matthew MacDonald
 
Publisher : O'Reilly
Date Published : April 2003
ISBN : 0-596-00361-7
Pages : 620


    Copyright
    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
      Section 1.1.  ADO.NET Data Providers
      Section 1.2.  Connected and Disconnected Data
   
      Chapter 2.  .NET Data Providers
      Section 2.1.  Data Providers
      Section 2.2.  Selecting a Data Provider
      Section 2.3.  Creating a Custom Data Provider
   
      Chapter 3.  Connections
      Section 3.1.  Connection Object Overview
      Section 3.2.  The Connection String
      Section 3.3.  Opening and Closing Connections
      Section 3.4.  Connection Pooling
   
      Chapter 4.  Commands
      Section 4.1.  Command Object Overview
      Section 4.2.  Creating and Executing a Command
      Section 4.3.  Parameter Object Overview
      Section 4.4.  Parameterized Commands
      Section 4.5.  Commands with Stored Procedures
      Section 4.6.  Commands and Data Definition Language (DDL)
   
      Chapter 5.  DataReaders
      Section 5.1.  DataReader Object Overview
      Section 5.2.  Performing a Query with a DataReader
      Section 5.3.  Stored Procedures with the DataReader
      Section 5.4.  DataReaders and Schema Information
   
      Chapter 6.  DataSets
      Section 6.1.  Creating an Untyped DataSet
      Section 6.2.  Working with Tables in the DataSet
      Section 6.3.  Adding and Removing Relations
      Section 6.4.  Adding Custom Information
      Section 6.5.  Cloning the Schema
      Section 6.6.  Copying the DataSet
      Section 6.7.  Merging Two DataSets
      Section 6.8.  Removing All Data
      Section 6.9.  Resetting the DataSet
      Section 6.10.  Committing and Discarding Changes
   
      Chapter 7.  DataTables
      Section 7.1.  Creating a DataTable
      Section 7.2.  Working with Columns
      Section 7.3.  Constraints
      Section 7.4.  Primary Key
      Section 7.5.  Rows
      Section 7.6.  Loading Data
      Section 7.7.  Committing and Discarding Changes
      Section 7.8.  Cloning the Schema of the Table
      Section 7.9.  Copying the Table
      Section 7.10.  Selecting a Subset of Rows
      Section 7.11.  Performing Aggregate Calculations
      Section 7.12.  Removing All Data
      Section 7.13.  Resetting the Table
      Section 7.14.  Identifying Errors in the Table
      Section 7.15.  DataTable Events
   
      Chapter 8.  DataColumns
      Section 8.1.  Creating DataColumns
      Section 8.2.  Creating AutoIncrement Columns
      Section 8.3.  Creating Expression Columns
      Section 8.4.  Handling Null Values
      Section 8.5.  Mapping .NET Data Provider Types to .NET Framework Types
   
      Chapter 9.  DataRows
      Section 9.1.  Creating a DataRow
      Section 9.2.  Updating Rows
      Section 9.3.  Deleting Rows
      Section 9.4.  Using Row State Information
      Section 9.5.  Using Row Version Information
      Section 9.6.  Accepting or Rejecting Changes to Rows
      Section 9.7.  Navigating Parent and Child Rows
      Section 9.8.  Using Row Error Information
   
      Chapter 10.  Constraints
      Section 10.1.  Constraint Object Overview
      Section 10.2.  The UniqueConstraint
      Section 10.3.  The ForeignKeyConstraint
   
      Chapter 11.  DataRelations
      Section 11.1.  DataRelation Object Overview
      Section 11.2.  Navigating Relational Data
   
      Chapter 12.  DataViews and Data Binding
      Section 12.1.  The DataView and DataViewManager
      Section 12.2.  Sorting and Filtering
      Section 12.3.  Accessing Data Through a DataView
      Section 12.4.  Windows Data Binding
      Section 12.5.  ASP.NET Data Binding
   
      Chapter 13.  Strongly Typed DataSets
      Section 13.1.  Creating a Strongly Typed DataSet
      Section 13.2.  Adding a Row
      Section 13.3.  Editing a Row
      Section 13.4.  Finding a Row
      Section 13.5.  Null Data
      Section 13.6.  Navigating Hierarchical Data
      Section 13.7.  Annotations
   
      Chapter 14.  DataAdapters
      Section 14.1.  Creating DataAdapter Object
      Section 14.2.  Retrieving Data from the Data Source
      Section 14.3.  Retrieving Schema Information from the Data Source
      Section 14.4.  Updating the Data Source
      Section 14.5.  Mapping Tables and Columns
      Section 14.6.  AcceptChangesDuringFill
      Section 14.7.  ContinueUpdateOnError
      Section 14.8.  DataAdapter Events
   
      Chapter 15.  Updating the Data Source
      Section 15.1.  SqlCommandBuilder Class Overview
      Section 15.2.  Updating a Data Source Using Command Builder
      Section 15.3.  Updating a Data Source Using Custom Logic
      Section 15.4.  Refreshing Data After Updating
      Section 15.5.  Retrieving Updated Values from the Data Source
      Section 15.6.  Updating Data in Related Tables
      Section 15.7.  Handling Concurrency Issues
      Section 15.8.  Optimization
   
      Chapter 16.  Transactions
      Section 16.1.  Manual Transactions
      Section 16.2.  Isolation Levels
      Section 16.3.  Savepoints
      Section 16.4.  Nested Transactions
      Section 16.5.  Transactions Using a DataAdapter
      Section 16.6.  Automatic Transactions
   
      Chapter 17.  XML and the DataSet
      Section 17.1.  DataSet XML Methods
      Section 17.2.  Shaping DataSet XML
      Section 17.3.  Other .NET XML Classes
      Section 17.4.  XmlDataDocument Object Overview
      Section 17.5.  Using the Data Objects to Edit XML
      Section 17.6.  SQL Server 2000 XML
   
   
    Part II:  ADO.NET Core Classes
      Chapter 18.  The Connection Class
      Section 18.1.  Comments/Troubleshooting
      Section 18.2.  Properties Reference
      Section 18.3.  Methods Reference
      Section 18.4.  Events Reference
   
      Chapter 19.  The Command Class
      Section 19.1.  Comments/Troubleshooting
      Section 19.2.  Properties Reference
      Section 19.3.  Collections Reference
      Section 19.4.  Methods Reference
   
      Chapter 20.  The Parameter Class
      Section 20.1.  Comments/Troubleshooting
      Section 20.2.  Properties Reference
   
      Chapter 21.  The DataReader Class
      Section 21.1.  Comments/Troubleshooting
      Section 21.2.  Properties Reference
      Section 21.3.  Methods Reference
   
      Chapter 22.  The DataSet Class
      Section 22.1.  Comments/Troubleshooting
      Section 22.2.  Properties Reference
      Section 22.3.  Collections Reference
      Section 22.4.  Methods Reference
      Section 22.5.  Events Reference
   
      Chapter 23.  The DataTable Class
      Section 23.1.  Comments/Troubleshooting
      Section 23.2.  Properties Reference
      Section 23.3.  Collections Reference
      Section 23.4.  Methods Reference
      Section 23.5.  Events Reference
   
      Chapter 24.  The DataColumn Class
      Section 24.1.  Comments/Troubleshooting
      Section 24.2.  Properties Reference
      Section 24.3.  Collections Reference
   
      Chapter 25.  The DataRow Class
      Section 25.1.  Comments/Troubleshooting
      Section 25.2.  Properties Reference
      Section 25.3.  Collections Reference
      Section 25.4.  Methods Reference
   
      Chapter 26.  The Constraint Class
      Section 26.1.  Comments/Troubleshooting
      Section 26.2.  Properties Reference
      Section 26.3.  Collections Reference
   
      Chapter 27.  The DataRelation Class
      Section 27.1.  Comments/Troubleshooting
      Section 27.2.  Properties Reference
      Section 27.3.  Collections Reference
   
      Chapter 28.  The DataView Class
      Section 28.1.  Comments/Troubleshooting
      Section 28.2.  Properties Reference
      Section 28.3.  Methods Reference
      Section 28.4.  Events Reference
   
      Chapter 29.  The DataAdapter Class
      Section 29.1.  Comments/Troubleshooting
      Section 29.2.  Properties Reference
      Section 29.3.  Collections Reference
      Section 29.4.  Methods Reference
      Section 29.5.  Events Reference
   
      Chapter 30.  The CommandBuilder Class
      Section 30.1.  Comments/Troubleshooting
      Section 30.2.  Properties Reference
      Section 30.3.  Methods Reference
   
      Chapter 31.  The Transaction Class
      Section 31.1.  Comments/Troubleshooting
      Section 31.2.  Properties Reference
      Section 31.3.  Methods Reference
   
   
    Part III:  API Quick Reference
      Chapter 32.  How to Use This Quick Reference
      Section 32.1.  Finding a Quick-Reference Entry
      Section 32.2.  Reading a Quick-Reference Entry
   
      Chapter 33.  Converting from C# to VB Syntax
      Section 33.1.  General Considerations
      Section 33.2.  Classes
      Section 33.3.  Structures
      Section 33.4.  Interfaces
      Section 33.5.  Class, Structure, and Interface Members
      Section 33.6.  Delegates
      Section 33.7.  Enumerations
   
      Chapter 34.  The System.Data Namespace
      AcceptRejectRule
      CommandBehavior
      CommandType
      ConnectionState
      Constraint
      ConstraintCollection
      ConstraintException
      DataColumn
      DataColumnChangeEventArgs
      DataColumnChangeEventHandler
      DataColumnCollection
      DataException
      DataRelation
      DataRelationCollection
      DataRow
      DataRowAction
      DataRowChangeEventArgs
      DataRowChangeEventHandler
      DataRowCollection
      DataRowState
      DataRowVersion
      DataRowView
      DataSet
      DataSysDescriptionAttribute
      DataTable
      DataTableCollection
      DataView
      DataViewManager
      DataViewRowState
      DataViewSetting
      DataViewSettingCollection
      DBConcurrencyException
      DbType
      DeletedRowInaccessibleException
      DuplicateNameException
      EvaluateException
      FillErrorEventArgs
      FillErrorEventHandler
      ForeignKeyConstraint
      IColumnMapping
      IColumnMappingCollection
      IDataAdapter
      IDataParameter
      IDataParameterCollection
      IDataReader
      IDataRecord
      IDbCommand
      IDbConnection
      IDbDataAdapter
      IDbDataParameter
      IDbTransaction
      InRowChangingEventException
      InternalDataCollectionBase
      InvalidConstraintException
      InvalidExpressionException
      IsolationLevel
      ITableMapping
      ITableMappingCollection
      MappingType
      MergeFailedEventArgs
      MergeFailedEventHandler
      MissingMappingAction
      MissingPrimaryKeyException
      MissingSchemaAction
      NoNullAllowedException
      ParameterDirection
      PropertyAttributes
      PropertyCollection
      ReadOnlyException
      RowNotInTableException
      Rule
      SchemaType
      SqlDbType
      StateChangeEventArgs
      StateChangeEventHandler
      StatementType
      StrongTypingException
      SyntaxErrorException
      TypedDataSetGenerator
      TypedDataSetGeneratorException
      UniqueConstraint
      UpdateRowSource
      UpdateStatus
      VersionNotFoundException
      XmlReadMode
      XmlWriteMode
   
      Chapter 35.  The System.Data.Common Namespace
      DataAdapter
      DataColumnMapping
      DataColumnMappingCollection
      DataTableMapping
      DataTableMappingCollection
      DbDataAdapter
      DBDataPermission
      DBDataPermissionAttribute
      DbDataRecord
      DbEnumerator
      RowUpdatedEventArgs
      RowUpdatingEventArgs
   
      Chapter 36.  The System.Data.SqlClient Namespace
      SqlClientPermission
      SqlClientPermissionAttribute
      SqlCommand
      SqlCommandBuilder
      SqlConnection
      SqlDataAdapter
      SqlDataReader
      SqlError
      SqlErrorCollection
      SqlException
      SqlInfoMessageEventArgs
      SqlInfoMessageEventHandler
      SqlParameter
      SqlParameterCollection
      SqlRowUpdatedEventArgs
      SqlRowUpdatedEventHandler
      SqlRowUpdatingEventArgs
      SqlRowUpdatingEventHandler
      SqlTransaction
   
      Chapter 37.  The System.Data.OleDb Namespace
      OleDbCommand
      OleDbCommandBuilder
      OleDbConnection
      OleDbDataAdapter
      OleDbDataReader
      OleDbError
      OleDbErrorCollection
      OleDbException
      OleDbInfoMessageEventArgs
      OleDbInfoMessageEventHandler
      OleDbParameter
      OleDbParameterCollection
      OleDbPermission
      OleDbPermissionAttribute
      OleDbRowUpdatedEventArgs
      OleDbRowUpdatedEventHandler
      OleDbRowUpdatingEventArgs
      OleDbRowUpdatingEventHandler
      OleDbSchemaGuid
      OleDbTransaction
      OleDbType
   
      Chapter 38.  The System.Data.SqlTypes Namespace
      INullable
      SqlBinary
      SqlBoolean
      SqlByte
      SqlCompareOptions
      SqlDateTime
      SqlDecimal
      SqlDouble
      SqlGuid
      SqlInt16
      SqlInt32
      SqlInt64
      SqlMoney
      SqlNullValueException
      SqlSingle
      SqlString
      SqlTruncateException
      SqlTypeException
   
   
    Part IV:  Appendixes
      Appendix A.  ADO.NET Providers
      Section A.1.  The SQL Server Provider
      Section A.2.  The OLE DB Provider
      Section A.3.  The ODBC .NET Provider
      Section A.4.  The Oracle .NET Provider
      Section A.5.  The ODP.NET Provider
   
      Appendix B.  ADO.NET XML Extensions
      Section B.1.  codegen Namespace
      Section B.2.  msdata Namespace
      Section B.3.  diffgr Namespace
   
      Appendix C.  Microsoft Data Engine (MSDE)
      Section C.1.  Installing MSDE
      Section C.2.  MSDE Essentials
      Section C.3.  Adding the Northwind Data
      Section C.4.  Migrating MSDE to SQL Server
   
      Type, Method, Property, and Field Index
      A-L
      M-Z
   
   
    Colophon
    Index
[ Team LiB ] Previous Section Next Section