1. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="user_Default" %>  
  2.  
  3. <%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>  
  4. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">  
  5. <html xmlns="http://www.w3.org/1999/xhtml">  
  6. <head runat="server">  
  7. <title>无标题页</title>  
  8.  
  9. <script type="text/javascript">  
  10.  
  11. function pageLoad() {  
  12. }  
  13.  
  14. </script>  
  15.  
  16. <style type="text/css">  
  17. #form1  
  18. {  
  19. text-align: center;  
  20. }  
  21. </style>  
  22.  
  23. </head>  
  24. <body>  
  25. <form id="form1" runat="server">  
  26. <div>  
  27. </div>  
  28. <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Employee %>" 
  29. ProviderName="<%$ ConnectionStrings:Employee.ProviderName %>"   
  30. SelectCommand="SELECT * FROM [Employee]"   
  31. DeleteCommand="DELETE FROM Employee WHERE (ID = ?)"   
  32. InsertCommand="INSERT INTO Employee(name, sex, department) VALUES (?, ?, ?)"   
  33. UpdateCommand="UPDATE Employee SET name = ?, department = ?, sex = ? WHERE (ID = ?)">  
  34. <DeleteParameters>  
  35. <asp:Parameter Name="id" />  
  36. </DeleteParameters>  
  37. <UpdateParameters>  
  38. <asp:Parameter Name="name" />  
  39. <asp:Parameter Name="department" />  
  40. <asp:Parameter Name="sex" />  
  41. <asp:Parameter Name="id" />  
  42. </UpdateParameters>  
  43. <InsertParameters>  
  44. <asp:Parameter Name="name" />  
  45. <asp:Parameter Name="sex" />  
  46. <asp:Parameter Name="department" />  
  47. </InsertParameters>  
  48. </asp:SqlDataSource>  
  49.  
  50. 人员信息列表<br />  
  51.  
  52. <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" 
  53. AutoGenerateColumns="False" CellPadding="4" DataKeyNames="ID" DataSourceID="SqlDataSource1" 
  54. ForeColor="#333333" GridLines="None" Width="700px"   
  55. AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"   
  56. ShowFooter="True" AutoGenerateSelectButton="True">  
  57. <PagerSettings FirstPageText="首页" LastPageText="末页" NextPageText="下一页" PageButtonCount="5" 
  58. Position="TopAndBottom" PreviousPageText="上一页" Mode="NextPreviousFirstLast" />  
  59. <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />  
  60. <Columns>  
  61. <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True" 
  62. SortExpression="ID" />  
  63. <asp:BoundField DataField="name" HeaderText="姓名" SortExpression="name" />  
  64. <asp:BoundField DataField="sex" HeaderText="性别" SortExpression="sex" />  
  65. <asp:BoundField DataField="department" HeaderText="部门" NullDisplayText="没有填写" SortExpression="department" />  
  66. </Columns>  
  67. <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />  
  68. <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />  
  69. <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />  
  70. <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />  
  71. <AlternatingRowStyle BackColor="White" />  
  72. </asp:GridView>  
  73. </form>  
  74. </body>  
  75. </html>