📄 datalistmulticolumn.aspx
字号:
<%@ Import Namespace="System.Data.SqlClient" %>
<Script Runat="Server">
Sub Page_Load
Dim conNorthwind As SqlConnection
Dim cmdSelect As SqlCommand
Dim dtrProducts As SqlDataReader
conNorthwind = New SqlConnection( "Server=localhost;UID=sa;PWD=secret;Database=Northwind" )
cmdSelect = New SqlCommand( "Select ProductName From Products", conNorthwind )
conNorthwind.Open()
dtrProducts = cmdSelect.ExecuteReader()
dlstProducts.DataSource = dtrProducts
dlstProducts.DataBind()
dtrProducts.Close()
conNorthwind.Close()
End Sub
</Script>
<html>
<head><title>DataListMultiColumn.aspx</title></head>
<body>
<form Runat="Server">
<asp:DataList
ID="dlstProducts"
RepeatColumns="4"
RepeatDirection="Horizontal"
CellSpacing="10"
Runat="Server">
<ItemTemplate>
<asp:LinkButton
Text='<%# Container.DataItem( "ProductName" )%>'
Runat="Server"/>
</ItemTemplate>
</asp:DataList>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -