firebird-net-provider

[Firebird-net-provider] cant load the data on Delphi8 using FbDataAdapter...

[benny <be...@ch...>]

Hi,
 =20
     Anyone who installed the FirebirdNETProvider1.5.1-NET1.1, tried on =
Delphi8 ASP.Net Web Application? As I used the FbConnection,=20
FbCommand, FbDataAdapter and Dataset but I cant load the data on the =
Datagrid.=20
On the other hand, I can try successful on using the Borland Data =
Provider: BdpConnection,   BdpDataAdapter, BdpCommand and DataSet.
Here I discovered the differences FbDataAdapter and BdpDataAdapter =
properties, where I found BdpDataAdapter have property:- Live Data that =
consist of Dataset=20
that I assigned the DataSet there ... When I use the Datagrid I am able =
to set DataSet to Datagrid's datasource.

But for FbDataAdapter I din see the property of Dataset. I failed to =
load the table on the dataset....=20
Anyone try successfully could tell me any mistake I made??


I am currently using Delphi8 professional, Firebird1.5 and =
FirebirdNETProvider1.5.1-NET1.1 [where I only add the =
FirebirdSql.Data.Firebird assembly on Delphi]

TIA=20

regards,

benny ;)

Re: [Firebird-net-provider] cant load the data on Delphi8 using FbDataAdapter...

[<car...@te...>]

Hello:

>      Anyone who installed the FirebirdNETProvider1.5.1-NET1.1, tried on 
> Delphi8 ASP.Net Web Application? As I used the FbConnection,
> FbCommand, FbDataAdapter and Dataset but I cant load the data on the 
> Datagrid. 

But you can't load the data at design time or at runtime ??

> On the other hand, I can try successful on using the Borland Data 
> Provider: BdpConnection,   BdpDataAdapter, BdpCommand and DataSet.
> Here I discovered the differences FbDataAdapter and 
> BdpDataAdapter properties, where I found BdpDataAdapter have property:- 
> Live Data that consist of Dataset
> that I assigned the DataSet there ... When I use the Datagrid I am able 
> to set DataSet to Datagrid's datasource.

That property is specific of the Borland Data Provider.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Re: cant load the data on Delphi8 using FbDataAdapter...

[benny <be...@ch...>]

> But you can't load the data at design time or at runtime ??

 Hi,

    Design time or run time also can't on using
FirebirdNETProvider1.5.1-NET1.1 on Delphi8 .net..
Anyway I could set reference on DataSet to FbDataAdapter? as In Borland Data
Provider I could see the tables and the related columns for that table after
doing so...  Or is FirebirdNetProvider do it on other way ? I seem cant
simply load the data on datagrid ..

but I do be able to load the data during design time using Borland Data
Provider on datagrid until what I have try so far ...

TIA

regards,

benny ;)

Re: [Firebird-net-provider] Re: cant load the data on Delphi8 using FbDataAdapter...

[<car...@te...>]

Hello:

> but I do be able to load the data during design time using Borland Data
> Provider on datagrid until what I have try so far ...

Don't see why, as i tell in my latest email it's a specific feature of 
the Borland Data Provider, maybe i'm wrong but if you try with SqlClient 
you will be not able to see the data at desing time either.


How are you assigning the DataSet to the DataGrid ?? and how are you 
doing the Fill of the DataSet ??

You can review one of the ASP.NET samples (the VB.NET one) in the 1.5 
packages that uses a datagrid for show data.






--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

[Firebird-net-provider] Re: cant load the data on Delphi8 using FbDataAdapter...

[benny <be...@ch...>]

> Don't see why, as i tell in my latest email it's a specific feature of
> the Borland Data Provider, maybe i'm wrong but if you try with SqlClient
> you will be not able to see the data at desing time either.

> How are you assigning the DataSet to the DataGrid ?? and how are you
> doing the Fill of the DataSet ??

> You can review one of the ASP.NET samples (the VB.NET one) in the 1.5
> packages that uses a datagrid for show data.

Hi,

   I might found the clue... I think at least I have to do the tablemappings
between the source table (fbcommand)  and dataset table(dataset) is it?
But unfortunely I got error :- Object reference not set to an instance of an
object ... why ?
As if I cant set references on the Dataset, I would get empty dataset that I
can't use datagrid's datasource to reference on it. By doing so, I can't
even fill the
column in Datagrids according to the Data Fields [that exist after assigning
the non-empty dataset].

TIA

regards,

benny ;)

Re: [Firebird-net-provider] Re: cant load the data on Delphi8 using FbDataAdapter...

[<car...@te...>]

Hello:

>    I might found the clue... I think at least I have to do the tablemappings
> between the source table (fbcommand)  and dataset table(dataset) is it?
> But unfortunely I got error :- Object reference not set to an instance of an
> object ... why ?

Do you mean at design time ?? If yes, maybe i'm wrong but seems that 
borland and ms wizards doesn't support "custom" data providers. You can 
do it manually.




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain