Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread.Model Namespace / IDataSourceSupport Interface / DataSource Property
Example


In This Topic
    DataSource Property (IDataSourceSupport)
    In This Topic
    Gets or sets the data source.
    Syntax
    'Declaration
     
    Property DataSource As Object
    'Usage
     
    Dim instance As IDataSourceSupport
    Dim value As Object
     
    instance.DataSource = value
     
    value = instance.DataSource
    object DataSource {get; set;}

    Property Value

    Object containing the data source
    Example
    This example binds the model to a data set.
    string strConn  = "data source = 127.0.0.1;initial catalog=Pubs; integrated security = SSPI";
    string sqlStr = "SELECT * FROM Authors; Select * From Titles";
    
    System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(sqlStr, strConn);
    DataSet ds = new DataSet();
    da.Fill(ds);
    
    FarPoint.Web.Spread.Model.IDataSourceSupport dss;
    dss = (FarPoint.Web.Spread.Model.IDataSourceSupport)FpSpread1.ActiveSheetView.DataModel;
    dss.AutoGenerateColumns = true;
    dss.DataSource = ds;
    dss.DataMember = "Table";
    dss.DataKeyField = "auid";
    
    Dim strConn As String = "data source = 127.0.0.1;initial catalog=Pubs; integrated security = SSPI"
    Dim sqlStr As String = "SELECT * FROM Authors; Select * From Titles"
    
    Dim da As New System.Data.SqlClient.SqlDataAdapter(sqlStr, strConn)
    Dim ds As New DataSet
    da.Fill(ds)
    
    Dim dss As FarPoint.Web.Spread.Model.IDataSourceSupport
    dss = FpSpread1.ActiveSheetView.DataModel
    dss.AutoGenerateColumns = True
    dss.DataSource = ds
    dss.DataMember = "Table"
    dss.DataKeyField = "auid"
    See Also