jika di SQLSERVER anda bisa lakukan Query seperti ini :
execute "SELECT dbo.syscolumns.name, dbo.systypes.name AS Type,
dbo.syscolumns.length AS Length
FROM dbo.systypes RIGHT OUTER JOIN
dbo.syscolumns ON dbo.systypes.xtype =
dbo.syscolumns.xtype RIGHT OUTER JOIN
dbo.sysobjects ON dbo.syscolumns.id =
dbo.sysobjects.id
WHERE (dbo.sysobjects.name = '[NamaTabel]')
--- In [email protected], Rommy Zamanuddin
<[EMAIL PROTECTED]> wrote:
>
> misalkan :
>
> Database : Penjualan
> Table : Pelanggan
>
> Field Name Data Type Length
> No_Pelanggan Text 4
> Nm_Pelanggan Text 35
>
> Klo ingin menampilkan struktur data seperti diatas dari vb pake
ADO gimana ya ?
>
> Terima Kasih
>
> __________________________________________________
> Apakah Anda Yahoo!?
> Lelah menerima spam? Surat Yahoo! memiliki perlindungan terbaik
terhadap spam
> http://id.mail.yahoo.com
>
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-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/
