Windows Forms & ADO.NET Using C#

Windows Forms & ADO.NET Training

ADO.NET is the underlying framework for data access within .NET applications,and facilitates access to a range of relational and non-relational data sources, including Microsoft SQL Server, Oracle, and XML files, as well as any database for which a native or OLEDB-based provider is available. Applications can use ADO.NET to connect to any of these data sources to select, manipulate, and change data.

Course Outline

Windows Forms

Introduction to Windows Forms

What Are Windows Forms?
Windows Forms Class Hierarchy
Building a Form
The Application Class
Trapping Events
Buttons
Labels and Textbox Controls

Visual Studio and the Forms Designer

Using the Forms Designer
Code Generated by Forms Designer
Adding Event Handlers
Creating Attractive Forms
Creating Easy To Use Forms

Using Controls

Checkbox, Radio Button, and Group Box
Numeric Up/Down
Trackbar
Progress
MonthCalendar
DateTimePicker

List Controls

Listbox and Combo box
DomainUpDown
ListView
Storing Objects in List Controls

Working with Dialogs

Modal vs. Modeless Dialogs
Message Boxes
Common Dialogs
Creating a Modal Dialog
Configuring the Dialog Result
Access Data from the Dialog
Validating Data
Error Provider Control
Modal Dialogs
Creating a Modeless Dialog

Menus, Toolbars and Status Bars

Main Menus
Context Menus
Building a Status Bar
Building a Toolbar
Using the Timer Control

Advanced Windows Forms Topics

Parent/Child Relationships
Owner/Owned Relationships
Top-Most Forms
Multiple Document Interface
Managing Parent/Child Menus
Programming the Clipboard
Visual Inheritance

Using Advanced Controls

Panel
TreeView
Splitter
Tab Control

Resources

Image Resources
Resource Files
String Resources
Working with Resources in Visual Studio
Resource Managers
Cultures and Internationalization
Building Localizable Forms

Applications and Settings

Application Class
Processing and Filtering Windows Messages
Application Lifetime and Events
Configuration Files
Windows Registry

Data Access and Data Binding

ADO.NET Overview
.NET Data Providers
Using DataReaders
Data Sets
Data Tables
Data Views
Data Binding
Interacting with XML Data

.NET Windows Forms

ToolStrip Control
SplitContainer Control
Web Browser Control
DataGridView Control
Other .NET Controls
New Data Binding
Application Settings
BackgroundWorker Component
ClickOnce Deployment

Minor Project

Minor Project 1
Project Case Study 1
Minor Project 2
Project Case Study 2
Minor Project 3
Project Case Study 3

ADO.NET

Introduction to ADO.NET

Microsoft Data Access Technologies
From ADO to ADO.NET
ADO.NET Architecture
Namespaces and Classes
Interfaces
DataSets and Disconnected Access
First ADO.NET Programs

ADO.NET Connections

.NET Data Providers
DbConnection
Connection Classes
Connection Strings
Connection Pooling
Connection Events
Error Handling

ADO.NET Connections

Database Programs with ASP.NET

ADO.NET Commands

DbCommand
Command Objects
Creating Commands
Executing Commands
Parameterized Queries
Command Types
Using Stored Procedures
Batch Queries

DataReaders and Connected Access

DataReaders
IDataReader
IDataRecord
Type-Safe Accessors
Null Columns
ExecuteReader Options
Multiple Result Sets
Obtaining Schema Information

Data Sets and Disconnected Access

DataSet
DataAdapter
Command Objects
DataTable
DataColumn
DataRow
Row States and Versions
Accept or Reject Changes
DataTable Events
Updating a Database from a DataSet
Command Builders

More About DataSets

Filtering DataTables
Multiple Table DataSets
Schema
Constraints
Relations
Navigating a DataSet
DataMapping
Creating a DataSet Programmatically

XML and ADO.NET

Strong Coupling Between ADO.NET and XML
Rendering XML from a DataSet
Controlling XML Output
Reading XML into a DataSet
XML Schema and DataSets
Typed DataSets
Table Adapters
Synchronizing DataSets and XML
XML Serialization

Data Binding

Data Binding in Windows Forms
Simple Data Binding
Complex Data Binding
DataGrid Binding
DataView
Filtering and Sorting
Data Binding with .NET

Concurrency and Transactions

DataSets and Concurrency
Optimistic Concurrency
Pessimistic Concurrency
Handling Concurrency Violations
ADO.NET Transactions
Database Transactions

New Features in ADO.NET

Using Server Explorer in Visual Studio
Asynchronous Database Operations
Multiple Active Result Sets
Bulk Copy in ADO.NET

LINQ to ADO.NET

Language Integrated Query (LINQ)
Bridging Objects and Data
Using Object Relational Designer
Filtering, Ordering and Aggregation
Inserts, Deletes and Updates
LINQ to SQL
LINQ to Dataset

Minor Project

Minor Project 1
Project Case Study 1
Minor Project 2
Project Case Study 2
Minor Project 3
Project Case Study 3

Windows Forms & ADO.NET Using C#

Windows Forms & ADO.NET Training

Course Outline

Windows Forms

ADO.NET

Microsoft Training

Core Skills & Expertise

Programming

Course Registration

About Us