Spread for ASP.NET 11 Product Documentation
LoadOnDemandMode Enumeration
Example Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace : LoadOnDemandMode Enumeration
Indicates the mode of loading the next rows (standard or in background).
Syntax
'Declaration
 
Public Enum LoadOnDemandMode 
   Inherits System.Enum
'Usage
 
Dim instance As LoadOnDemandMode
public enum LoadOnDemandMode : System.Enum 
Members
MemberDescription
BackgroundIndicates that spread loads the next set of rows after a period of time or after the user scrolls to the row at the SheetView.LoadOffsetFromBottom position.
StandardIndicates that spread only loads the next rows if after scrolling, there are no bottom rows that are hidden from the view.
Example
This example sets the LoadOnDemandMode enumeration.
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
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Web.Spread.LoadOnDemandMode

See Also

Reference

FarPoint.Web.Spread Namespace