Multi-table relational database setup - tutorial description

Take the tutorial   Back to the tutorials list

Most tutorials show how to view and edit results from, or add records to databases using the asp.net controls that come with Expression Web or Visual Studio / VWD Express. Their examples generally use a single table database, for which the asp.net contorols automaticlly generate the needed queries for inserting, deleting, and updating records.

In many situations however, developers are faced with the problem of using a multi-table relational database, in which data for the queries come from more than a single table, and the asp.net controls will not automatically generate insert, update, and delete queries from a View containing more than one table.  This tutorial will show how to use a properly configured three-table relational database, and how to make the queries required in order to use the asp.net controls to allow users to add, edit, update, and delete records.

	You will learn how to set up a three-table relational database in a way that the data is "normalized", so that when data has to be entered or modified, it has to be done only once, in one table, so that all tables depending on that data are automatically updated.
	You will learn how to create a Database Diagram and set up the one-to-many relationships, the relations between tables, and the primary key / foreign key contstraints to insure data integrity.
	You will learn how to enter some test data using the Database Explorer of Visual Web Developer Express.
	You will learn how to configure a  multi-table View (Query) to allow displaying data from multiple tables in a Gridview
	You will learn how to create insert, update, and delete queries in order to allow subsquent modification of the data using contols such as the gridivew and formview controls.
	You will learn how to set up dropdown lists in conjunction with the formview controls to allow adding records to your three-table database.