Programming ASP.NET 3.5, 4th Edition

Creating Data Objects by Hand

In all of the examples so far, you have created the DataSet object and its DataTable and DataRow objects by selecting data from the database. Sometimes, however, you will want to fill a data set or a table by hand.

For example, you may want to gather data from a user and push that data into the database. It can be convenient to add records to a table manually and update the database from that table.

The DataSet is an excellent transport mechanism for data. You may even want to create a DataSet by hand only to pass it to another tier in your application where it will be used as a data source.

A Simple Database Design

Rather than use the AdventureWorksLT database for the next exercise, you will create part of a database for tracking bugs in a software development project. Think about the kinds of information you would want to capture in the database and how that information will be used. You will want to allow any user of the system to create a bug report for a product. You’ll also want certain users (such as developers and Quality Assurance, or QA) to update the bug reports. Developers will want to be able to record progress in fixing a bug or to mark a bug as fixed. QA will want to check the fix and close the bug or reopen it for further investigation. The original reporter of the bug will want to find out who is working on the bug and track his progress.

One requirement imposed early in the design process is that the bug database ought to provide an audit ...