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


In This Topic
    DataSource Property (SheetView)
    In This Topic
    Gets or sets the name of the data source that populates the sheet.
    Syntax
    'Declaration
     
    Public Property DataSource As Object
    'Usage
     
    Dim instance As SheetView
    Dim value As Object
     
    instance.DataSource = value
     
    value = instance.DataSource
    public object DataSource {get; set;}

    Property Value

    Object containing the data source
    Exceptions
    ExceptionDescription
    Data model does not support IDataSourceSupport interface
    Example
    This example sets the data member and data source for a bound spreadsheet.
    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
    Requirements

    Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

    See Also