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