[Firebird-net-provider] Crystal Report with ADO.Net 2.0, how to get data in the report?

[Christian W. <chr...@rt...>]

Hello=20

I am trying to fill a Crystal report from a Firebird database via =
ADO.NET, but the report contains no data rows.

I have workt through the tutorial from Microsoft and can fill Crystal =
reports with CUSTOMER from ACCESS database and OLE DB.

The following code is from the tutorial:
class DataSetConfiguration {

private const string CONNECTION_STRING =3D =
"Provider=3DMicrosoft.Jet.OLEDB.4.0;Data =
Source=3DC:\\Programme\\Microsoft Visual Studio 8\\Crystal =
Reports\\Samples\\en\\Databases\\xtreme.mdb";

private const string QUERY_STRING =3D "SELECT * FROM CUSTOMER";

private const string DATATABLE_NAME =3D "Customer";

public static DataSet CustomerDataSet {

get {

CustomerDataSetSchema dataSet =3D new CustomerDataSetSchema();

OleDbConnection oleDbConnection =3D new OleDbConnection( =
CONNECTION_STRING );

OleDbDataAdapter oleDbDataAdapter =3D new OleDbDataAdapter( =
QUERY_STRING, oleDbConnection );

oleDbDataAdapter.Fill( dataSet, DATATABLE_NAME );

return dataSet;

}

}

}



I try the same with a Firebird ADO.net connection and the adapted code:

public static DataSet LogosDataSet {

get {

ServiceStationLibLogos dataSet =3D new ServiceStationLibLogos();

FbConnectionStringBuilder conStrBuilder =3D new =
FbConnectionStringBuilder();

FbConnection connection =3D new FbConnection( "data =
source=3Dlocalhost;initial =
catalog=3DE:\\ServiceStation\\SERVICESTATIONLIB.FDB;user =
id=3Dsysdba;password=3Dmasterkey");

connection.Open();

FbDataAdapter dataAdapter =3D new FbDataAdapter( "select * from =
\"Logos\"", connection );

dataAdapter.Fill( dataSet );

connection.Close();

return dataSet;

}

}



but my report returns no data. What am I missing ? Who has a working =
example to fill Crystal report from firebird with ADO.NET?