FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > MultiColumnComboBoxCellType Class : DataSource Property |
'Declaration Public Property DataSource As Object
'Usage Dim instance As MultiColumnComboBoxCellType Dim value As Object instance.DataSource = value value = instance.DataSource
public object DataSource {get; set;}
System.Data.DataSet ds = new System.Data.DataSet(); System.Data.DataTable emp = new System.Data.DataTable("Employees"); System.Data.DataTable div = new System.Data.DataTable("Division"); emp.Columns.Add("LastName"); emp.Columns.Add("FirstName"); emp.Rows.Add(new Object[] { "Jones", "Marianne" }); emp.Rows.Add(new Object[] { "Fieldes", "Anna" }); div.Columns.Add("Section"); div.Columns.Add("Specialty"); div.Rows.Add(new Object[] { "Finance", "Taxes" }); div.Rows.Add(new Object[] { "Mergers", "Legal" }); ds.Tables.AddRange(new System.Data.DataTable[] { emp, div }); FarPoint.Web.Spread.MultiColumnComboBoxCellType mccbct = new FarPoint.Web.Spread.MultiColumnComboBoxCellType(); mccbct.DataSource = ds; mccbct.VerticalAlign = VerticalAlign.Top; FpSpread1.ActiveSheetView.Cells[0, 0].CellType = mccbct;
Dim ds As New DataSet() Dim emp As New DataTable("Employees") Dim div As New DataTable("Division") emp.Columns.Add("LastName") emp.Columns.Add("FirstName") emp.Rows.Add(New Object() {"Jones", "Marianne"}) emp.Rows.Add(New Object() {"Fieldes", "Anna"}) div.Columns.Add("Section") div.Columns.Add("Specialty") div.Rows.Add(New Object() {"Finance", "Taxes"}) div.Rows.Add(New Object() {"Mergers", "Legal"}) ds.Tables.AddRange(New DataTable() {emp, div}) Dim mccbct As New FarPoint.Web.Spread.MultiColumnComboBoxCellType mccbct.DataSource = ds mccbct.VerticalAlign = VerticalAlign.Top FpSpread1.ActiveSheetView.Cells(0, 0).CellType = mccbct
Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional