Database Reference
In-Depth Information
Figure 9.32
Specify parameter value.
25. Click
Next
to go to the
Test Query
page. Click the
Test Query
button. Enter 1000
as the value of the parameter shown in Figure 9.32. hen, click
OK
. You will see that
the speciied record is selected. Click
Finish
to complete the parameter coniguration.
26. In the Properties pane, select
SqlDataSource2
in the
Properties
drop-down list. Specify
ConlictDetection
as
CompareAllValues
and
OldValuesParamterFormatString
as
original_{0}
as shown in Figure 9.33. he speciication of these properties enforces
the optimistic concurrency control.
27. Now, select
FormV ie w1
in the Properties pane and make sure that the data key name
is set as
ClassID
(Figure 9.34).
28. In the Design window, space down one line below SqlDataSource2. From the
Standard
section of the Toolbox, drag the
Label
control to the line below SqlDataSource2.
Specify the
ID
property as
lblStatus
(Figure 9.35) and the
Te x t
property as
Status
.
Figure 9.33
Conigure SqlDataSource2 properties.