Database Reference
In-Depth Information
Table 9.2
Input and Output
Input
Output
A class schedule
Updated class schedule
A selected class
Selected class info that will be displayed on a subform
Changes made to a selected class
Status after saving the edited class
Table 9.3
Action De scriptions
Event
Action
Click Select button
Select a class to update or delete
Click New link
Insert a new class
Click Edit link
Update class info
Click Delete link
Delete a class from the class schedule
Click Insert link
Insert a new or updated class to the database
Click Cancel link
Not save a new or updated class to the database
As an example, let us consider designing a form for class schedule management. he form
can be used for inserting, updating, and deleting classes. his form allows the staf members at
the Admissions Oice to extract data from the database Class_Registration and display the class
schedule in a GridView control. A staf member can also update or delete a selected class. When
a class is selected for updating, a subform is opened for the staf member to change the schedule.
According to the description of the form, we can identify the input and output shown in Table 9.2.
In Table 9.3, a set of actions are deined.
According to the input/output and the actions identiied in Tables 9.2 and 9.3, one possible
GUI can be designed as shown in Figure 9.3.
he design has three sections. he irst section contains the form title and the instruction on
using the form. he second section contains the GridView control and FormView control. he
GridView control is used to display the class schedule and to select a class so that its information
can be displayed in the FormView. he FormView contains text boxes to display the selected class
information. he FormView control also includes links for editing the form content. When the
updated form content is saved, the current status will be displayed in the status label placed in the
bottom section.
9.3 Database Application Development
As mentioned previously, many tools are available for creating forms. To create database applica-
tions for Windows Azure SQL Database, the choice is Microsoft Visual Studio that includes three
components, integrated development environment (IDE), Windows Azure SDK, and Microsoft
.NET Framework, which can signiicantly simplify the development of database applications.
Search WWH ::




Custom Search