DataGrid Paging

Question

Hi, I am using VB.Net 2005, with IE7. I have a datagrid where I have set paging "AllowPaging" = True However, when I click the link to the next page, the records are still the same.

My code is:

ds = SQLHelper.ExecuteDataset(strConn, 
      CommandType.StoredProcedure, "GetInventory")
dv = ds.Tables(0).DefaultView
dgInvestoryList.DataSource = dv
dgInvestoryList.DataBind()

What am I missing?

Answer 1

If you are using the Wizard with the SqlDataSource, then paying will be there all ready.

But if you go and place your code in the code behind you will have to do something like this - sorry i dont have the code for VB.NET - Must place code in the PageIndexChanging event. Use this This link to change my C# code to VB.NET, i use it ALOT

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        try
        {
            DataSet ds = new DataSet();
            GridView1.DataSource = ds;
            GridView1.PageIndex = e.NewPageIndex;
            this.GridView1.DataBind();
        }
        catch (Exception)
        {
            Response.Redirect("Login.aspx");
        }

    }