Windows Forms: N-Tier Data Form - Data Access Layer
This sample shows you how to build an N-Tier data application. This
demonstrates the use of a 3-Tier system, using SQL Server or MSDE as a back end
(accessing the Northwind database), a data access layer middle tier, and a
data-bound form as the front end. The front end is a common type of
data-bound form and is useful for navigating through records and viewing
various levels of detail for the data related to each record.
Featured Highlights
-
See how to create a data access layer on the middle tier that will create a
DataSet object to be consumed on the front-end.
-
See how events are used in the back end to provide status information to the
front end.
-
View an example of data binding on the front-end.
-
See how a single DataSet can be filled with two DataTables and bound to various
controls that are kept in sync with each other.
Requirements
This application requires the release version of Visual Studio .NET Professional
(or greater) and access to the Northwind database residing in SQL Server or the
Microsoft Data Engine (MSDE). To install MSDE, do the following:
1. Open the Start menu, click Programs, click Microsoft .NET
Framework SDK, and then click Samples and Quickstart Tutorials.
2. Click "Step 1: Install the .NET Framework Samples Database".
3. Open a command window, and CD to
\Samples\Setup This is typically : C:\Program Files\Microsoft
Visual Studio .NET\FrameworkSDK\Samples\Setup
4. Type: osql -E -S (local)\NetSDK -i InstNwnd.sql
Running the Sample
Press F5 to run the sample. To view the alternate
Master-Details interface, uncomment the line labeled OPTIONAL in the GetDataSet
method (found in the DataAccessLayer class).
See Also
Introduction to
Data Sets
Data Adapters
Relationships in ADO.NET DataSets