Data Access: How To Create A Data Entry Form

Create a data entry to to add, update and delete records from a single table.

Featured Highlights:

ADO.NET is used to to insert, update and delete records from the Products table in the Northwind database. A ListItem class has been created to store a value and a primary key associated with that value to be used in the combo boxes on the form.

Requirements:

Requires the release version of Visual Studio .NET Professional ( or greater) and access to the Northwind databse residing in SQL Server or the Microsoft Data Engine (MSDE). To install MSDE, do the following:

• Open Start Menu, then click Programs, then click Microsoft.NET Framework SDK, and then click samples and Quickstart Tutorials.
• Click "Step 1: Install the .NET framework Samples Database".
• Open a command window, and CD to FrameworkSDK\Samples\Setup This is usually: C:\Program Files\Microsoft Visual Studio .NET\FrameworkSDK\Samples\Setup 
• Type: osql -E -S (local)\VSdotNET -i InstNwnd.sql

Running the Sample:

Simply press F5.

See Also

Introduction to DataSets  Binding and Windows Forms