Rad Grid don´t pagging

[Hector Hernandez]

I have one RadGrid with PageSize="5" and i populate with a dataset:

Public Sub LlenaGrid()
      Strsql = "Select Empresa,Corr,NomPuesto,Salario from templeo where codusuario = " & Session("CodUsuario") & ""
      cn.Open()
      daData.SelectCommand = New OleDb.OleDbCommand(Strsql, cn)
      daData.Fill(dsGen, "DATA")
      GrdEmpleo.DataSource = dsGen
      GrdEmpleo.DataMember = "DATA"
      GrdEmpleo.DataBind()
      cn.Close()

      dsGen.Tables("DATA").Clear()
  End Sub

and the Grid work but when i move to the page No 2 or i click next page the Grid don´t show me any result, this is the html of the grid: 

<telerik:RadGrid runat="server" ID="GrdEmpleo" PageSize="5" AutoGenerateColumns="False"
                    Width="100%" AllowSorting ="True" AllowPaging ="True" GridLines="None" TabIndex="17">
                <PagerStyle Mode="NextPrevAndNumeric" NextPageText="Siguiente" PrevPageText="Anterior"
                 PagerTextFormat="Change page: {4} &nbsp;Pagina <strong>{0}</strong> de <strong>{1}</strong>, registros <strong>{2}</strong> a <strong>{3}</strong> de <strong>{5}</strong>."
                 PageSizeLabelText="Regitros"/>
                <MasterTableView DataKeyNames="Empresa,Corr,NomPuesto,Salario">
                    <Columns>
                        <telerik:GridButtonColumn DataTextField="Empresa" UniqueName="Empresa" HeaderText="Empresa"></telerik:GridButtonColumn>
                        <telerik:GridBoundColumn DataField="Corr" UniqueName="Corr" Visible="false" HeaderStyle-Width="75px"></telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Nompuesto" UniqueName="NomPuesto" HeaderText="Puesto"  HeaderStyle-Width="75px"></telerik:GridBoundColumn>
                        <telerik:GridBoundColumn DataField="Salario" HeaderText="Salario" HeaderStyle-Width="75px">
                        </telerik:GridBoundColumn>
                    </Columns>
                </MasterTableView>
                <clientsettings>
                    <selecting allowrowselect="True" />
                </clientsettings>
                <FilterMenu EnableTheming="true">
                    <CollapseAnimation Duration="200" Type="InOutQuint" />
                </FilterMenu>
             </telerik:RadGrid>

and here is the event PageIndexChanged:

Private Sub GrdEmpleo_PageIndexChanged(ByVal sender As Object, ByVal e As Telerik.Web.UI.GridPageChangedEventArgs) Handles GrdEmpleo.PageIndexChanged
        Try
            LlenaGrid()
        Catch ex As Exception
            LblMensaje.Text = ex.Message
        End Try

    End Sub

I don´t know whats happend whit this grid, i need some helps
thank you in advance

[Shinu]

Hello Hector,

The issue occurs because you are binding the grid using Simple data binding technique. If you are using any advanced feature in grid(like paging), then a better approach is binding RadGrid using "AdvancedData binding" using NeedDataSource event.

Please go through the following documents for more on this.
Advanced Data-binding (using NeedDataSource event)
Grid / Advanced Data Binding

Thanks,
Shinu.

[Hector Hernandez]

Thank you the Advanced Data-binding (using NeedDataSource event) works fine!