ASP.Net/ADO.net Database/Repeater

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

Bind data to asp:Repeater with itemtemplate, alternatingitemtemplate, separatortemplate and footertemplate

   <source lang="csharp">

<%@ Page Language=VB Debug=true %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OLEDB" %> <script runat=server> Sub Page_Load(ByVal Sender as Object, ByVal E as EventArgs) 

   If Not IsPostBack Then
       Dim DBConn as OleDbConnection
       Dim DBCommand As OleDbDataAdapter
       Dim DSPageData as New DataSet
       DBConn = New OleDbConnection( _
           "PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
           & "DATA SOURCE=" _
           & Server.MapPath("EmployeeDatabase.mdb;"))
       DBCommand = New OleDbDataAdapter _
           ("Select ID, FirstName " _
           & "From Employee " _
           & "Order By FirstName", DBConn)
       DBCommand.Fill(DSPageData, _
           "Employee")
       repDepts.DataSource = _
           DSPageData.Tables("Employee").DefaultView
       repDepts.DataBind()
   End If

End Sub </SCRIPT> <HTML> <HEAD> <TITLE>Creating a Basic Repeater Control</TITLE> </HEAD> <Body LEFTMARGIN="40"> <form runat="server"> <asp:repeater 

   id="repDepts" 
   runat="server"

> 

   <headertemplate>
       Below is a list of all the employee.


   </headertemplate>
   <itemtemplate>
       <%# "Department: " _
           & DataBinder.Eval(Container.DataItem, "ID") _
           & " - " _
           & DataBinder.Eval(Container.DataItem, "FirstName") 
       %>
       

   </itemtemplate>
   <alternatingitemtemplate>
       <%# "Department: " _
           & DataBinder.Eval(Container.DataItem, "ID") _
           & " - " _
           & DataBinder.Eval(Container.DataItem, "FirstName") 
       %>
       

   </alternatingitemtemplate>
   <separatortemplate>

   </separatortemplate>
   <footertemplate>
       
All records have been displayed.
   </footertemplate>

</asp:repeater> </form> </BODY> </HTML> 

      </source>

<A href="http://www.nfex.ru/Code/ASPDownload/EmployeeDatabase.zip">EmployeeDatabase.zip( 10 k)</a>


Bind data to Repeater Control

   <source lang="csharp">

<%@ Page Language=VB Debug=true %> <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OLEDB" %> <script runat=server> Sub Page_Load(ByVal Sender as Object, ByVal E as EventArgs) 

   If Not IsPostBack Then
       Dim DBConn as OleDbConnection
       Dim DBCommand As OleDbDataAdapter
       Dim DSPageData as New DataSet
       DBConn = New OleDbConnection( _
           "PROVIDER=Microsoft.Jet.OLEDB.4.0;" _
           & "DATA SOURCE=" _
           & Server.MapPath("EmployeeDatabase.mdb;"))
       DBCommand = New OleDbDataAdapter _
           ("Select ID, FirstName " _
           & "From Employee " _
           & "Order By FirstName", DBConn)
       DBCommand.Fill(DSPageData, _
           "Employee")
       repDepts.DataSource = _
           DSPageData.Tables("Employee").DefaultView
       repDepts.DataBind()
   End If

End Sub Sub SubmitBtn_Click(Sender As Object, E As EventArgs) End Sub </SCRIPT> <HTML> <HEAD> <TITLE>Creating a Basic Repeater Control</TITLE> </HEAD> <Body LEFTMARGIN="40"> <form runat="server">

<asp:Label 

   id="lblMessage" 
   Font-Size="12pt"
   Font-Bold="True"
   Font-Name="Lucida Console"
   text="Below is a list of all employees"
   runat="server"

/>

<asp:repeater 

   id="repDepts" 
   runat="server"

> 

   <itemtemplate>
       <%# "Department: " _
           & DataBinder.Eval(Container.DataItem, "FirstName") _
           & " - " _
           & DataBinder.Eval(Container.DataItem, "ID") 
       %>
       

   </itemtemplate>

</asp:repeater> </form> </BODY> </HTML> 

      </source>

<A href="http://www.nfex.ru/Code/ASPDownload/EmployeeDatabase.zip">EmployeeDatabase.zip( 10 k)</a>

Источник — «http://nfex.ru/index.php?title=ASP.Net/ADO.net_Database/Repeater&oldid=1583»