or kalo hitung baris tinggal hitung recordset yang bakal jadi datasource nya .. SUM diganti COUNT(*)
----- Original Message -----
Sent: Friday, November 25, 2005 9:05 AM
Subject: Re: [Programmer-VB] hitung baris

kalo saya ngga pake ubound lbound untuk grid saya biasa grid langsung saya binding ke recordset terus saya buat prosedur untuk reload sub transaksi untuk memperbarui isi grid, dan untuk total transaksi yang ada di grid saya pake SQL state, misal :
with rs
      .open "SELECT SUM(Qty*Harga) AS TOTAL WHERE KodeTrans = '" & lblKodeTrans.Caption & "' GROUP BY KodeTrans, dst.............
if     .recordcount <= 0 Then
    lblTotal.Caption = 0
else
    lblTotalCaption = .fields("TOTAL")
end if
 
demikian sharing dari saya
----- Original Message -----
From: pupunk
Sent: Friday, November 25, 2005 8:49 AM
Subject: Re: [Programmer-VB] hitung baris

codingnya bgm ya mas ?

2005/11/24, Purwedi Kurniawan <[EMAIL PROTECTED]>:
> algoritmanya gini :
> lakukan looping u seluruh baris yg ada,
> didalam looping tadi, ambil nilai barang dibaris itu dan tambahkan dg nilai
> sebelumnya
>
> On 11/22/05, pupunk <[EMAIL PROTECTED]> wrote:
> > temen2x, bgm cara menghitung juml barang secara keseluruhan ? sy pakai
> > dbgrid & sy buat baris 1 s/d 10. nah bgm cara menghitung total juml
> > barang secara keseluruhan tsb dari baris 1 s/d 10.
> > sebelumnya sy ucapkan terimakasih.
> >
> > salam,
> > pupunk
> >
>
>
> Untuk keluar dari millis ini, kirim email kosong ke:
> [EMAIL PROTECTED]
>
>
>
>
>
> SPONSORED LINKS
> Programmer Indonesia Basic programming language
> Computer programming languages Programming languages Java programming
> language
>
> ________________________________
> YAHOO! GROUPS LINKS
>
>  Visit your group "Programmer-VB" on the web.
>
>  To unsubscribe from this group, send an email to:
>  [EMAIL PROTECTED]
>
>  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>  To unsubscribe from this group, send an email to:
>  [EMAIL PROTECTED]
>
>  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>  Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
> ________________________________
>


Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]





YAHOO! GROUPS LINKS




Kirim email ke