📄 employeeslist.aspx
字号:
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.IO" %>
<html><head>
<title>Employees</title>
<style>
hr {height:2px;color:black;}
.StdText {font-family:verdana;font-size:9pt;}
.StdTextBox {font-family:verdana;font-size:9pt;border:solid 1px black;filter:progid:DXImageTransform.Microsoft.dropshadow(OffX=2, OffY=2, Color='gray', Positive='true');}
.Shadow {font-size:9pt;border:solid 1px black;filter:progid:DXImageTransform.Microsoft.dropshadow(OffX=2, OffY=2, Color='gray', Positive='true');}
</style>
<SCRIPT runat="server">
public void Page_Load(Object sender, EventArgs e)
{
if (!IsPostBack)
lblURL.Text = Request.Url + "<hr>";
}
public void OnSearch(Object sender, EventArgs e)
{
DataSet ds = new DataSet();
String sConn = "server=localhost;uid=sa;Initial Catalog=Northwind;";
String sText = "SELECT employeeid, firstname, lastname FROM Employees ";
sText += "WHERE employeeid >=" + tbEmpID.Text;
SqlDataAdapter cmd = new SqlDataAdapter(sText, sConn);
cmd.Fill(ds, "EmpTable");
DataList1.DataSource = ds.Tables["EmpTable"].DefaultView;
DataList1.DataBind();
}
</SCRIPT>
<body bgcolor="ivory" style="font-family:arial;font-size:9pt">
<h2>Employees</h2>
Get an employee ID and retrieve all the employees whose IDs are greater than that.
<!-- ASP.NET Form -->
<form runat="server">
<asp:Label runat="server" cssclass="StdText" font-bold="true">Current path: </asp:label>
<asp:Label runat="server" id="lblURL" cssclass="StdText" style="color:blue"></asp:label>
<table border="0">
<!-- Employee Name -->
<tr>
<td><asp:Label runat="server" cssclass="StdText" font-bold="true">EmployeeID</asp:label></td>
<td><asp:textbox runat="server" id="tbEmpID" cssclass="StdTextBox" width="100px">1</asp:textbox></td>
<td><asp:LinkButton runat="server" cssclass="StdText" Text="Search" onclick="OnSearch" ></asp:LinkButton></td>
</tr>
</table>
<hr>
<!-- Table goes here -->
<br>
<asp:DataList runat="server" id="DataList1" cssclass="Shadow" BackColor="white">
<HeaderTemplate>
<table style="border:1px solid black;" class="stdtext">
<thead bgcolor="blue" style="color:white">
<td><b>ID</b></td>
<td><b>First Name</b></td>
<td><b>Last Name</b></td>
</thead>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td bgcolor="white"> <%# ((DataRowView)Container.DataItem)["EmployeeID"] %> </td>
<td bgcolor="white"> <%# ((DataRowView)Container.DataItem)["FirstName"] %> </td>
<td bgcolor="white"> <%# ((DataRowView)Container.DataItem)["LastName"] %> </td>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr>
<td bgcolor="lightblue"> <%# ((DataRowView)Container.DataItem)["EmployeeID"] %> </td>
<td bgcolor="lightblue"> <%# ((DataRowView)Container.DataItem)["FirstName"] %> </td>
<td bgcolor="lightblue"> <%# ((DataRowView)Container.DataItem)["LastName"] %> </td>
</tr>
</AlternatingItemTemplate>
<FooterTemplate>
<tfoot>
<td bgcolor="silver" colspan="3">
<%# "<b>" + ((DataView)DataList1.DataSource).Count + "</b> employees found."%></td>
</tfoot>
</table>
</FooterTemplate>
</asp:DataList>
<!-- End of ASP.NET page -->
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -