repeater.aspx

来自「visual studio.net学习资料」· ASPX 代码 · 共 76 行

ASPX
76
字号
<%@ 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 + =
减小字号Ctrl + -
显示快捷键?