Makasih mas, aku akan coba --- In [email protected], Andy Zazz <[EMAIL PROTECTED]> wrote: > > Maksudnya supaya bisa tampil VB..? kalo seperti gitu > bisa dengan berbagai cara khan..? salah satunya pake > adodc dan datagrid. > > 1. Buat koneksi dulu dengan adodc misalnya: > Adodc1.ConnectionString = > "Provider=Microsoft.Jet.OLEDB.4.0;Data > Source=C:\folderdata\db1.mdb;Persist Security > Info=False" > > (Asumsi data MDB-nya namanya db1.mdb dan terletak di > folder c:\folderdata\) > > 2. Arahin property datasource dari datagrid ke adodc > > 3. querynya simpen diproperti recordsourcenya adodc > misalnya: > Adodc1.RecordSource = "SELECT Tabel_CalMhs.NOTES, > Tabel_CalMhs.NMMHS, Sum(Tab_Perk.Nilai) AS Nilai, > Count(Tab_Ku_Mhs.Jur) AS Jur FROM Tab_Ku_Mhs INNER > JOIN (Tab_Perk INNER JOIN Tabel_CalMhs ON > Tab_Perk.Notes = Tabel_CalMhs.NOTES) ON > (Tab_Ku_Mhs.NOTES = Tab_Perk.Notes) AND > (Tab_Ku_Mhs.NOTES = Tab_Perk.Notes) GROUP BY > Tabel_CalMhs.NOTES, Tabel_CalMhs.NMMHS ORDER BY > Tabel_CalMhs.NOTES; > > 4. Terakhir refresh adodc-nya dengan > adodc1.refresh > > Seharusnya datanya tampil di datagrid-nya > > > --- Eddy Sulistyono <[EMAIL PROTECTED]> wrote: > > > kawan2 vb mania aku bisa minta tolong kalau ada yang > > tahu, bagai mana > > caranya untuk merubah query yang saya buat dengan > > Access 2000 bisa > > di baca dengan VB6. Contoh penulisan querinya > > seperti di bawah in: > > > > SELECT Tabel_CalMhs.NOTES, Tabel_CalMhs.NMMHS, Sum > > (Tab_Perk.Nilai) AS Nilai, Count(Tab_Ku_Mhs.Jur) AS > > Jur > > FROM Tab_Ku_Mhs INNER JOIN (Tab_Perk INNER JOIN > > Tabel_CalMhs > > ON Tab_Perk.Notes = Tabel_CalMhs.NOTES) ON > > (Tab_Ku_Mhs.NOTES > > = Tab_Perk.Notes) AND (Tab_Ku_Mhs.NOTES = > > Tab_Perk.Notes) > > GROUP BY Tabel_CalMhs.NOTES, Tabel_CalMhs.NMMHS > > ORDER BY Tabel_CalMhs.NOTES; > > > > Nah supaya bisa di baca VB6 bagaimana caranya? > > tolong banget kalau > > ada yang tau caranya > > > > > > > > > > > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com >
------------------------ Yahoo! Groups Sponsor --------------------~--> Something is new at Yahoo! Groups. Check out the enhanced email design. http://us.click.yahoo.com/SISQkA/gOaOAA/yQLSAA/zCsqlB/TM --------------------------------------------------------------------~-> Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Forum ini berkembang dengan pesat, jika anda memiliki dedikasi dan waktu, silahkan mengaplikasikan diri menjadi moderator. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-vb/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
