datagridview paging

[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