📄 select_del_altclassroom.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="select_del_altclassroom.aspx.cs" Inherits="teaching_manage_classroom_select_del_altclassroom" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title> 教室管理</title>
<link href="~/css/mm.css" rel="stylesheet" type="text/css" />
</head>
<body>
<form id="form1" runat="server">
<div>
<table>
<tr>
<td style="width: 345px">
教室管理</td>
</tr>
<tr>
<td style="width: 345px">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" DataKeyNames="classroom_ID" DataSourceID="SqlDataSource1"
Width="573px">
<Columns>
<asp:BoundField DataField="classroom_ID" HeaderText="classroom_ID" InsertVisible="False"
ReadOnly="True" SortExpression="classroom_ID" Visible="False" />
<asp:BoundField DataField="classroom_num" HeaderText="教室号码" SortExpression="classroom_num" />
<asp:BoundField DataField="classroom_type" HeaderText="类型" SortExpression="classroom_type" />
<asp:BoundField DataField="state" HeaderText="状态" SortExpression="state" />
<asp:BoundField DataField="classroom_pernum" HeaderText="容纳人数" SortExpression="classroom_pernum" />
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:XTeamConnectionString %>"
DeleteCommand="DELETE FROM [classroom] WHERE [classroom_ID] = @classroom_ID"
InsertCommand="INSERT INTO [classroom] ([classroom_pernum], [classroom_type], [state], [classroom_num]) VALUES (@classroom_pernum, @classroom_type, @state, @classroom_num)"
SelectCommand="SELECT [classroom_ID], [classroom_pernum], [classroom_type], [state], [classroom_num] FROM [classroom]"
UpdateCommand="UPDATE [classroom] SET [classroom_pernum] = @classroom_pernum, [classroom_type] = @classroom_type, [state] = @state, [classroom_num] = @classroom_num WHERE [classroom_ID] = @classroom_ID">
<DeleteParameters>
<asp:Parameter Name="classroom_ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="classroom_pernum" Type="Int32" />
<asp:Parameter Name="classroom_type" Type="String" />
<asp:Parameter Name="state" Type="String" />
<asp:Parameter Name="classroom_num" Type="String" />
<asp:Parameter Name="classroom_ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="classroom_pernum" Type="Int32" />
<asp:Parameter Name="classroom_type" Type="String" />
<asp:Parameter Name="state" Type="String" />
<asp:Parameter Name="classroom_num" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -