Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / AutoGenerateColumns Property
Example


In This Topic
    AutoGenerateColumns Property (SheetView)
    In This Topic
    Gets or sets whether to generate the columns automatically 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 the columns; false otherwise
    Example
    This example sets whether to automatically generate the columns based on the data source.
    FarPoint.Web.Spread.SheetView sv;
    sv = FpSpread1.ActiveSheetView;
    string conStr = "Provider=Microsoft.JET.OLEDB.4.0;data source= d:\\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);
    da.Fill(ds); 
    sv.DataSource = ds;
    sv.AutoGenerateColumns = false;
    sv.Columns[0].DataField = "HospNo";
    sv.Columns[1].DataField = "LName";
    
    Dim sv As FarPoint.Web.Spread.SheetView
    sv = FpSpread1.ActiveSheetView
    Dim conStr As String = "Provider=Microsoft.JET.OLEDB.4.0;data source= d:\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)
    da.Fill(ds)
    sv.DataSource = ds
    sv.AutoGenerateColumns = False
    sv.Columns(0).DataField = "HospNo"
    sv.Columns(1).DataField = "LName"
    See Also