CODEWITHSUNDEEP
asp.net
Youssef
Youssef

Reputation: 728

GridView Paging inside a repeater

I have a gridview nested within a repeater, and I'm trying to enable paging on the gridview without much success.

The gridview databound is like this

<asp:repeater....> 
    <asp:gridview id="GridView1" Datasource='<%# LoadData(CInt(Eval("Id"))) %>' 
         OnPageIndexChanging="GridViewPageIndexChanging" AllowPaging="true" 
PageSize="10" ............. </asp:GridView>
</asp:repeater>

In the code behind my LoadData method get a list of objects:

Public Function LoadData(ByVal Id As Integer) As IList(Of Client)
            Dim ds As IList(Of Client) = client.GetClientById(Id)
            Return ds
        End Function

And the event handler is as follow:

Protected Sub GridViewPageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs)
            sender.PageIndex = e.NewPageIndex
End Sub

My code doesn't change the page in the gridview, am I missing something ?

Any help is very much appreciated.

Upvotes: 1

Views: 3691

Answers (3)

Youssef
Youssef

Reputation: 728

I'm one step further , After I do the binding I got an exception on Eval. I changed it in the datasource to <%#LoadData(DataBinder.Eval(Container.DataItem,"Id"))%>

I don't get the Eval exception anymore after the binding. However my grid still empty.

[update]

Ok I got it solved by keeping my Ids in hashtable and I rebind my gridview with the equivalent id from the hashtable.

It is all good now thanks everyone for your helps.

Upvotes: 1

Ruslan
Ruslan

Reputation: 1761

You have to call DataBind().

Dim grid as GridView = DirectCast(sender, GridView)
grid.PageIndex = e.NewPageIndex
grid.DataBind()

EDIT

Since I can't comment yet and creating another answer to an answer makes everything confusing, I'll just edit this one.

I'm afraid the Repeater is a wrong control to use for what you want. The problem stems from the fact that it does not preserve DataItem when GridView's page events fire. So the "id" gets evaluated into nothing and subsequently a zero. Btw, in C# you'd get a null exception.

I suggest you use the DataList instead:

<asp:DataList ID="DataList" runat="server" DataKeyField="id">
    <ItemTemplate>
        <asp:GridView ID="Grid" runat="server"
            AllowPaging="true"
            PageSize="2"
            OnPageIndexChanging="Grid_PageIndexChanging"
            DataSource='<%# GetData(DirectCast(DataList.DataKeys(DirectCast(Container, DataListItem).ItemIndex), Integer)) %>'
        >
        </asp:GridView>
        <hr />
    </ItemTemplate>
</asp:DataList>

With code behind:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    If Not IsPostBack Then
        DataList.DataSource = New Integer() {1, 2, 3, 4, 5}.Select(Function(x) New With {.id = x})
        DataList.DataBind()
    End If
End Sub

Protected Function GetData(ByVal id As Integer) As String()
    Dim arr As String() = New String(4) {}
    For i As Integer = 0 To arr.Length - 1
        arr(i) = String.Format("id {0}; grid item {1}", id, i)
    Next
    Return arr
End Function

Protected Sub Grid_PageIndexChanging(ByVal sender As Object, ByVal e As GridViewPageEventArgs)
    Dim grid As GridView = DirectCast(sender, GridView)
    grid.PageIndex = e.NewPageIndex
    grid.DataBind()
End Sub

This code works -- I tested. Although, personally I don't like using binding expressions.

Upvotes: 3

Dan Appleyard
Dan Appleyard

Reputation: 7445

One thing I see if your markup. Your sample has the GridView directly within the Repeater control. You will need it within the ItemTemplate.

<asp:Repeater ID="rpt" runat="server" ...>
   <ItemTemplate>
      <asp:GridView id="gv1" runat="server" ...>
      .
      .
      .
      </asp:GridView>
   </ItemTemplate>
</asp:Repeater>

Upvotes: 0

Related Questions