01.
<asp:SqlDataSource ID=
"SqlDataSource2"
runat=
"server"
02.
ConnectionString=
"<%$ ConnectionStrings:AzureConnection %>"
03.
ProviderName=
"<%$ ConnectionStrings:AzureConnection.ProviderName %>"
04.
SelectCommand=
"SELECT [ReplyID], [Detail], [ReplyName] FROM [Reply]"
05.
DeleteCommand=
"DELETE FROM [Reply] WHERE [ReplyID] = ?"
06.
InsertCommand=
"INSERT INTO [Reply] ([ReplyID], [Detail], [ReplyName]) VALUES (?, ?, ?)"
07.
UpdateCommand=
"UPDATE [Reply] SET [Detail] = ?, [ReplyName] = ? WHERE [ReplyID] = ?"
>
08.
<DeleteParameters>
09.
<asp:Parameter Name=
"ReplyID"
Type=
"Int32"
/>
10.
</DeleteParameters>
11.
<UpdateParameters>
12.
<asp:Parameter Name=
"Detail"
Type=
"String"
/>
13.
<asp:Parameter Name=
"ReplyName"
Type=
"String"
/>
14.
<asp:Parameter Name=
"ReplyID"
Type=
"Int32"
/>
15.
</UpdateParameters>
16.
<InsertParameters>
17.
<asp:Parameter Name=
"ReplyID"
Type=
"Int32"
/>
18.
<asp:Parameter Name=
"Detail"
Type=
"String"
/>
19.
<asp:Parameter Name=
"ReplyName"
Type=
"String"
/>
20.
</InsertParameters>
21.
</asp:SqlDataSource>
22.
<asp:FormView ID=
"FormView2"
runat=
"server"
DataKeyNames=
"ReplyID"
23.
DataSourceID=
"SqlDataSource2"
DefaultMode=
'Insert'
>
24.
<EditItemTemplate>
25.
ReplyID:
26.
<asp:Label ID=
"ReplyIDLabel1"
runat=
"server"
Text=
'<%# Eval("ReplyID") %>'
/>
27.
<br />
28.
Detail:
29.
<asp:TextBox ID=
"DetailTextBox"
runat=
"server"
Text=
'<%# Bind("Detail") %>'
/>
30.
<br />
31.
ReplyName:
32.
<asp:TextBox ID=
"ReplyNameTextBox"
runat=
"server"
33.
Text=
'<%# Bind("ReplyName") %>'
/>
34.
<br />
35.
<asp:LinkButton ID=
"UpdateButton"
runat=
"server"
CausesValidation=
"True"
36.
CommandName=
"Update"
Text=
"Update"
/>
37.
<asp:LinkButton ID=
"UpdateCancelButton"
runat=
"server"
38.
CausesValidation=
"False"
CommandName=
"Cancel"
Text=
"Cancel"
/>
39.
</EditItemTemplate>
40.
<InsertItemTemplate>
41.
Detail:
42.
<asp:TextBox ID=
"DetailTextBox"
runat=
"server"
Text=
'<%# Bind("Detail") %>'
/>
43.
<br />
44.
ReplyName:
45.
<asp:TextBox ID=
"ReplyNameTextBox"
runat=
"server"
46.
Text=
'<%# Bind("ReplyName") %>'
/>
47.
<br />
48.
<asp:LinkButton ID=
"InsertButton"
runat=
"server"
CausesValidation=
"True"
49.
CommandName=
"Insert"
Text=
"Insert"
/>
50.
<asp:LinkButton ID=
"InsertCancelButton"
runat=
"server"
51.
CausesValidation=
"False"
CommandName=
"Cancel"
Text=
"Cancel"
/>
52.
</InsertItemTemplate>
53.
<ItemTemplate>
54.
ReplyID:
55.
<asp:Label ID=
"ReplyIDLabel"
runat=
"server"
Text=
'<%# Eval("ReplyID") %>'
/>
56.
<br />
57.
Detail:
58.
<asp:Label ID=
"DetailLabel"
runat=
"server"
Text=
'<%# Bind("Detail") %>'
/>
59.
<br />
60.
ReplyName:
61.
<asp:Label ID=
"ReplyNameLabel"
runat=
"server"
Text=
'<%# Bind("ReplyName") %>'
/>
62.
<br />
63.
</ItemTemplate>
64.
</asp:FormView>