Hello
I now can load a Crystal Report from firebird with
ADO.NET.
I use a case sensitive database (quoted
identifiers, not every body likes this, but the VS 2005 generated
code looks much nicer), and I have to use quotes sometimes and sometimes
not:
The contructor of FbDataAdapter must have quoted
identifiers, the Fill methode must NOT have quoted identifiers. Has some one an
explanation for this?
public static DataSet LogosDataSet
{
get
{
ServiceStationLibLogos dataSet = new ServiceStationLibLogos();
FbConnection connection = new FbConnection( "data
source=localhost;initial catalog=E:\\ServiceStation\\SERVICESTATIONLIB.FDB;user
id=sysdba;password=masterkey");
FbDataAdapter dataAdapter = new FbDataAdapter( "select * from
\"Logos\"", connection );
// Expected, but NOT working:
//
dataAdapter.Fill( dataSet, "\"Logos\"" );
// Unexpected, but
working:
dataAdapter.Fill( dataSet, "Logos" );
return dataSet;
}
}
CREATE TABLE "Logos" (
"UniqueId" BIGINT DEFAULT 0 NOT NULL,
"Name" VARCHAR(80),
"Image" BLOB SUB_TYPE 2 SEGMENT SIZE 4096
);
"UniqueId" BIGINT DEFAULT 0 NOT NULL,
"Name" VARCHAR(80),
"Image" BLOB SUB_TYPE 2 SEGMENT SIZE 4096
);
Thanks Chris
----- Original Message -----
From: "Carlos Guzmán Álvarez" <[EMAIL PROTECTED]>
To: "For users and developers of the Firebird .NET
providers" <[email protected]>
Sent: Monday, August 28, 2006 7:11 PM
Subject: Re: [Firebird-net-provider] Crystal Report
with ADO.Net 2.0, how to get data in the report?
Hello:
>
> dataAdapter.Fill( dataSet );
>
Try:
dataAdapter.Fill( dataSet, DATATABLE_NAME );
--
Carlos Guzmán Álvarez
Vigo-Spain
-------------------------------------------------------------------------
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
__________ NOD32 1.1729 (20060828) Information __________
Diese E-Mail wurde vom NOD32 antivirus system geprüft
http://www.nod32.com
>
> dataAdapter.Fill( dataSet );
>
Try:
dataAdapter.Fill( dataSet, DATATABLE_NAME );
--
Carlos Guzmán Álvarez
Vigo-Spain
-------------------------------------------------------------------------
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
__________ NOD32 1.1729 (20060828) Information __________
Diese E-Mail wurde vom NOD32 antivirus system geprüft
http://www.nod32.com
------------------------------------------------------------------------- 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
