📄 displaydataboundstate.aspx
字号:
<%@ Register TagPrefix="myControls" Namespace="myControls"
Assembly="DataBoundState"%>
<%@ Import Namespace="System.Data.SqlClient" %>
<Script Runat="Server">
Sub Page_Load
If Not IsPostBack Then
Dim conPubs As SqlConnection
Dim cmdSelect As SqlCommand
conPubs = New SqlConnection( "Server=LocalHost;UID=sa;PWD=secret;Database=Pubs" )
cmdSelect = New SqlCommand( "Select * From Authors", conPubs )
conPubs.Open()
ctrlDataBoundState.DataSource = cmdSelect.ExecuteReader()
ctrlDataBoundState.DataBind()
conPubs.Close()
End If
End Sub
</Script>
<html>
<head><title>DisplayDataBoundState.aspx</title></head>
<body>
<form Runat="Server">
<myControls:DataBoundState
ID="ctrlDataBoundState"
Runat="Server">
<ItemTemplate>
<li> <i> <%# Container.DataItem( "au_lname" ) %>
</ItemTemplate>
</myControls:DataBoundState>
<p>
<asp:Button
Text="Reload Page!"
Runat="Server" />
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -