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

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.
    Public Property DataAutoCellTypes As Boolean
    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
    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"; 
    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"
    sv.DataSource = ds
    See Also