ReportDocument.SetDataSource Method (System.Data.DataSet)

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 dataSet As System.Data.DataSet _  
) 

public virtual void SetDataSource (
    System.Data.DataSet dataSet
)

Parameters

• dataSet
  Represents a valid dataset object.

Example

This example sets the data source in the report to a dataset.

'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.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->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.SetDataSource(dataSet);
      }
      

Version Information

Crystal Reports Basic for Visual Studio 2008

Supported since: Crystal Reports .NET 10

See Also

Reference

ReportDocument Class
ReportDocument Members
CrystalDecisions.CrystalReports.Engine Namespace