PowerTools SPREAD for ASP.NET 8.0J
LoadRowIncrement プロパティ (FpSpread)

ロードオンデマンド時の増分の行数を取得または設定します。
構文
'Declaration
 
Public Property LoadRowIncrement As Integer
public int LoadRowIncrement {get; set;}
次のサンプルコードは、指定した行数がロードされるようにします。
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
参照

FpSpread クラス
FpSpread メンバ

開発者の手引き

ロードオンデマンド

 

 


© 2003-2015, GrapeCity inc. All rights reserved.