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


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > FpSpread Class : LoadRowIncrement Property
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
See Also

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Allowing Load on Demand