|
| |
Database Programming with C++/MFC
Become more efficient and learn the MFC code generators that can save you
time!
Learn the latest database APIs from Microsoft!
Prerequisites
Students are assumed to have taken MFC/GUI Programming
Part II.
Duration: 1 Day
Topics
 | Introduction
 | Databases and many-to-many relationships |
| A short history of Microsoft Database APIs
 | MSAccess v. SQL Server |
| DBLIB, ODBC, DAO, OLE DB, ADO, RDS, ADO.NET |
|
|
| Creating Databases
| MS Access |
| SQL Server |
|
| Using MFC Wizards
| Browsing Databases
| Attributes |
| The MFC Wizard generated Code |
|
| Record View Classes |
|
| Using ADO.NET
| Why another new Database API?
| Managed code |
| New Optimizations |
|
| Attributes |
| Connection strings |
| Two sets of classes: SQL and OleDB |
| Fast connections with the Readers |
| Adapters and Datasets
| Adapters
| Commands: Select, Delete, Update, Edit |
|
| Datasets
| Early binding to custom datasets |
| Late binding to generic datasets |
| Filling Datasets |
| Tables, Columns and Rows |
| Relations |
|
|
| Databinding |
|
|
