Table.SetDataSource Method (Object)

Passes a Recordset or Dataset to the report engine.

Namespace CrystalDecisions.CrystalReports.Engine Assembly CrystalDecisions.CrystalReports.Engine (CrystalDecisions.CrystalReports.Engine.dll)

Syntax

'Declaration
Public Overrideable Sub SetDataSource ( _
    ByVal val As Object _   
) 
public virtual void SetDataSource (
    object val
)

Parameters

  • val
    Represents a valid dataset object.

Example

The following example creates a dataset and passes it to the Customer table. The method uses the ADO.NET object model to set up the connection information. The method then connects to the data source, fetches the data, and disconnects from the datasource. Finally, the populated dataset is passed to the Customer table.

'Declaration

      Private Function SetDataSource _ 
         (ByVal conn As String, ByVal query As String, _
         ByVal dataSet As DataSet)
      
         Dim oleConn As New OleDbConnection(conn)
         Dim oleAdapter As New OleDbDataAdapter()
         oleAdapter.SelectCommand = New OleDbCommand(query, oleConn)
      
         oleAdapter.Fill(dataSet, "Customer")
      
         myReportDocument.Database.Tables.Item("Customer").SetDataSource(dataSet)
      End Function
      
      void SetDataSource(String* conn, String* query, DataSet* dataSet)
      {
         OleDbConnection* oleConn = 
            new OleDbConnection(conn);
      
         OleDbDataAdapter* oleAdapter = new OleDbDataAdapter();
         oleAdapter->SelectCommand = new OleDbCommand(query, oleConn);
      
         oleAdapter->Fill(dataSet, "Customer");
      
         reportDocument->Database->Tables->
            Item["Customer"]->SetDataSource(dataSet);
      };
      
      private void SetDataSource
         (string conn, string query, DataSet dataSet)
      {
         OleDbConnection oleConn = new OleDbConnection(conn);
         OleDbDataAdapter oleAdapter = new OleDbDataAdapter();
         oleAdapter.SelectCommand = new OleDbCommand(query, oleConn);
      
         oleAdapter.Fill(dataSet, "Customer");
      
         reportDocument.Database.Tables["Customer"].SetDataSource (dataSet);
      }
      

Version Information

Crystal Reports Basic for Visual Studio 2008

Supported since: Crystal Reports for Visual Studio .NET 2002

See Also

Reference

Table Class
Table Members
CrystalDecisions.CrystalReports.Engine Namespace