SpreadDataSource Constructor

Visual Basic
C#

'Declaration
 
Public Function New()

'Usage
 
Dim instance As New SpreadDataSource()

public SpreadDataSource()

This example binds a cell range and a listbox to the Spread data source.

C#

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();

Visual Basic

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()

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SpreadDataSource Class
SpreadDataSource Members