  
                     
|
| |
 |
ADO.NET FOR WEB APPLICATIONS 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 for the Web. The course includes a major case study demonstrating the use of ADO.NET and ASP.NET in a realistic setting. It is current to .NET 2.0, Visual Studio 2005 and SQL Server 2005. There is a practical discussion of data binding including new features in .NET 2.0. Transactions and concurrency are covered. The course concludes with a hands-on treatment of additional new ADO.NET features in .NET 2.0.
Course Length: 3 Days
Course Tuition: $1190 (US)
|
| Prerequisites |
|
| A basic knowledge of SQL and of programming the .NET Framework using C#. To get full benefit from the case studies in the course the student should be able to write simple Windows Forms applications. A working knowledge of SQL Server is also desirable.
|
• Introduction to ADO.NET
Microsoft Data Access Technologies
ODBC
OLE DB
ActiveX Data Objects (ADO)
Accessing SQL Server Before ADO.NET
ADO.NET Architecture
.NET Data Providers1
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
Buy Computer
Model
Component
Part
PartConfiguration
System
SystemId as Identity Column
SystemDetails
StatusCode
Relationships
Stored Procedure
Additional Tables
• 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
SQL Server Security
IDbConnection Methods
Connection Life Cycle
ADO.NET with ASP.NET
Web Client Isolation
Web Client Database Code
Use of Session State
Generic Collections and Data Binding
ChangeDatabase
Connection Pooling
Pool Settings for SQL Server
Connection Events
• 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
DataReader
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
|
• Data Sets and Disconnected Access
DataSet Architecture
Why DataSet?
DataSet Components
DataAdapter
Data Access Class
Retrieving the Data
Filling a DataSet
Accessing a DataSet
Updating a DataSet Scenario
Adding a New Row
Searching and Updating a Row
Deleting a Row
Row Versions and Row State
BeginEdit and CancelEdit
DataTable Events
Updating a Database
Insert, Update, Delete Commands
Command Builders
• More About DataSets
Filtering DataSets
Multiple Tables
DataSet Architecture
Schema in the DataSet
Component Page
Inferring Schema
AddWithKey
Relations
Adding a Primary Key
Identity Columns
Navigating a DataSet
TableMappings
Creating a Dataset Manually
Manual DataSet Code
• Concurrency and Transactions
DataSets and Concurrency
Handling Concurrency Violations
Pessimistic Concurrency
Transactions
Programming ADO.NET Transactions
Complete Code
DataBase Transactions
Transaction in Stored Procedure
Testing the Stored Procedure
Viewing Detailed Errors
• Data Access in .NET 2.0
Data Access in ASP.NET 2.0
Creating a Connection
Using Database Explorer
Performing Queries
SQL Generation Options
Enable Edit and Delete
Editing Records
GridView and DetailsView Controls
Storing the Connection String
Protecting the Configuration String
Multiple Active Result Sets
Bulk Copy
Long Database Operations
Asynchronous Operations
Contact us for course schedules or more
information.
|
|
|
|
|
|
|
