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


In This Topic
    DataAutoCellTypes Property
    In This Topic
    Gets or sets whether a bound sheet automatically sets the cell type for the cells in a column.
    Syntax
    'Declaration
     
    Public Property DataAutoCellTypes As Boolean
    'Usage
     
    Dim instance As SheetView
    Dim value As Boolean
     
    instance.DataAutoCellTypes = value
     
    value = instance.DataAutoCellTypes
    public bool DataAutoCellTypes {get; set;}

    Property Value

    Boolean: true to automatically set the cell type for the cells in a column of a bound sheet; false otherwise
    Example
    This example automatically sets the cell type for the cells in a column.
    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);
    sv.DataAutoCellTypes = true; 
    sv.DataMember = "Patients"; 
    da.Fill(ds); 
    sv.DataSource = ds;
    
    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)
    sv.DataAutoCellTypes = True
    sv.DataMember = "Patients"
    da.Fill(ds)
    sv.DataSource = ds
    See Also