Spread for ASP.NET 8.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 Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

FpSpread Class
FpSpread Members

User-Task Documentation

Allowing Load on Demand

 

 


Copyright © GrapeCity, inc. All rights reserved.