Murach's C#
How to develop a simple database application
To get you off to a fast start with C# database programming, this chapter shows
you how to use the Data Adapter Configuration Wizard and the .NET data grid control
to generate the ADO.NET data adapter and connection objects for a simple database
application. Then, it shows you how to generate a dataset that contains the table
defined by the data adapter, how to use data binding to bind the data grid control
to the dataset, how to fill the dataset with data from the database, and how to update
the database with changes made to the dataset. These are the basic skills that you
need for Rapid Application Development.
|
|
|
|
How to start the wizard |
506 |
|
How to define the connection |
508 |
|
How to define the SQL statements |
510 |
|
How to use the Query Builder |
512 |
|
How to set advanced SQL generation options |
514 |
|
How to complete the configuration |
516 |
|
The objects created by the Configuration
Wizard |
518 |
|
|
How to generate a dataset |
520 |
|
The dataset schema file, class, and
object |
522 |
|
How to fill and clear a dataset |
524 |
|
How to update the database with changes
made to a dataset |
526 |
|
How to handle data provider errors |
528 |
|
How to handle update errors |
530 |
|
|
A Product Maintenance form that uses
a bound data grid control |
532 |
|
How to bind a data grid control to a
dataset |
534 |
|
How to customize the column layout for
a data grid control |
536 |
|
The code for the Product Maintenance
application |
538 |
|
How to work with the data in a data
grid control |
540 |
|
|
How to preview the data in a data adapter |
542 |
|
How to review the properties for generated
ADO.NET objects |
544 |
|
How to interpret the generated SQL statements |
546 |
|
 |
|
|
|
|
© Copyright 1998-2008 Mike Murach &
Associates, Inc. All rights reserved.
|
