- <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="user_Default" %>
- <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
- <!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>
- <script type="text/javascript">
- function pageLoad() {
- }
- </script>
- <style type="text/css">
- #form1
- {
- text-align: center;
- }
- </style>
- </head>
- <body>
- <form id="form1" runat="server">
- <div>
- </div>
- <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Employee %>"
- ProviderName="<%$ ConnectionStrings:Employee.ProviderName %>"
- SelectCommand="SELECT * FROM [Employee]"
- DeleteCommand="DELETE FROM Employee WHERE (ID = ?)"
- InsertCommand="INSERT INTO Employee(name, sex, department) VALUES (?, ?, ?)"
- UpdateCommand="UPDATE Employee SET name = ?, department = ?, sex = ? WHERE (ID = ?)">
- <DeleteParameters>
- <asp:Parameter Name="id" />
- </DeleteParameters>
- <UpdateParameters>
- <asp:Parameter Name="name" />
- <asp:Parameter Name="department" />
- <asp:Parameter Name="sex" />
- <asp:Parameter Name="id" />
- </UpdateParameters>
- <InsertParameters>
- <asp:Parameter Name="name" />
- <asp:Parameter Name="sex" />
- <asp:Parameter Name="department" />
- </InsertParameters>
- </asp:SqlDataSource>
- 人员信息列表<br />
- <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
- AutoGenerateColumns="False" CellPadding="4" DataKeyNames="ID" DataSourceID="SqlDataSource1"
- ForeColor="#333333" GridLines="None" Width="700px"
- AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
- ShowFooter="True" AutoGenerateSelectButton="True">
- <PagerSettings FirstPageText="首页" LastPageText="末页" NextPageText="下一页" PageButtonCount="5"
- Position="TopAndBottom" PreviousPageText="上一页" Mode="NextPreviousFirstLast" />
- <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
- <Columns>
- <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
- SortExpression="ID" />
- <asp:BoundField DataField="name" HeaderText="姓名" SortExpression="name" />
- <asp:BoundField DataField="sex" HeaderText="性别" SortExpression="sex" />
- <asp:BoundField DataField="department" HeaderText="部门" NullDisplayText="没有填写" SortExpression="department" />
- </Columns>
- <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
- <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
- <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
- <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
- <AlternatingRowStyle BackColor="White" />
- </asp:GridView>
- </form>
- </body>
- </html>
转载于:https://blog.51cto.com/huqianhao/956519