📄 default.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<!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>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="GridView1" runat="server" AllowSorting="True" AutoGenerateColumns="False"
DataKeyNames="编号" DataSourceID="AccessDataSource1" Caption="员工基本情况表" Width="472px">
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True">
<HeaderStyle Font-Size="Smaller" Wrap="False" />
<ItemStyle Font-Size="Smaller" Wrap="False" />
</asp:CommandField>
<asp:BoundField DataField="编号" HeaderText="编号" ReadOnly="True" SortExpression="编号" >
<ItemStyle Font-Size="Smaller" HorizontalAlign="Center" Wrap="False" />
<HeaderStyle Font-Size="Smaller" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="姓名" HeaderText="姓名" SortExpression="姓名" >
<ItemStyle Font-Size="Smaller" HorizontalAlign="Center" Wrap="False" />
<HeaderStyle Font-Size="Smaller" HorizontalAlign="Center" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="性别" HeaderText="性别" SortExpression="性别" >
<ItemStyle Font-Size="Smaller" HorizontalAlign="Center" Wrap="False" />
<HeaderStyle Font-Size="Smaller" HorizontalAlign="Center" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="年龄" HeaderText="年龄" SortExpression="年龄" >
<ItemStyle Font-Size="Smaller" HorizontalAlign="Center" Wrap="False" />
<HeaderStyle Font-Size="Smaller" HorizontalAlign="Center" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="部门" HeaderText="部门" SortExpression="部门" >
<ItemStyle Font-Size="Smaller" HorizontalAlign="Center" Wrap="False" />
<HeaderStyle Font-Size="Smaller" HorizontalAlign="Center" Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="职务" HeaderText="职务" SortExpression="职务" >
<ItemStyle Font-Size="Smaller" HorizontalAlign="Center" Wrap="False" />
<HeaderStyle Font-Size="Smaller" HorizontalAlign="Center" Wrap="False" />
</asp:BoundField>
</Columns>
</asp:GridView>
<br />
<asp:AccessDataSource ID="AccessDataSource1" runat="server" ConflictDetection="CompareAllValues"
DataFile="~/DB/employee.mdb" DeleteCommand="DELETE FROM [employee] WHERE [编号] = ? AND [姓名] = ? AND [性别] = ? AND [年龄] = ? AND [部门] = ? AND [职务] = ?"
InsertCommand="INSERT INTO [employee] ([编号], [姓名], [性别], [年龄], [部门], [职务]) VALUES (?, ?, ?, ?, ?, ?)"
OldValuesParameterFormatString="original_{0}" OnSelecting="AccessDataSource1_Selecting"
SelectCommand="SELECT * FROM [employee]" UpdateCommand="UPDATE [employee] SET [姓名] = ?, [性别] = ?, [年龄] = ?, [部门] = ?, [职务] = ? WHERE [编号] = ? AND [姓名] = ? AND [性别] = ? AND [年龄] = ? AND [部门] = ? AND [职务] = ?">
<DeleteParameters>
<asp:Parameter Name="original_编号" Type="String" />
<asp:Parameter Name="original_姓名" Type="String" />
<asp:Parameter Name="original_性别" Type="String" />
<asp:Parameter Name="original_年龄" Type="Int16" />
<asp:Parameter Name="original_部门" Type="String" />
<asp:Parameter Name="original_职务" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="姓名" Type="String" />
<asp:Parameter Name="性别" Type="String" />
<asp:Parameter Name="年龄" Type="Int16" />
<asp:Parameter Name="部门" Type="String" />
<asp:Parameter Name="职务" Type="String" />
<asp:Parameter Name="original_编号" Type="String" />
<asp:Parameter Name="original_姓名" Type="String" />
<asp:Parameter Name="original_性别" Type="String" />
<asp:Parameter Name="original_年龄" Type="Int16" />
<asp:Parameter Name="original_部门" Type="String" />
<asp:Parameter Name="original_职务" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="编号" Type="String" />
<asp:Parameter Name="姓名" Type="String" />
<asp:Parameter Name="性别" Type="String" />
<asp:Parameter Name="年龄" Type="Int16" />
<asp:Parameter Name="部门" Type="String" />
<asp:Parameter Name="职务" Type="String" />
<asp:Parameter Name="original_编号" Type="String" />
<asp:Parameter Name="original_姓名" Type="String" />
<asp:Parameter Name="original_性别" Type="String" />
<asp:Parameter Name="original_年龄" Type="Int16" />
<asp:Parameter Name="original_部门" Type="String" />
<asp:Parameter Name="original_职务" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -