Arsip: Menampilkan progress-bar saat fetch data besar

more 17 years ago
DelphiExpert
beberapa rekan banyak yg menanyakan, ada jg yg nanya via YM...
iseng2 daku explore event2 milik TADOQuery --> TADOConnection atau CodeGear menyebutnya DBGo pd Delphi2007 (BDS juga kali' ya)...
utk menampilkan progress-bar, anda bisa memanfaatkan event OnFetchProgress milik TADOQuery...
unit Unit1;
interface
uses
Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
Dialogs, DB, ADODB, StdCtrls, ComCtrls;
type
TForm1 = class(TForm)
ADOConnection1: TADOConnection;
ADOQuery1: TADOQuery;
ProgressBar1: TProgressBar;
Label1: TLabel;
procedure ADOQuery1FetchProgress(DataSet: TCustomADODataSet; Progress,
MaxProgress: Integer; var EventStatus: TEventStatus);
procedure ADOQuery1FetchComplete(DataSet: TCustomADODataSet;
const Error: Error; var EventStatus: TEventStatus);
private
{ Private declarations }
public
{ Public declarations }
end;
var
Form1: TForm1;
implementation
{$R *.dfm}
procedure TForm1.ADOQuery1FetchComplete(DataSet: TCustomADODataSet;
const Error: Error; var EventStatus: TEventStatus);
begin
if EventStatus <> esOK then
MessageDlg(Format('Source: %s%sDesc: %s', ), mtError, [mbOK], 0);
Close;
end;
procedure TForm1.ADOQuery1FetchProgress(DataSet: TCustomADODataSet; Progress,
MaxProgress: Integer; var EventStatus: TEventStatus);
begin
if EventStatus = esOK then
begin
ProgressBar1.Max:= MaxProgress;
ProgressBar1.Position:= Progress;
end;
Application.ProcessMessages;
end;
end.

more 17 years ago
zieborg
wah.., sering kutak-kutik ADO ga nyadar ada event ini nih...
mesti explore lagi dah, kamsia..kamsia.. :D

more 17 years ago
deLogic
btw.. bagaimana efek dari penggunaan event onFetchProgress atau sejenis.. apakah ada penurunan performance (performance penalty)? dan seberapa besar?
saya belum mencoba hal ini di ADO, tapi hal serupa juga disediakan oleh komponen middleware yg sedag daku pake, dan terdapat penurunan performance, walaupun tidak besar.
Tapi saya rasa untuk data besar, jika penalty tersebut cukup kecil, tidak mengapa, karena tujuannya lebih ke 'visual feedback'.

more 17 years ago
EkoIndri
Kalau saya sih dah tahu sejak lama......
tapi hati2 dalam penggunaan onfetchProgress
setahu saya untuk D7 hanya bisa digunakan pada ADODataset.
Kemudian untuk mendapatkan progress yang bagus, dataset jangan langsung dikoneksikan dengan Grid, lebih baik saat fetching di disconect, setelah fetching selesai baru dikoneksikan lagi datasetnya ke dbgrid.
Untuk mendapatkan performance yang bagus saat fetching, silahkan anda atur executeoptions-nya agar didapatkan fetching yang smooth

more 17 years ago
DelphiExpert
benar yg dikatakan sodara @EkoIndri...
TDataset telah menyediakan DisableControls & EnableControls utk men-disables data display in data-aware controls associated with the dataset.
tanpa perlu secara fisik men-disconnect dataset ke data-aware (DBGrid, DBEdit dll).

more 17 years ago
Kecret
Waduhhhh..... Kalo saya sich BLUM tau sejak lama...... :mrgreen:
tips2 yg bagusss...... huebat pisan oeyyyy..... tararengyu....
more ...
- Pages:
- 1
reply |
Report Obsolete
AI Forward

🚀 We're thrilled to partner with Alibaba Cloud for "AI Forward - Alibaba Cloud Global Developer Summit 2025" in Jakarta! Join us and explore the future of AI. Register now:
https://int.alibabacloud.com/m/1000400772/
#AlibabaCloud #DeveloperSummit #Jakarta #AIFORWARD
Last Articles
Last Topic
- PascalTalk #6: (Podcast) Kuliah IT di luar negeri, susah gak sih?
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #5: UX: Research, Design and Engineer
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #4: Obrolan Ringan Seputar IT
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #2: Membuat Sendiri SMART HOME
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #3: RADically Fast and Easy Mobile Apps Development with Delphi
by LuriDarmawan in Tutorial & Community Project more 4 years ago - PascalTalk #1: Pemanfaatan Artificial Intelligence di Masa Covid-19
by LuriDarmawan in Tutorial & Community Project more 4 years ago - Tempat Latihan Posting
by LuriDarmawan in OOT more 5 years ago - Archive
- Looping lagi...
by idhiel in Hal umum tentang Pascal Indonesia more 12 years ago - [ask] koneksi ke ODBC user Dsn saat runtime dengan ado
by halimanh in FireBird more 12 years ago - Validasi menggunakan data tanggal
by mas_kofa in Hal umum tentang Pascal Indonesia more 12 years ago
Random Topic
- install shield gagal
by am4tiranDelphian in Paradox more 16 years ago - [ASK] error saat coba send email dengan Indy SMTP
by shindo in Hal umum tentang Pascal Indonesia more 17 years ago - proteksi agar file jlan 1x
by Cip_rud in Lain-lain more 16 years ago - [ask] tombol, mikrokontroller, assembler dgn Delphi
by cimprodot05 in Network, Files, I/O & System more 13 years ago - device driver
by odomsangjelemagoblog in Tip n Trik Pemrograman more 18 years ago - SysTray
by doniking in Tip n Trik Pemrograman more 17 years ago - link komponen tdotmatrix delphi7 free
by boediman in OOT more 17 years ago - Isi Edit Box tidak berubah
by onsir in Hal umum tentang Pascal Indonesia more 18 years ago - Solusi Ya Nih ..?
by umarbakri in Network, Files, I/O & System more 17 years ago - Pre Order Jaket susulan
by yayaretina in Tutorial & Community Project more 15 years ago