带有Repeater控件的幻灯片内容 [英] Slide content with Repeater control

问题描述

你好，

我想在vb.net网站上有一个滑块内容.
我设置了一个转发器，将数据库中最近5篇文章中的数据带给我.
日期，标题，图像

我需要显示我所有的最后一篇文章，但我不想在冗长的列表中显示.我想拥有最后5个，并且在此列表下具有
最新新闻

id1
id2
id3
id4
id5

上一个" 1,2,3下一个"

这样访客就可以看到接下来的5篇文章，等等
我不需要图像滑块，我需要从数据库中获取数据.我不想使用datagridvriew.有可能用vb，ajax在asp.net中做到吗?我使用Visual Studio 10，SQL Server2008.

谢谢

Hello,

I would like to have a slider content on a vb.net site.
I have set up a repeater which bring me data from the last 5 articles from my database.
date, title, image

I need to show all my last articles but i dont want to be shown in a long list. I would like to have the last 5, and under this list to have
Latest News

id1
id2
id3
id4
id5

"prev" 1,2,3 "next"

so the visitor can see the next 5 articles, etc
I dont want an image slider, I need to bring my data from my database. I dont want to use a datagridvriew. Is that possible to do it in asp.net with vb, ajax? I use visual studio 10, SQL Server 2008.

Thank you

推荐答案

您在说的只是分页".完全相同的概念适用于您的情况，就像适用于DataGridView一样.

[

What you''re talking about is simply "paging". The exact same concepts apply to your situation as they do to a DataGridView.

Google results for "ASP.NET Paging"[^]

我在upadte面板中使用了一个转发器控件来从中获取一些数据我的数据库. br/>

I use a repeater control inside in upadte panel to bring some data from my db.

<asp:updatepanel id="UpdatePanel1" runat="server" updatemode="Conditional" xmlns:asp="#unknown">
        <contenttemplate>
    
    <asp:hyperlink id="linkPrev" runat="server"><< </asp:hyperlink>
    <asp:hyperlink id="linkNext" runat="server"> >></asp:hyperlink>
    
            <asp:repeater id="Repeater1" runat="server">
                <itemtemplate>
                    <%#DataBinder.Eval(Container.DataItem, "date")%><br />
                    Title:<br />
                    <%#DataBinder.Eval(Container.DataItem, "title")%>
                    <asp:hyperlink id="lnkDetails" runat="server" navigateurl="<%# Eval("item_ID", "~/Details.aspx?ID={0}") %>">more</asp:hyperlink>
                   
                    <br />
                    <br />
                    <hr width="100px" />
                    <br />
                </itemtemplate>
            </asp:repeater>
            </contenttemplate>

</asp:updatepanel>

在我后面的代码中，我有

In my code behind I have

Protected Sub Page_Load(sender As Object, e As System.EventArgs) Handles Me.Load
        If Not Page.IsPostBack Then
            Dim strsql As String = "SELECT  * FROM news ORDER BY news.item_ID DESC"
            Dim sqlconn As New SqlConnection

            sqlconn.ConnectionString = ConfigurationManager.ConnectionStrings("mycon").ToString
            sqlconn.Open()
            Dim cmd As New SqlCommand(strsql, sqlconn)

            Dim da As New SqlDataAdapter(strsql, sqlconn)
            Dim table As New DataTable()
            da.Fill(table)

            Dim pds As New PagedDataSource()
            pds.DataSource = table.DefaultView
            pds.AllowPaging = True
            pds.PageSize = 5

            Dim currentPage As Integer

            If Request.QueryString("page") IsNot Nothing Then
                currentPage = Int32.Parse(Request.QueryString("page"))
            Else
                currentPage = 1
            End If

            pds.CurrentPageIndex = currentPage - 1


            If Not pds.IsFirstPage Then

                linkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?page=" & (currentPage - 1)
            End If

            If Not pds.IsLastPage Then
                linkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?page=" & (currentPage + 1)
            End If

            Repeater1.DataSource = pds
            Repeater1.DataBind()

            cmd.Connection.Close()
            cmd.Connection.Dispose()
        End If
    End Sub

分页工作正常，但它会重新加载孔页面.
我不想使用gridview，因为我需要以某种方式显示数据.

我必须使用触发器和链接按钮吗?您知道我必须如何转换代码吗?

谢谢

The paging works fine, but it reloads the hole page.
I dont want to use a gridview because I need to display my data in a certain way.

Do I have to use triggers and link buttons? Do you know how I have to transform my code?

thank you

你好
我用链接按钮做到了
所以在我的标记中
我有

Hello
I did it with link buttons
so in my markup
I have

<asp:updatepanel id="UpdatePanel1" runat="server" xmlns:asp="#unknown">
                                        <contenttemplate>
                                            <asp:linkbutton id="btnPrev" runat="server" onclick="btnPrev_Click">PrevButton</asp:linkbutton>
                                           <asp:textbox id="txtHidden" style="width: 28px" value="1" runat="server" />
                                            <asp:linkbutton id="btnNext" runat="server" onclick="btnNext_Click">NextButton</asp:linkbutton>
                                            <asp:repeater id="Repeater1" runat="server">
                                                <itemtemplate>
                                                    <div class="latnewstitle">
                                                        Date:</div>
                                                    <%#DataBinder.Eval(Container.DataItem, "date")%><br />
                                                    <div class="latnewstitle">
                                                        Title:</div>
                                                    <div class="latnewscontent">
                                                        <%#DataBinder.Eval(Container.DataItem, "title")%></div>
                                                    <asp:hyperlink id="lnkDetails" runat="server" navigateurl="<%# Eval("item_ID", "~/Details.aspx?ID={0}") %>">See Details</asp:hyperlink>
                                                   
                                                    <br />
                                                    <hr width="100px" />
                                                    <br />
                                                </itemtemplate>
                                            </asp:repeater>
                                            
                                            <br />
                                            <br />
                                        </contenttemplate>
                                    </asp:updatepanel> 

在我后面的代码中

in my code behind

Public Property PgNum() As Integer
        Get
            If ViewState("PgNum") IsNot Nothing Then
                Return Convert.ToInt32(ViewState("PgNum"))
            Else
                Return 0
            End If
        End Get
        Set(value As Integer)
            ViewState("PgNum") = value

        End Set
    End Property

    Protected Sub Page_Init(sender As Object, e As System.EventArgs) Handles Me.Init
        bindrepeater()
    End Sub

    Protected Sub Page_Load(sender As Object, e As EventArgs)
        If Not Page.IsPostBack Then
            bindrepeater()
        End If
    End Sub
    Public Sub bindrepeater()
        Dim cnt As Integer
        Dim strsql As String = "SELECT  * FROM news ORDER BY news.item_ID DESC"
        Dim sqlconn As New SqlConnection
        sqlconn.ConnectionString = ConfigurationManager.ConnectionStrings("mycon").ToString
        sqlconn.Open()
        Dim cmd As New SqlCommand(strsql, sqlconn) 

        Dim da As New SqlDataAdapter(cmd)
        Dim ds As New DataSet
        da.Fill(ds)
        cnt = ds.Tables(0).Rows.Count
       
        Dim pds As New PagedDataSource()
        pds.DataSource = ds.Tables(0).DefaultView
        pds.AllowPaging = True
        pds.PageSize = 5
        pds.CurrentPageIndex = PgNum

        txtHidden.Text = PgNum
        Dim vcnt As Integer = cnt / pds.PageSize
        If PgNum < 1 Then
            btnPrev.Visible = False
        ElseIf PgNum > 0 Then
            btnPrev.Visible = True
        End If
        If PgNum = 1 Then
            btnPrev.Visible = False
        End If


        If PgNum = vcnt Then
            btnNext.Visible = False
        ElseIf PgNum < vcnt Then
            btnNext.Visible = True
        End If
        cmd.Connection.Close()
        cmd.Connection.Dispose()
        Repeater1.DataSource = pds
        Repeater1.DataBind()


    End Sub
    Protected Sub btnNext_Click(sender As Object, e As System.EventArgs) Handles btnNext.Click
        PgNum += 1
        bindrepeater()
    End Sub

    Protected Sub btnPrev_Click(sender As Object, e As System.EventArgs) Handles btnPrev.Click
        PgNum -= 1
        bindrepeater()
    End Sub

我的问题是我的下一个按钮始终为+2，上一个按钮为-2.我尝试了没有更新面板，但它总是可以显示+2页.

我的代码与此类似
使用中继器控制进行分页 [

My problem is that my next button goes always +2 and the previous button -2. I tried without update panel but it same always goes +2 pages.

My code is similar to this
Pagination with Repeater Control[^]

这篇关于带有Repeater控件的幻灯片内容的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！