Visual Basic 6.0 cara koneksi database


Menggunakan Microsoft Acces format 2002/2003
Tools = Adodc dan Data Grid
- Klik kanan Adodc => Adodc properties
- (Property pages) => General => Use connection string => build
- (Data link properties) => provider => Microsoft jet 4.0 OLE DB Provider => Next
- (Data link properties) => connection => (select or enter a database name) => “pilih database yg dibuat”
- Test Connection => oke => apply => oke
- (Property pages) => RecordSource => (type = 2-adCmdTable).
(tabe or stored procedure name = tbbarang atau table yg tadi dibuat. => apply => oke
- Klik Data Grid = pada properties “DataSource = Adodc1”
- Klik kanan Data Grid => Retrieve Fields => Yes
-
selesai Visual Basic 6.0 cara koneksi database
Previous
Next Post »
Thanks for your comment