ASP.NET Tutorial/ASP.net Controls/Repeater — различия между версиями

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

Версия 18:30, 26 мая 2010

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

   <source lang="csharp">

<%@ 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">Name</td>
          <td width="200">ID</td>
       </tr>
    </HeaderTemplate>
    <ItemTemplate>
       <tr>
          <td> <%# Container.DataItem("FirstName") %> 
               <%# Container.DataItem("LastName") %>
          </td>
          <td> <%# Container.DataItem("ID") %> </td>
       </tr>
    </ItemTemplate>
    <AlternatingItemTemplate>
       <tr>
          <td> 
             <%# Container.DataItem("FirstName") %> 
             <%# 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></source>


Repeater with Table

   <source lang="csharp">

<%@ 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">

       <asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1">
           <HeaderTemplate>
               <thead>
                   <td> ID </td>
                   <td> First Name </td>
                   <td> Last Name </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>

   </form>

</body> </html></source>

Источник — «http://nfex.ru/index.php?title=ASP.NET_Tutorial/ASP.net_Controls/Repeater&oldid=3358»