Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / FpSpread Class / LoadRowIncrement Property

In This Topic
    LoadRowIncrement Property (FpSpread)
    In This Topic
    Gets or sets the number of rows to include in incremental loads on demand.
    Public Property LoadRowIncrement As Integer
    Dim instance As FpSpread
    Dim value As Integer
    instance.LoadRowIncrement = value
    value = instance.LoadRowIncrement
    public int LoadRowIncrement {get; set;}
    This example allows the loading of a specified number of rows.
    protected void PageLoad(object sender, EventArgs e)
        string conStr = "Provider=Microsoft.JET.OLEDB.4.0;data source= c:\\nwind.mdb";
        string sqlStr = "SELECT * FROM Orders";
        System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(conStr);
        System.Data.DataSet ds = new System.Data.DataSet();
        System.Data.OleDb.OleDbDataAdapter daCust = new System.Data.OleDb.OleDbDataAdapter(sqlStr, conn);
        FpSpread1.ActiveSheetView.DataSource = ds;
        FpSpread1.ActiveSheetView.PageSize = 200; 
        FpSpread1.AllowLoadOnDemand = true; 
        FpSpread1.LoadInitRowCount = 15; 
        FpSpread1.LoadRowIncrement = 5;
        FpSpread1.ActiveSheetView.AllowPage = false; 
     protected void FpSpread1SaveOrLoadSheetState(object sender, FarPoint.Web.Spread.SheetViewStateEventArgs e)
        if (e.IsSave) 
                Session["sheet1"] = e.SheetView.SaveViewState(); 
        e.Handled = true;
    Protected Sub PageLoad(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
    Dim conStr As String = "Provider=Microsoft.JET.OLEDB.4.0;data source= c:\nwind.mdb"
    Dim sqlStr As String = "SELECT * FROM Customers"
    Dim conn As System.Data.OleDb.OleDbConnection = New System.Data.OleDb.OleDbConnection(conStr)
    Dim ds As Data.DataSet = New Data.DataSet
    Dim daCust As System.Data.OleDb.OleDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter(sqlStr, conn)
    FpSpread1.ActiveSheetView.DataSource = ds
    FpSpread1.ActiveSheetView.PageSize = 15
    FpSpread1.AllowLoadOnDemand = True
    FpSpread1.LoadInitRowCount = 15
    FpSpread1.LoadRowIncrement = 5
    FpSpread1.ActiveSheetView.AllowPage = False
    End Sub
    Protected Sub FpSpread1SaveOrLoadSheetState(ByVal sender As Object, ByVal e As FarPoint.Web.Spread.SheetViewStateEventArgs)
    Handles FpSpread1.SaveOrLoadSheetState
    If e.IsSave Then
    Session("sheet1") = e.SheetView.SaveViewState()
        End If
        e.Handled = True
    End Sub
    See Also