Spread for ASP.NET 11 Product Documentation
LoadOnDemandMode Property
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetView Class : LoadOnDemandMode Property
Gets or sets the LoadOnDemandMode property. In Standard mode, spread loads the next set of rows, if after scrolling, there are no bottom rows (in the view) that are hidden. In Background mode, spread loads the next set of rows after a period of time or after the user scrolls to the row at the LoadOffsetFromBottom position.
Syntax
'Declaration
 
Public Property LoadOnDemandMode As LoadOnDemandMode
'Usage
 
Dim instance As SheetView
Dim value As LoadOnDemandMode
 
instance.LoadOnDemandMode = value
 
value = instance.LoadOnDemandMode
public LoadOnDemandMode LoadOnDemandMode {get; set;}
Example
This example sets the LoadOnDemandMode property.
protected void Page_Load(object sender, System.EventArgs e)
{
FpSpread1.ActiveSheetView.RowCount = 100;
FpSpread1.ActiveSheetView.PageSize = 200;
FpSpread1.ActiveSheetView.AllowPage = false;

FpSpread1.AllowLoadOnDemand = true;
FpSpread1.LoadInitRowCount = 50;
FpSpread1.LoadRowIncrement = 15;
FpSpread1.Sheets[0].LoadOnDemandMode = FarPoint.Web.Spread.LoadOnDemandMode.Background;
FpSpread1.Sheets[0].LoadOnDemandTriggerMode = FarPoint.Web.Spread.LoadOnDemandTriggerMode.Timed;
FpSpread1.Sheets[0].LoadOnDemandInterval = 1000; // after every second, perform load on demand 
FpSpread1.Sheets[0].LoadOffsetFromBottom = 20; // this setting is meaningless in Timed trigger mode 
}
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
FpSpread1.ActiveSheetView.RowCount = 100
FpSpread1.ActiveSheetView.PageSize = 200
FpSpread1.ActiveSheetView.AllowPage = False

FpSpread1.AllowLoadOnDemand = True
FpSpread1.LoadInitRowCount = 50
FpSpread1.LoadRowIncrement = 15
FpSpread1.Sheets(0).LoadOnDemandMode = FarPoint.Web.Spread.LoadOnDemandMode.Background
FpSpread1.Sheets(0).LoadOnDemandTriggerMode = FarPoint.Web.Spread.LoadOnDemandTriggerMode.Timed
FpSpread1.Sheets(0).LoadOnDemandInterval = 1000 ' after every second, perform load on demand 
FpSpread1.Sheets(0).LoadOffsetFromBottom = 20 ' this setting is meaningless in Timed trigger mode 
End Sub
See Also

Reference

SheetView Class
SheetView Members