Spread for ASP.NET 9.0 Product Documentation
LoadRowIncrement Property (FpSpread)
Example 


Gets or sets the number of rows to include in incremental loads on demand.
Syntax
'Declaration
 
Public Property LoadRowIncrement As Integer
'Usage
 
Dim instance As FpSpread
Dim value As Integer
 
instance.LoadRowIncrement = value
 
value = instance.LoadRowIncrement
public int LoadRowIncrement {get; set;}
Example
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);
    daCust.Fill(ds);
    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(); 
    } 
    else 
    { 
            e.SheetView.LoadViewState(Session["sheet1"]); 
    } 
    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)
daCust.Fill(ds)
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()

    Else

        e.SheetView.LoadViewState(Session("sheet1"))

    End If

    e.Handled = True


End Sub
Requirements

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

See Also

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Allowing Load on Demand

 

 


Copyright © GrapeCity, inc. All rights reserved.