Article View: borland.public.delphi.database.dotnet
Article #38DataView and TDBGrid
From: Marco Caspers
Date: Sat, 19 May 2007 11:49
Date: Sat, 19 May 2007 11:49
18 lines
1637 bytes
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! --
Technical Details
Message-ID:
<464ee437$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!newshub.sdsu.edu!newscon04.news.prodigy.net!prodigy.net!news.linkpendium.com!news.linkpendium.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 1effe6,c83faf33df902a02,start X-Google-Attributes: gid1effe6,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Marco Caspers" <hexor@haxor.vaxor.com> Subject: DataView and TDBGrid Newsgroups: borland.public.delphi.database.dotnet User-Agent: XanaNews/1.18.1.6 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 NNTP-Posting-Host: 83.85.89.76 Message-ID: <464ee437$1@newsgroups.borland.com> Date: 19 May 2007 04:49:11 -0700 X-Trace: newsgroups.borland.com 1179575351 83.85.89.76 (19 May 2007 04:49:11 -0700) Lines: 19 Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!newshub.sdsu.edu!newscon04.news.prodigy.net!prodigy.net!news.linkpendium.com!news.linkpendium.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail