DATALIST一横显示多条数据和图片代码

Posted on 2006-01-04 02:31  flourish  阅读(1261)  评论(0)    收藏  举报

HTML前台代码:
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="ab.aspx.vb" Inherits="eweb.ab"%>
<HTML>
 <HEAD>
  <title>控件分页的例子</title>
  <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  <style>
  P { FONT-SIZE: 9pt }
  TD { FONT-SIZE: 9pt }
  DIV { FONT-SIZE: 9pt }
  SPAN { FONT-SIZE: 9pt }
  </style>
 </HEAD>
 <body>
  <form runat="server">
   <asp:label ID="lblCurrentPage" runat="server"></asp:label><br>
   <asp:HyperLink id="lnkPrev" runat="server">上一页</asp:HyperLink>
   <asp:HyperLink id="lnkNext" runat="server">下一页</asp:HyperLink>
   <hr size="1" color="#000099">
   
   <asp:DataList id="dl1" runat="server" width="100%" align="center" BorderColor="black" CellPadding="12"
Font-Size="9pt" RepeatColumns=5 Border=1>
<ItemStyle HorizontalAlign="Center" width="16%" ></ItemStyle>
<ItemTemplate>
<a href="detail.aspx?id=<%# DataBinder.Eval(Container.DataItem, "id") %>" target="_blank">
<img width=100 height=100 border="0" src="<%# DataBinder.Eval(Container.DataItem, "image") %>" alt="编号:<%# DataBinder.Eval(Container.DataItem, "ID") %>
介绍:<%# DataBinder.Eval(Container.DataItem, "id")%>
长度:<%# DataBinder.Eval(Container.DataItem, "id")%>K
时间:<%# DataBinder.Eval(Container.DataItem, "id")%>
分辨率:<%# DataBinder.Eval(Container.DataItem, "name")%>
点击数:<%# DataBinder.Eval(Container.DataItem, "name")%>
  点击查看原图">
</a>
<br>
<font color=#808080>-<%# DataBinder.Eval(Container.DataItem, "ID") %> -</font>
<br>
<%# DataBinder.Eval(Container.DataItem, "sex") %>
<br>
<%# DataBinder.Eval(Container.DataItem, "sex") %>K

</ItemTemplate>
</ASP:Datalist>
  </form>
 </body>
</HTML>
###############################################
VB。NET后台代码:
Imports System.Data
Imports System.Data.OleDb
Public Class ab
    Inherits System.Web.UI.Page
#Region " Web 窗体设计器生成的代码 "

    '该调用是 Web 窗体设计器所必需的。
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()

    End Sub
    Protected WithEvents lblCurrentPage As System.Web.UI.WebControls.Label
    Protected WithEvents lnkPrev As System.Web.UI.WebControls.HyperLink
    Protected WithEvents lnkNext As System.Web.UI.WebControls.HyperLink
    Protected WithEvents dl1 As System.Web.UI.WebControls.DataList

    '注意: 以下占位符声明是 Web 窗体设计器所必需的。
    '不要删除或移动它。
    Private designerPlaceholderDeclaration As System.Object

    Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
        'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
        '不要使用代码编辑器修改它。
        InitializeComponent()
    End Sub

#End Region
    Dim conset As ConfigurationSettings
    Dim connstr As String = "Provider=Microsoft.Jet.OLEDB.4.0;data source=" & HttpContext.Current.Server.MapPath(conset.AppSettings("connstr"))
    Dim cn As New OleDbConnection(connstr)

    Private Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Dim da As New OleDbDataAdapter("select id,name,sex,image from tb1", cn)
        Dim ds As New DataSet
        da.Fill(ds, "tb1")

        Dim Pds As PagedDataSource = New PagedDataSource
        Pds.DataSource = ds.Tables(0).DefaultView
        Pds.AllowPaging = True
        Pds.PageSize = 25
        Dim CurPage As Integer
        If Not (Request.QueryString("Page") Is Nothing) Then
            CurPage = Convert.ToInt32(Request.QueryString("Page"))
        Else
            CurPage = 1
        End If
        Pds.CurrentPageIndex = CurPage - 1
        lblCurrentPage.Text = "当前页:" + CurPage.ToString()
        If Not Pds.IsFirstPage Then
            lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1)
        End If
        If Not Pds.IsLastPage Then
            lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1)
        End If
        dl1.DataSource = Pds
        dl1.DataBind()
    End Sub
End Class

博客园  ©  2004-2026
浙公网安备 33010602011771号 浙ICP备2021040463号-3