Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / AutoGenerateColumns Property
Example


In This Topic
    AutoGenerateColumns Property (SheetView)
    In This Topic
    Gets or sets whether to automatically generate the columns for a sheet based on the data source.
    Syntax
    'Declaration
     
    Public Property AutoGenerateColumns As Boolean
    'Usage
     
    Dim instance As SheetView
    Dim value As Boolean
     
    instance.AutoGenerateColumns = value
     
    value = instance.AutoGenerateColumns
    public bool AutoGenerateColumns {get; set;}

    Property Value

    Boolean: true to automatically generate columns; false otherwise
    Example
    This example sets whether to automatically generate the columns based on the data source.
    string conStr = "Provider=Microsoft.JET.OLEDB.4.0;data source= " + Application.StartupPath + "\\Patients2000.mdb";
    string sqlStr = "SELECT * FROM Patients"; 
    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);
    fpSpread1.ActiveSheet.DataMember = "Patients"; 
    da.Fill(ds); 
    fpSpread1.ActiveSheet.DataSource = ds;
    fpSpread1.ActiveSheet.DataAutoHeadings = true;
    fpSpread1.ActiveSheet.AutoGenerateColumns = true;
    Dim conStr As String = "Provider=Microsoft.JET.OLEDB.4.0;data source= " & Application.StartupPath & "\Patients2000.mdb"
    Dim sqlStr As String = "SELECT * FROM Patients"
    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)
    FpSpread1.ActiveSheet.DataMember = "Patients"
    da.Fill(ds)
    FpSpread1.ActiveSheet.DataSource = ds
    FpSpread1.ActiveSheet.DataAutoHeadings = True
    FpSpread1.ActiveSheet.AutoGenerateColumns = True
    See Also