Database Reference
In-Depth Information
22. Click the
INSERT
tab and enter the following code as shown in Figure 9.29:
INSERT INTO CLASS
(ClassID, CourseID, Credit, TimeID, SemesterID, DayID)
SELECT @ClassID,
(SELECT DISTINCT CourseID FROM COURSE WHERE CourseName
=
@
CourseName),
@Credit,
(SELECT DISTINCT TimeID FROM TIMEBLOCK WHERE TimeBlock
=
@
TimeBlock),
(SELECT DISTINCT SemesterID FROM SEMESTER WHERE Semester
=
@
Semester),
(SELECT DISTINCT DayID FROM [DAYS] WHERE [WeekDay]
=
@WeekDay)
23. Click the
DELETE
tab and enter the following code as shown in Figure 9.30:
DELETE CLASS
WHERE ClassID
=
@original_ClassID
24. Click
Next
to go to the
Deine Parameters
page. In the
Parameter source
drop-down
list, select
Control
. In the
ControlID
drop-down list, select
GridView1
as shown in
Figure 9.31.
Figure 9.29
Conigure INSERT tab.