|
Hello
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 = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\\Programme\\Microsoft Visual Studio 8\\Crystal
Reports\\Samples\\en\\Databases\\xtreme.mdb";
private const string QUERY_STRING = "SELECT * FROM CUSTOMER";
private const string DATATABLE_NAME = "Customer";
public static
DataSet CustomerDataSet {
get {
CustomerDataSetSchema dataSet = new CustomerDataSetSchema();
OleDbConnection oleDbConnection = new OleDbConnection(
CONNECTION_STRING );
OleDbDataAdapter oleDbDataAdapter = 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 = new ServiceStationLibLogos(); FbConnectionStringBuilder conStrBuilder = new FbConnectionStringBuilder(); FbConnection connection = new FbConnection( "data source=localhost;initial catalog=E:\\ServiceStation\\SERVICESTATIONLIB.FDB;user id=sysdba;password=masterkey");connection.Open(); FbDataAdapter dataAdapter = 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?
|
------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
