📄 ch16-05-01.aspx
字号:
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.Data.OleDb" %>
<% Response.Expires = 0 %>
<Html>
<Head>
<Title>Ch16-05-01.aspx 使用DataList控件显示记录</Title>
<Script Language="VB" Runat="Server">
' 在这里设置联机字符串的内容
Sub Page_Load(Obj As Object, e As EventArgs)
If Not IsPostBack Then
GetDataSource()
End If
End Sub
Sub GetDataSource()
Dim DSN As String
Dim tSQL As String = "Select * From UserDatas"
Dim OBJConn As OleDbConnection
DSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
Server.MapPath("/ASP/chap14/ASP.NET网页数据库.mdb") & ";"
OBJConn = New OleDbConnection(DSN)
OBJConn.Open()
Dim OBJCmd As OleDbCommand = New OleDbCommand(tSQL, OBJConn)
DataListCTL.DataSource = OBJCmd.ExecuteReader()
DataListCTL.DataBind()
OBJConn.Close()
End Sub
Sub DataList_ItemCommand(Obj As Object, E As DataListCommandEventArgs)
DataListCTL.SelectedIndex = E.Item.ItemIndex
Label1.Text = "用户编号：" & _
DataListCTL.DataKeys.Item(E.Item.ItemIndex).ToString()
GetDataSource()
End Sub
</Script>
</Head>
<Body>
<Center><H2>使用DataList控件显示记录</H>
<Form Runat="Server" >
<asp:DataList ID="DataListCTL" Runat="Server"
HeaderStyle-BackColor = "#80F0F0"
SelectedItemStyle-BackColor = "#4040FF"
SelectedItemStyle-ForeColor = "#FFFF00"
GridLines = "Both"
RepeatLayoyut = "Table"
RepeatColumns = "5"
RepeatDirection = "Vertical"
DataKeyField = "UID"
OnItemCommand = "DataList_ItemCommand">
<HeaderTemplate>
单击用户姓名即可显示详细数据
</HeaderTemplate>
<ItemTemplate>
<asp:LinkButton ID="Link1" Runat="Server"
Text='<%# Container.DataItem("UserName") %>'
CommandName = "UserSelected" />
</ItemTemplate>
<SelectedItemTemplate>
<%# Container.DataItem("UID") %><BR>
<%# Container.DataItem("UserAccount") %><BR>
<%# Container.DataItem("UserName") %><BR>
<%# Container.DataItem("UserPWD") %><BR>
<%# Container.DataItem("EMail") %><BR>
</SelectedItemTemplate>
</asp:DataList>
<asp:Label ID="Label1" BoderStyle="Double" Runat="Server" />
</Form>
</Center>
</Body>
</Html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -