Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / ComboBoxCellType Class / DataValueField Property

In This Topic
    DataValueField Property (ComboBoxCellType)
    In This Topic
    Gets or sets the value field of the combo box.
    Public Property DataValueField As String
    Dim instance As ComboBoxCellType
    Dim value As String
    instance.DataValueField = value
    value = instance.DataValueField
    public string DataValueField {get; set;}

    Property Value

    String containing the data value field
    This example uses a DataSet to populate the combobox.
    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();
    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
    See Also