?? 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>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -