|
Introduction to ADO.NET
Microsoft Data Access Technologies
ODBC
OLE DB
ActiveX Data Objects (ADO)
ADO.NET
ADO.NET Architecture
.NET Data Providers
Programming with ADO.NET Interfaces
.NET Namespaces
Connected Data Access
ADO.NET Class Libraries
Connecting to an OLE DB Data Provider
Using Commands
Creating a Command Object
ExecuteNonQuery
Using a Data Reader
Disconnected DataSets
Data Adapters
Command Builder
Filling the DataSet
Displaying a DataSet
Addding, Changing & Deleting Rows
Updating the Database
Relationships
Stored Procedure
ADO.NET Connections
ADO.NET Block Diagram
.NET Data Providers
Namespaces
Basic Connection Programming
Using Interfaces
IDbConnection Properties
Connection String
SQL Server Connection String
OLE DB Connection String
IDbConnection Methods
Connection Life Cycle
ChangeDatabase
Connection Pooling
Pool Settings for SQL Server
Connection Events
ADO.NET Error Handling
Using List Boxes
ADO.NET Commands
Command Objects
Creating Commands
Executing Commands
Dynamic Queries
Parameterized Queries
CommandTypes
Stored Procedures
Batch Queries
Transactions
DataReaders & Connected Access
DataReaders
Using a DataReader
Closing a DataReader
IDataRecord
Type-Safe Accessors
GetOrdinal()
Null Data
Testing for Null
ExecuteReader Options
Returning Multiple Result Sets
DataReader Multiple Results Sets
Obtaining Schema Information
Using Dialog Boxes
Returning a DialogResult
DataSets & Disconnected Access
DataSet
DataSet Architecture
Why DataSet?
DataSet Components
DataAdapter
Filling a DataSet
Accessing a DataSet
Updating a DataSet
Adding a New Row
Search and Update
Deleting a Row
Row Versions
Row State
BeginEdit and CancelEdit
DataTable Events
Updating a Database
Insert Command
Update Command
Delete Command
Command Builders
|
More about DataSets
Filtering DataSets
Using a Single DataTable
Multiple Tables
DataSet Architecture
Schema in the DataSet
Inferring Schema
AddWithKey
Relations
Adding a Primary Key
Identity Columns
Navigating a DataSet
TableMappings
Manual Creationg of a DataSet
Manual DataSet Code
XML & ADO.NET
ADO.NET and XML
Rendering XML form a DataSet
XmlWriteMode
Writing Data as Attributes
Reading XML into a DataSet
DataSets and XML Schema
Reading XML Schema
XmlReadMode
XML Data in DataTables
Typed DataSets
Table Adapter
Synchronising DatSets and XML
Using XmlDataDocument
XML Serialisation
Default Constructor
Data Binding
Data Binding Concept
Simple Data Binding
Binding to a List
Binding to a DataGrid
Complex Data Binding
DataView
Filtering & Sorting
DataView & DataBinding
New Data Binding
BindingSource Architecture
Binding to a List
Setting up the Bindings
DataGridView Control
Performing a Query
Concurrency & Transactions
DataSets & Concurrency
Handling Concurrency Violations
Pessimistic Concurrency
Transactions
Programming ADO.NET Transactions
ADO.NET Transaction Code
Database Transactions
Transaction in Stored Procedure
New Features in ADO.NET 2.0
Creating a Data Connection
Using Database Explorer
Performing a Query
Using a Data Connection
Connected Database Access
Long Database Operations
Asynchronous Operations
Enumerating SQL Server Instances
Multiple Active Result Sets
Bulk Copy
|