Table of content

   
  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


ADO. NET in a Nutshell
ADO.NET in a Nutshell
ISBN: 0596003617
EAN: 2147483647
Year: 2005
Pages: 415

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net