datagridview paging

[arshesander]

I set the AllowPaging = True and use this code

    protected void GridView1_PageIndexChanging(object sender, System.Web.UI.WebControls.GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GridView1.DataBind();
    }

but it still doesn't show the records in 2nd, 3rd and so on...

[MonkOFox]

You have to assign the datasource again as well. So you have to re-query or just store the datasource (datatable, etc) globally and .Datasource = x and DataBind().

Justin

[arshesander]

how? i have this code to connect the data source

        SqlConnection oConn = new SqlConnection(ConfigurationManager.AppSettings["constring"]);

        DataSet dsGrid = new DataSet();

        SqlDataAdapter cmdGrid = new SqlDataAdapter("spGetOrder", oConn); //Where sp is stored procedure name
        cmdGrid.SelectCommand.CommandType = CommandType.StoredProcedure;
        cmdGrid.SelectCommand.CommandTimeout = 300;

        cmdGrid.Fill(dsGrid, "Orders");

        DataView dv = new DataView(dsGrid.Tables["Orders"]);

        grdOrders.DataSource = dv;

        grdOrders.DataBind();

[MonkOFox]

Private Sub SetOrdersDataSource()
 
        SqlConnection oConn = new SqlConnection(ConfigurationManager.AppSettings["constring"]);
 
        DataSet dsGrid = new DataSet();
 
        SqlDataAdapter cmdGrid = new SqlDataAdapter("spGetOrder", oConn); //Where sp is stored procedure name
        cmdGrid.SelectCommand.CommandType = CommandType.StoredProcedure;
        cmdGrid.SelectCommand.CommandTimeout = 300;
 
        cmdGrid.Fill(dsGrid, "Orders");
 
        DataView dv = new DataView(dsGrid.Tables["Orders"]);
 
        grdOrders.DataSource = dv;
 
        grdOrders.DataBind();
 
End Sub
 
 
    protected sub GridView1_PageIndexChanging(sender as object ,  e as System.Web.UI.WebControls.GridViewPageEventArgs)
    
        GridView1.PageIndex = e.NewPageIndex;
        BindOrdersDataSource()
        GridView1.DataBind();
 
    end sub