📄 admin_pollanswer.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="admin_pollanswer.aspx.cs" Inherits="admin_pollanswer" %>
<html>
<head>
<!--#include file="inc/admin_head.inc"-->
</head>
<body>
<asp:Label id="Label1" width="100%" runat="server"/>
<form id="Form1" runat="server">
<div class="mframe">
<table width="90%" align="center" cellspacing="0" cellpadding="0">
<tr>
<td class="tl"></td>
<td class="tm">
<span class="tt">管理投票</span>
</td>
<td class="tr"></td>
</tr>
</table>
<table width="90%" align="center" cellspacing="0" cellpadding="0">
<tr>
<td class="ml"></td>
<td class="mm">
添加答案：cn<asp:TextBox ID="txtanswer_cn" runat="server"></asp:TextBox>en<asp:TextBox
ID="txtanswer_en" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="确定" />
如果只需要一种语言，请把en留空
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:sp_pollConnectionString1 %>"
DeleteCommand="DELETE FROM [sp_answer] WHERE [id] = @id" InsertCommand="INSERT INTO [sp_answer] ([answer_cn], [answer_en], [amount], [for_question]) VALUES (@answer_cn, @answer_en, @amount, @for_question)"
ProviderName="<%$ ConnectionStrings:sp_pollConnectionString1.ProviderName %>"
SelectCommand="SELECT [id], [answer_cn], [answer_en], [amount], [for_question] FROM [sp_answer] WHERE ([for_question] = @for_question)"
UpdateCommand="UPDATE [sp_answer] SET [answer_cn] = @answer_cn, [answer_en] = @answer_en, [amount] = @amount, [for_question] = @for_question WHERE [id] = @id">
<DeleteParameters>
<asp:Parameter Name="id" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="answer_cn" Type="String" />
<asp:Parameter Name="answer_en" Type="String" />
<asp:Parameter Name="amount" Type="Int32" />
<asp:Parameter Name="for_question" Type="Int32" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
<SelectParameters>
<asp:QueryStringParameter Name="for_question" QueryStringField="id" Type="Int32" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="answer_cn" Type="String" />
<asp:Parameter Name="answer_en" Type="String" />
<asp:Parameter Name="amount" Type="Int32" />
<asp:Parameter Name="for_question" Type="Int32" />
</InsertParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id"
DataSourceID="SqlDataSource1" EmptyDataText="没有可显示的数据记录。">
<Columns>
<asp:CommandField ShowEditButton="True" />
<asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True"
SortExpression="id" />
<asp:BoundField DataField="answer_cn" HeaderText="answer_cn" SortExpression="answer_cn" />
<asp:BoundField DataField="answer_en" HeaderText="answer_en" SortExpression="answer_en" />
<asp:BoundField DataField="amount" HeaderText="amount" SortExpression="amount" />
<asp:BoundField DataField="for_question" HeaderText="for_question" SortExpression="for_question" />
</Columns>
</asp:GridView>
</td>
<td class="mr"></td>
</tr>
</table>
<table width="90%" align="center" cellspacing="0" cellpadding="0" >
<tr>
<td class="bl"></td>
<td class="bm"> </td>
<td class="br"></td>
</tr>
</table>
</div>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -