ASP.NET Tutorial/ASP.net Controls/Repeater

Материал из .Net Framework эксперт
Перейти к: навигация, поиск

Bind data from Access database to an ASP:Repeater (VB.net)

<%@ Page Language="VB" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<script runat="server">
   sub Page_Load(Sender as Object, e as EventArgs) 
      dim myConnection as new OleDbConnection( _
            "PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
            & "DATA SOURCE=" _
            & Server.MapPath("EmployeeDatabase.mdb;"))
      dim myCommand as new OleDbDataAdapter("select * from employee", myConnection)
      dim ds as DataSet = new DataSet()
      myCommand.Fill(ds, "employee")
      Repeater1.DataSource = ds
      Repeater1.DataMember = "employee"
      DataBind()
   end sub
</script>
<html><body>
  <ASP:Repeater id="Repeater1" runat="server" >
     <HeaderTemplate>
        <tr>
           <td width="200"><b>Name</b></td>
           <td width="200"><b>ID</b></td>
        </tr>
     </HeaderTemplate>
     <ItemTemplate>
        <tr>
           <td> <%# Container.DataItem("FirstName") %>&nbsp;
                <%# Container.DataItem("LastName") %>
           </td>
           <td> <%# Container.DataItem("ID") %> </td>
        </tr>
     </ItemTemplate>
     <AlternatingItemTemplate>
        <tr>
           <td> 
              <%# Container.DataItem("FirstName") %>&nbsp;
              <%# Container.DataItem("LastName") %>
           </td>
           <td> 
              <%# Container.DataItem("ID") %> 
           </td>
        </tr>
     </AlternatingItemtemplate>
     <SeparatorTemplate>
        <tr>
           <td colspan="2" align="center">
              - - -
           </td>
        </tr>
     </SeparatorTemplate>
      
     <FooterTemplate>
     </FooterTemplate>
  </ASP:Repeater>
</body></html>


Repeater with Table

<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Like a Grid</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1">
            <HeaderTemplate>
                <thead>
                    <td> <b>ID</b> </td>
                    <td> <b>First Name</b> </td>
                    <td> <b>Last Name</b> </td>
                </thead>
            </HeaderTemplate>
            <ItemTemplate>
            <tr>
                <td bgcolor="white"> 
                    <%# Eval("EmployeeID") %></td>
                <td bgcolor="white"> 
                    <%# Eval("FirstName")%></td>
                <td bgcolor="white">
                    <%# Eval("LastName") %></td>
            </tr>
            </ItemTemplate>
            <AlternatingItemTemplate>
            <tr>
                <td bgcolor="#eeeeee"> 
                    <%# Eval("EmployeeID") %></td>
                <td bgcolor="#eeeeee"> 
                    <%# Eval("FirstName")%></td>
                <td bgcolor="#eeeeee"> 
                    <%# Eval("LastName") %></td>
            </tr>
            </AlternatingItemTemplate>
            
            <FooterTemplate>
            </FooterTemplate>
        </asp:Repeater>
        
        <asp:SqlDataSource ID="SqlDataSource1" runat="server"
            ConnectionString="<%$ ConnectionStrings:NorthWind %>"
            SelectCommand="SELECT employeeid, firstname, lastname FROM employees">
        </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>
Источник — «http://nfex.ru/index.php?title=ASP.NET_Tutorial/ASP.net_Controls/Repeater&oldid=3359»