PowerTools SPREAD for ASP.NET 8.0J
DataSourceID プロパティ (ComboBoxCellType)

コンボ ボックスのデータ ソースを表す一意の識別子を取得または設定します。
構文
'Declaration
 
Public Property DataSourceID As String
public string DataSourceID {get; set;}

プロパティ値

データソースの識別子を含むString
次のサンプル コードは、データをコンボボックスに連結します。
DataSet ds = new System.Data.DataSet(); 
DataTable name; 
DataTable city; 
name = ds.Tables.Add("Customers"); 
name.Columns.AddRange(new DataColumn[] {new DataColumn("LastName", typeof(string)), new DataColumn("FirstName", typeof(string)),

new DataColumn("ID", typeof(Int32))}); 
name.Rows.Add(new object[] { "Fielding", "William", 0 }); 
name.Rows.Add(new object[] { "Williams", "Arthur", 1 }); 
name.Rows.Add(new object[] { "Zuchini", "Theodore", 2 }); 
city = ds.Tables.Add("City/State"); 
city.Columns.AddRange(new DataColumn[] {new DataColumn("City", typeof(string)), new DataColumn("Owner", typeof(Int32)), new

DataColumn("State", typeof(string))}); 
city.Rows.Add(new object[] { "Atlanta", 0, "Georgia" }); 
city.Rows.Add(new object[] { "Boston", 1, "Mass." }); 
city.Rows.Add(new object[] { "Tampa", 2, "Fla." }); 
 
FarPoint.Web.Spread.ComboBoxCellType cb = new FarPoint.Web.Spread.ComboBoxCellType(); 
cb.DataSource = ds;
cb.DataSourceID = "MyData" 
cb.ShowButton = true; 
cb.DataMember = "City/State"; 
cb.DataTextField = "city"; 
cb.DataValueField = "city"; 
cb.UseValue = true; 
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = cb;
Dim ds As New System.Data.DataSet
Dim name As DataTable
Dim city As DataTable
name = ds.Tables.Add("Customers")
name.Columns.AddRange(New DataColumn() {New DataColumn("LastName", Type.GetType("System.String")), New DataColumn("FirstName",
Type.GetType("System.String")), New DataColumn("ID", Type.GetType("System.Int32"))})
name.Rows.Add(New Object() {"Fielding", "William", 0})
name.Rows.Add(New Object() {"Williams", "Arthur", 1})
name.Rows.Add(New Object() {"Zuchini", "Theodore", 2})
city = ds.Tables.Add("City/State")
city.Columns.AddRange(New DataColumn() {New DataColumn("City", Type.GetType("System.String")), New DataColumn("Owner", Type.GetType("System.Int32")),
New DataColumn("State", Type.GetType("System.String"))})
city.Rows.Add(New Object() {"Atlanta", 0, "Georgia"})
city.Rows.Add(New Object() {"Boston", 1, "Mass."})
city.Rows.Add(New Object() {"Tampa", 2, "Fla."})

Dim cb As New FarPoint.Web.Spread.ComboBoxCellType
cb.DataSource = ds
cb.DataSourceID = "MyData"
cb.ShowButton = True
cb.DataMember = "City/State"
cb.DataTextField = "city"
cb.DataValueField = "city"
cb.UseValue = True
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = cb
参照

ComboBoxCellType クラス
ComboBoxCellType メンバ

 

 


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