FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > ComboBoxCellType Class : DataValueField Property |
'Declaration Public Property DataValueField As String
'Usage Dim instance As ComboBoxCellType Dim value As String instance.DataValueField = value value = instance.DataValueField
public string DataValueField {get; set;}
FpSpread1 = new FarPoint.Web.Spread.FpSpread(); FpSpread1.ID = "FpSpread1"; FpSpread1.Style["Position"] = "Absolute"; FpSpread1.Height = 400; FpSpread1.Width = 800; FpSpread1.Style["Top"] = "25px"; FpSpread1.Style["Left"] = "100px"; FarPoint.Web.Spread.SheetView sv = new FarPoint.Web.Spread.SheetView(); FpSpread1.Sheets.Add(sv); form1.Controls.Add(FpSpread1); 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.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.ShowButton = True cb.DataMember = "City/State" cb.DataTextField = "city" cb.DataValueField = "city" cb.UseValue = True FpSpread1.ActiveSheetView.Cells(0, 0).CellType = cb
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6