| Author |
Message |
adhisyanda |
| Location: |
|
Post subject: masukin data ke var dari database
Posted: 26/Nov/2009 16:11
|
|
onIntermediate

Joined: 08-Nov-2009
Posts: 40
Status: Offline
|
|
kk,,
aq mu nanya gmn ya caranya masukin data dari database ke variable...
misalnya ada field nama d database..
mu aq masukin ke var yg berbentuk array..
gmn y caranya???
txh b4...
plz help me... |
|
|
| |
|
|
|
 |
|
|
Post subject: RE: masukin data ke var dari database
Posted: 26/Nov/2009 17:51
|
|
onMage

Joined: 06-Feb-2006
Posts: 2401
|
|
perlu diperjelas lagi var berbentuk array seperti apa yg dimaksud...?
apakah utk menampung value 1 field aja (nama)
atau utk menampung value semua field? |
_________________ Dude, if you don't understand the basics and just want to get someone else write the code for you, it means you really shouldn't study computer science. Find a different field.
http://delphiexpert.wordpress.com
|
| |
|
|
|
 |
adhisyanda |
| Location: |
|
Post subject: RE: masukin data ke var dari database
Posted: 27/Nov/2009 16:13
|
|
onIntermediate

Joined: 08-Nov-2009
Posts: 40
Status: Offline
|
|
misalnya nama var nya nama:array [1..50] of string;
aq mu ngambil datanya dari field nama..
jd smua yg ada di field nama entar aq tampung di var nama...
gtu kk... |
|
|
| |
|
|
|
 |
|
n3o_cybertech |
| Location: NgAyUkYoKarTo |
|
Post subject: RE: masukin data ke var dari database
Posted: 28/Nov/2009 23:30
|
|
onProfessional

Joined: 10-Feb-2007
Posts: 993
Location: NgAyUkYoKarTo
|
|
code : pascal var ArrNama: array of string; begin with Query1 do begin Close; SQL.Text('SELECT * FROM adm_pegawai'); Open; SetLength(ArrNama,RecordCount-1); while not Eof do ArrNama[RecNo] := FieldByName('nama').AsString; end; end;
kira2 bgitu sih,klo msih error ya coba perbaiki sndiri dlu ya... |
_________________
Delphi Rock!
Blog : MyBlog | Facebook : Add Me :)
|
| |
|
|
|
 |
adhisyanda |
| Location: |
|
Post subject: RE: masukin data ke var dari database
Posted: 29/Nov/2009 09:54
|
|
onIntermediate

Joined: 08-Nov-2009
Posts: 40
Status: Offline
|
|
kk,,
qo wkt aq run malah form nya g mau keluar sama skali??
awal nya ada error tp dah aq perbaiki...
tp ttp g jln..
conection nya aq pake ado DB nya aq pke mysql
procedure TForm1.FormActivate(Sender: TObject);
var
i:integer;
begin
n:=1;
with ADOQuery1 do
begin
SetLength(Nama,RecordCount-1);
while not Eof do
begin
Nama[RecNo] := FieldByName('user').AsString;
inc(n);
end;
end;
end;
procedure TForm1.Button1Click(Sender: TObject);
var i:integer;
begin
for i:=1 to n do
begin
StringGrid1.Cells[1,i]:=nama[i];
end;
end;
var nama nya aq pake sbg var global.
plz help me kk... |
|
|
| |
|
|
|
 |
heriy4nt0 |
| Location: |
|
Post subject: RE: masukin data ke var dari database
Posted: 29/Nov/2009 13:15
|
|
onKnowledgeable

Joined: 25-Jul-2008
Posts: 145
Status: Offline
|
|
di dalam looping :
Code:
while not eof do
begin
.........
Next; //---------> tambahkan next di baris terakhir sebelum keluar looping while
end;
n = 1?? ..array dynamic dimulai dari 0 jadi n:=0; |
|
|
| |
|
|
|
 |
adhisyanda |
| Location: |
|
Post subject: RE: masukin data ke var dari database
Posted: 29/Nov/2009 13:19
|
|
onIntermediate

Joined: 08-Nov-2009
Posts: 40
Status: Offline
|
|
malah jd error kk,,,,,
gmn dung??? |
|
|
| |
|
|
|
 |
adhisyanda |
| Location: |
|
Post subject: RE: masukin data ke var dari database
Posted: 29/Nov/2009 13:26
|
|
onIntermediate

Joined: 08-Nov-2009
Posts: 40
Status: Offline
|
|
sry doubl post..
error messagenya "raised exception class ...."
plz help me kk expertise.... |
|
|
| |
|
|
|
 |
heriy4nt0 |
| Location: |
|
Post subject: RE: masukin data ke var dari database
Posted: 29/Nov/2009 13:51
|
|
onKnowledgeable

Joined: 25-Jul-2008
Posts: 145
Status: Offline
|
|
procedure TForm1.FormActivate(Sender: TObject);--------->>gunakan OnShow (jangan OnActive)
var
i:integer;
begin
n:=1;----------------->>seharusnya n=0
with ADOQuery1 do
begin
SetLength(Nama,RecordCount);-->recordcount tidak perlu dikurang 1
while not Eof do
begin
Nama[n] := FieldByName('user').AsString;-->>bukan nama[Recno]
inc(n);
next; --->> tambahkan next
end;
end;
end;
procedure TForm1.Button1Click(Sender: TObject);
var i:integer;
begin
StringGrid.rowcount := n+1;
for i:=0 to n do
begin
StringGrid1.Cells[1,i+1]:=nama[i];
end;
end; |
|
|
| |
|
|
|
 |
adhisyanda |
| Location: |
|
Post subject: RE: masukin data ke var dari database
Posted: 29/Nov/2009 14:10
|
|
onIntermediate

Joined: 08-Nov-2009
Posts: 40
Status: Offline
|
|
msh ttp g bisa kk...
error report nya msh ttp kaya yg td....
 |
|
|
| |
|
|
|
 |
heriy4nt0 |
| Location: |
|
Post subject: RE: masukin data ke var dari database
Posted: 29/Nov/2009 15:56
|
|
onKnowledgeable

Joined: 25-Jul-2008
Posts: 145
Status: Offline
|
|
di baris dan di procedure mana error nya ?? DEBUG programnya (gunakan Breakpoint dan F untuk mengetaui errornya dibagian mana, sy tidak dpt membantu tanpa informasi ini. |
|
|
| |
|
|
|
 |
|
n3o_cybertech |
| Location: NgAyUkYoKarTo |
|
Post subject: RE: masukin data ke var dari database
Posted: 29/Nov/2009 19:44
|
|
onProfessional

Joined: 10-Feb-2007
Posts: 993
Location: NgAyUkYoKarTo
|
|
code : pascal procedure TForm1.Button1Click(Sender: TObject); var arrNama: array of string; i: integer; begin with Q1 do begin Close; SQL.Text := 'SELECT nama FROM anggota'; Open; SetLength(arrNama,Q1.RecordCount); while not Eof do begin arrNama[RecNo - 1] := FieldByName('nama').AsString; Next; end; end; with ListBox1.Items do begin Clear; for i := Low(arrNama) to high(arrNama) do Add(arrNama[i]); end; end;
klo Query itu ada di DataModule,mendingan load DataModule secara runtime aja pas event OnCreate form utama karena form utama secara default akan di-create terlebih dahulu daripada DataModule. Semoga membantu  |
_________________
Delphi Rock!
Blog : MyBlog | Facebook : Add Me :)
|
| |
|
|
|
 |
adhisyanda |
| Location: |
|
Post subject: RE: masukin data ke var dari database
Posted: 01/Dec/2009 19:17
|
|
onIntermediate

Joined: 08-Nov-2009
Posts: 40
Status: Offline
|
|
dah aq akalin kk...
ternyata kesalahnya ada di penggunaan array dinakic nya...
jd aq coba pake array yg statis ternyata jalan..
thx ya atas bantuannya... |
|
|
| |
|
|
|
 |
|
|