master.aspx
来自「asp.net技术内幕的书配源码」· ASPX 代码 · 共 45 行
ASPX
45 行
<%@ Import Namespace="System.Data.SqlClient" %>
<Script Runat="Server">
Sub Page_Load
Dim conNorthwind As SqlConnection
Dim cmdSelect As SqlCommand
Dim dtrEmployees As SqlDataReader
conNorthwind = New SqlConnection( "Server=localhost;UID=sa;PWD=secret;Database=Northwind" )
cmdSelect = New SqlCommand( "Select EmployeeID,LastName From Employees", conNorthwind )
conNorthwind.Open()
dtrEmployees = cmdSelect.ExecuteReader()
rptEmployees.DataSource = dtrEmployees
rptEmployees.DataBind()
dtrEmployees.Close()
conNorthwind.Close()
End Sub
</Script>
<html>
<head><title>Master.aspx</title></head>
<body>
<form Runat="Server">
<h2>Employee Directory</h2>
<asp:Repeater
ID="rptEmployees"
Runat="Server">
<ItemTemplate>
<li>
<a href='<%# String.Format( "details.aspx?id={0}", Container.DataItem( "EmployeeID" ) ) %>'><%# Container.DataItem( "LastName" ) %></a>
</ItemTemplate>
</asp:Repeater>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?