GrapeCity.Win.PluginInputMan Assembly > GrapeCity.Win.Spread.InputMan.CellType Namespace > GcComboBoxCellType Class : DataSource Property |
'Declaration Public Property DataSource As Object
'Usage Dim instance As GcComboBoxCellType Dim value As Object instance.DataSource = value value = instance.DataSource
public object DataSource {get; set;}
DataSet ds = new DataSet(); DataTable emp = new DataTable("Employees"); DataTable div = 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 }); GrapeCity.Win.Spread.InputMan.CellType.GcComboBoxCellType gccombo = new GrapeCity.Win.Spread.InputMan.CellType.GcComboBoxCellType(); gccombo.DataSource = ds; gccombo.DataMember = "Division"; fpSpread1.Sheets[0].Cells[0, 0].CellType = gccombo;
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 gccombo As New GrapeCity.Win.Spread.InputMan.CellType.GcComboBoxCellType() gccombo.DataSource = ds gccombo.DataMember = "Division" FpSpread1.Sheets(0).Cells(0, 0).CellType = gccombo
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10