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


In This Topic
    DataAutoSizeColumns Property
    In This Topic
    Gets or sets whether a bound sheet automatically sizes its columns based on the data in the associated database fields.
    Syntax
    'Declaration
     
    Public Property DataAutoSizeColumns As Boolean
    'Usage
     
    Dim instance As SheetView
    Dim value As Boolean
     
    instance.DataAutoSizeColumns = value
     
    value = instance.DataAutoSizeColumns
    public bool DataAutoSizeColumns {get; set;}

    Property Value

    Boolean: true if columns are sized automatically; false otherwise
    Remarks

    The width of the column is based on the data type of the field rather than the actual data in the column. Use GetPreferredColumnWidth to get the width of the widest text string in the column.

    If the SpreadScaleMode property is set to ZoomDpiSupport and DataAutoSizeColumns is false, columns and rows may be resized.

    Example
    This example sets whether the column size is automatically set based on the data in the database.
    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.DataAutoSizeColumns = true; 
    fpSpread1.ActiveSheet.DataMember = "Patients"; 
    da.Fill(ds); 
    fpSpread1.ActiveSheet.DataSource = ds;
    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.DataAutoSizeColumns = True
    FpSpread1.ActiveSheet.DataMember = "Patients"
    da.Fill(ds)
    FpSpread1.ActiveSheet.DataSource = ds
    See Also