Programming with ADO.NET (Visual C# .NET)

Zagadnienia omawiane na kursie

ADO.NET Objects

Connecting To A Database

Opening A Database Connection

Using Error Handling

Connection Status

Using Trusted Security

Connection String Variables

Connecting to Access

Using UDL Files

Provider Gotchas

Connection Miscellaneous

Executing Commands

SQLCommand Object

OleDbCommand Object

Single Value Queries

Parameterized Queries

Using Stored Procedures

Creating Stored Procedures

Calling Stored Procedures

Creating Stored Procedures with Parameters

Passing Parameters to Stored Processes

Transactions

DataReader

DataReader Basics

Using a DataReader

Multiple Result Sets in a DataReader

Reading Schema from a DataReader

DataAdapter

DataAdapter Basics

Using the DataAdapter

CommandBuilder

DataSet

DataSet Basics

Typed DataSets

Creating a DataSet

DataTables, DataRows, DataColumns, DataViews

Data Binding

Data Bound Textboxes

Navigating with Binding Objects

Navigating with Collections

Complex Binding

XML & ADO.NET

XML Basics

XML Terminology

XML and .NET

Reading XML Data

Putting XML in DataSets

Writing XML from a DataSet

Much More XML

What About ADO ?

Using ADO

DataForm Wizard

DataForm Wizard Basics

Best Use for DataForm Wizard

Background Info

Data Access TLA's