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