PowerTools SPREAD for ASP.NET 8.0J
CellRange プロパティ (SpreadDataSource)

このデータソースのセル範囲を取得または設定します。
構文
'Declaration
 
Public Property CellRange As CellRange
public CellRange CellRange {get; set;}

プロパティ値

セル範囲を含むCellRange
次のサンプルコードは、セル範囲とリストボックスをSpreadデータソースに連結します。
FpSpread1.DataSource = AccessDataSource1;
FarPoint.Web.Spread.SpreadDataSource spreadDS = new FarPoint.Web.Spread.SpreadDataSource();
spreadDS.SheetName = FpSpread1.ActiveSheetView.SheetName;
spreadDS.SpreadID = "FpSpread1";//FpSpread1.ID;
spreadDS.CellRange = new FarPoint.Web.Spread.Model.CellRange(0, 0, 3, 1);
this.Controls.Add(spreadDS);
this.ListBox1.DataSource = spreadDS;
this.ListBox1.DataTextField = "UserName";
this.ListBox1.DataBind();

FpSpread1.DataSource = AccessDataSource1
Dim spreadDS As New FarPoint.Web.Spread.SpreadDataSource()
spreadDS.SheetName = FpSpread1.ActiveSheetView.SheetName
spreadDS.SpreadID = "FpSpread1"
spreadDS.CellRange = New FarPoint.Web.Spread.Model.CellRange(0, 0, 3, 1)
Controls.Add(spreadDS)
ListBox1.DataSource = spreadDS
ListBox1.DataTextField = "UserName"
ListBox1.DataBind()
参照

SpreadDataSource クラス
SpreadDataSource メンバ

 

 


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