DataView and TDBGrid

Thread View: borland.public.delphi.database.dotnet

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Marco Caspers Sat, 19 May 2007 11:49

#38

Author: Marco Caspers
Date: Sat, 19 May 2007 11:49

18 lines
1637 bytes

I'm currently having an issue where i am using a MySQL database over an
internet connection with very low bandwidth.
Using a middletier i get data tables from the database, convert them to
xml, compress the xml and send that over the line.
This works well, and i gain approx a factor 10 in speed.
But still, whenever a search needs to be done data needs to be sent
back and forth.
This can be eliminated by using a DataView on the clientside.

I do know how to bind an entire DataTable to a TDBGrid (TDatasource
actually) using AdoNetConnector, but i haven't found anything on how to
do the same with a DataView, the AdoNetConnector doesn't allow for
this, and you can't use the Table property of the DataView because that
points back to the entire database, and not the resultset.

So if anyone knows how to solve this puzzle please help!

--

Re: DataView and TDBGrid

#39

Author: Marco Caspers
Date: Mon, 21 May 2007 05:19

13 lines
1070 bytes

Marco Caspers wrote:

<snip>
> I do know how to bind an entire DataTable to a TDBGrid (TDatasource
> actually) using AdoNetConnector, but i haven't found anything on how
> to do the same with a DataView, the AdoNetConnector doesn't allow for
> this, 

ok, found out that a TListConnector does the trick nicely.



--

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads