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

In This Topic
    DataField Property (Column)
    In This Topic
    Gets or sets the data field for this column in the data source.
    Public Property DataField As String
    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
    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;
    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
    See Also