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