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

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