Spread ASP.NET 15
FarPoint.Web.Spread.Extender Assembly / FarPoint.Web.Spread.Extender Namespace / AjaxComboBoxCellType Class / DataValueField Property
Example


In This Topic
    DataValueField Property (AjaxComboBoxCellType)
    In This Topic
    Gets or sets the data source field that provides the value of each list item.
    Syntax
    'Declaration
     
    Public Property DataValueField As String
    'Usage
     
    Dim instance As AjaxComboBoxCellType
    Dim value As String
     
    instance.DataValueField = value
     
    value = instance.DataValueField
    public string DataValueField {get; set;}
    Example
    This example sets the DataValueField property.
    System.Data.DataSet data = new System.Data.DataSet("data");
    data.Tables.Add("Table1");
    data.Tables["table1"].Columns.Add("dataText");
    data.Tables["table1"].Columns.Add("dataValue");
    data.Tables["table1"].Rows.Add("WinSpread", "1");
    data.Tables["table1"].Rows.Add("WebSpread", "2");
    data.AcceptChanges();
    
    FarPoint.Web.Spread.Extender.AjaxComboBoxCellType combo = new FarPoint.Web.Spread.Extender.AjaxComboBoxCellType();
    combo.ShowEditor = true;
    combo.DataSource = data;
    combo.DataMember = "table1";
    combo.DataTextField = "dataText";
    combo.DataValueField = "dataValue";
    FpSpread1.Sheets[0].Cells[0, 0].CellType = combo;
    Dim data As New System.Data.DataSet("data")
    data.Tables.Add("Table1")
    data.Tables("table1").Columns.Add("dataText")
    data.Tables("table1").Columns.Add("dataValue")
    data.Tables("table1").Rows.Add("WinSpread", "1")
    data.Tables("table1").Rows.Add("WebSpread", "2")
    data.AcceptChanges()
    
    Dim combo As New FarPoint.Web.Spread.Extender.AjaxComboBoxCellType()
    combo.ShowEditor = True
    combo.DataSource = data
    combo.DataMember = "table1"
    combo.DataTextField = "dataText"
    combo.DataValueField = "dataValue"
    FpSpread1.Sheets(0).Cells(0, 0).CellType = combo
    See Also