Data Tier Application Development with VB.NET Part 1
by Steve Ochani http://www.steveo.us
v 1.0 April 14th, 2008.
Purpose: To show how to make a Data Tier (N Tier) database application with VB.NET 2005 (Visual Basic .NET 2005.) Part 2 of this tutorial will focus on using parameterized queries with a Data Tier.
Intended audience: This tutorial is mainly intended for students that I help that are taking CMP 214 (Application Development with VB .NET) course at SUNY Nassau Community College but is still relevant to anyone wishing to develop a database application with VB.NET 2005. You should have at least basic knowledge and understanding of object oriented programming concepts and Visual Basic .NET 2005.
Structure of this document: This tutorial is split up into several pages each page containing text and thumbnails of screenshots of each step. You can click on the screenshot to see the full size screenshot.
Database note: This application will be accessing a database on SQL Server 2005. The table is a simple table called authors which has an ID (primary key and identity field), fname, lname and genre which are of type varchar.
Start by creating a new application and then right clicking the project in Solution Explorer, in the menu select Add then Class.
Name it authortier. Visual studio will then show you the class.
You will now need to add a datasource to the application. Do this by going to the Data menu, select Add New Data Source...