📄 repeater.aspx
字号:
<%@ Page Language="C#" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient" %>
<HTML>
<body>
<SCRIPT language="C#" runat="Server">
void Page_Load(Object Src, EventArgs E)
{
DataSet ds;
SqlConnection conn;
SqlDataAdapter cmdAuthors;
//create a connection to the pubs database
conn = new SqlConnection("data source=(local)\\NETSDK;initial catalog=pubs;integrated security=SSPI;persist security info=True");
//create a dataset with information from the authors table
cmdAuthors = new SqlDataAdapter("select * from Authors", conn);
ds = new DataSet();
cmdAuthors.Fill(ds, "Authors");
//bind the dataset to two repeater controls
repTable.DataSource=ds.Tables["Authors"].DefaultView;
repTable.DataBind();
repList.DataSource=ds.Tables["Authors"].DefaultView;
repList.DataBind();
}
</SCRIPT>
<H2>A simple list of data</H2>
<asp:Repeater id="repList" runat="server">
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem,"au_lname") %>, <%# DataBinder.Eval(Container.DataItem,"au_fname") %><BR>
</ItemTemplate>
</asp:Repeater>
<H2>A Table of data</H2>
<asp:Repeater id="repTable" runat="server">
<HeaderTemplate>
<table>
<tr>
<td style="font:bold; background-color:pink">Lastname</td>
<td style="font:bold; background-color:pink">Firstname</td>
<td style="font:bold; background-color:pink">State</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<tr>
<td><%# DataBinder.Eval(Container.DataItem,"au_lname") %></td>
<td><%# DataBinder.Eval(Container.DataItem,"au_fname") %></td>
<td><%# DataBinder.Eval(Container.DataItem,"state") %></td>
</tr>
</ItemTemplate>
<AlternatingItemTemplate>
<tr>
<td style="background-color: lavender"><%# DataBinder.Eval(Container.DataItem,"au_lname") %></td>
<td style="background-color: lavender"><%# DataBinder.Eval(Container.DataItem,"au_fname") %></td>
<td style="background-color: lavender"><%# DataBinder.Eval(Container.DataItem,"state") %></td>
</tr>
</AlternatingItemTemplate>
<FooterTemplate>
</table>
</FooterTemplate>
</asp:Repeater>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -