Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / Column Class / DataField Property
Example


In This Topic
    DataField Property (Column)
    In This Topic
    Gets or sets the data field for this column in the data source.
    Syntax
    'Declaration
     
    Public Property DataField As String
    'Usage
     
    Dim instance As Column
    Dim value As String
     
    instance.DataField = value
     
    value = instance.DataField
    public string DataField {get; set;}

    Property Value

    String containing the name of the data field
    Example
    This example illustrates the use of this member by returning the data field for the column.
    FarPoint.Win.Spread.Column col;
    col = fpSpread1.ActiveSheet.Columns[0];
    string conStr  = "Provider=Microsoft.JET.OLEDB.4.0;data source=D:\\nwind.mdb";
    string sqlStr = "SELECT * FROM Orders";
    System.Data.OleDb.OleDbConnection conn = new System.Data.OleDb.OleDbConnection(conStr);
    DataSet ds = new DataSet();
    System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter(sqlStr, conn);
    da.Fill(ds, "Orders");
    fpSpread1.DataSource = ds;
    listBox1.Items.Add(col.DataField);
    Dim col As FarPoint.Win.Spread.Column
    col = fpSpread1.ActiveSheet.Columns(0)
    Dim conStr As String = "Provider=Microsoft.JET.OLEDB.4.0;data source=D:\\nwind.mdb"
    Dim sqlStr As String = "SELECT * FROM Orders"
    Dim conn As New System.Data.OleDb.OleDbConnection(conStr)
    Dim ds As DataSet = New DataSet()
    Dim da As New System.Data.OleDb.OleDbDataAdapter(sqlStr, conn)
    da.Fill(ds, "Orders")
    fpSpread1.DataSource = ds
    ListBox1.Items.Add(col.DataField)
    See Also