  
                     
|
| |
 |
ADO.NET USING C#
| Course Description |
|
This three-day, intensive course teaches the essential elements of ADO.NET such that, at the end of the course, the programmer is able to utilize its tremendous database manipulation powers to build effective database applications. The course includes a major case study demonstrating the use of ADO.NET in a realistic setting.
Course Length: 3 Days
Course Tuition: $1190 (US)
|
| Prerequisites |
|
| SQL Programming, Fundamentals of XML and The .NET Framework Using C#. The ability to write simple Windows Forms applications and a working knowledge of SQL Server are recommended.
|
• Introduction to ADO.NET
Microsoft Data Access Technologies
ODBC
OLE DB
ActiveX Data Objects (ADO)
Accessing SQL Server Before ADO.NET
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
Main Program
Creating a Data Adapter and Generating Commands
Filling the Dataset
Displaying the Data Set
Adding a Row to the Data Set
Deleting a Row
Changing a Row
Updating the Database
Acme Computer Case Study
Buy Computer
Model
Component
Part
PartConfiguration
System
SystemId as Identity Column
SystemDetails
StatusCode
Relationships
Stored Procedure
• ADO.NET Connections
ADO.NET Block Diagram
.NET Data Providers
Namespaces for .NET Data Providers
Basic Connection Programming
Using Interfaces
IdbConnection Properties
Connection String
SQL Server Connection String
OLE DB Connection String
IDbConnection Methods
BasicConnection (Step 2)
Connection Life Cycle
BasicConnect (Step 3)
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
Command Types
Stored Procedures
Testing the Stored Procedure
Stored Procedures in ADO.NET
Batch Queries
Transactions
• DataReaders and 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
Acme Computer Case Study
Using Dialog Boxes
Communicating with the Parent
Returning a DialogResult
• DataSets and Disconnected Access
DataSet
DataSet Architecture
Why DataSet?
DataSet Components
DataAdapter
Filling a DataSet
Accessing a DataSet
Updating a DataSet Scenario
Adding a New Row
Searching and Updating a Row
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
Creating a Dataset Manually
Manual DataSet Code
• XML and ADO.NET
ADO.NET and XML
Rendering XML from a DataSet
XmlWriteMode
Writing Data as Attributes
Reading XML into a DataSet
DataSets and XML Schema
ModelSchema.xsd
Reading XML Schema
XmlReadMode
XML Data in DataTables
Typed DataSets
Table Adapter
Synchronizing DataSets and XML
Using XmlDataDocument
XML Serialization
Default Constructor
• Data Binding
Data Binding Concept
Simple Data Binding
Binding to a List
Binding to DataGrid
Complex Data Binding
DataView
Filtering and Sorting
DataView and Data Binding
New Data Binding
BindingSource Architecture
Binding to a List
Setting up the Bindings
Category Class
Code in the Form
DataGridView Control
Performing a Query
• Concurrency and Transactions
DataSets and Concurrency
Handling Concurrency Violations
Pessimistic Concurrency
Transactions
Programming ADO.NET Transactions
ADO.NET Transaction Code
Using ADO.NET Transactions
Database Transactions
Transaction in Stored Procedure
Testing the Stored Procedure
• New Features in ADO.NET 2.0
AcmePub Database
Creating a Data Connection
Using Database Explorer
Performing a Query
Using a Data Connection
Connected Database Access
Long Database Operations
Asynchronous Operations
Enumerating Instances of SQL Server
Multiple Active Result Sets
Bulk Copy
• Appendix A. Acme Computer Case Study
Contact us for course schedules or more
information.
|
|
|
|
|
|
|
