📄 repeater.aspx
字号:
<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
sub Page_Load(obj as Object, e as EventArgs)
'set up connection
dim myConnection as new OleDbConnection _
("Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=H:\ASPNET\data\banking.mdb")
'open connection
dim myCommand as new OleDbDataAdapter _
("select * from tblUsers", myConnection)
'fill dataset
dim ds as DataSet = new DataSet()
myCommand.Fill(ds, "tblUsers")
'select data view and bind to server control
Repeater1.DataSource = ds.Tables("tblUsers").DefaultView
DataBind()
end sub
</script>
<html><body>
<ASP:Repeater id="Repeater1" runat="server" >
<HeaderTemplate>
<table>
<tr>
<td bgcolor="#cccc99" width="200"><b>Name</b></td>
<td bgcolor="#cccc99" width="200"><b>Phone</b></td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td> <%# Container.DataItem("FirstName") %>
<%# Container.DataItem("LastName") %>
</td>
<td> <%# Container.DataItem("Phone") %> </td>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr>
<td bgcolor="#cccc99"">
<%# Container.DataItem("FirstName") %>
<%# Container.DataItem("LastName") %>
</td>
<td bgcolor="#cccc99">
<%# Container.DataItem("Phone") %>
</td>
</tr>
</AlternatingItemtemplate>
<SeparatorTemplate>
<tr>
<td colspan="2" align="center">
- - -
</td>
</tr>
</SeparatorTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</ASP:Repeater>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -