Skip to main content

aplikasi database dengan mysql di vb 6

langsung ja bro an sis yang lg bingung mungkin cari tutorial bkin apilkasi database dengan mysql di vb 6. disini aplikasi yang bakal dibuat adalah apilkasi desktop menggunakan VB 6 tetapi menggunakan database dari mysql. Anda bisa menggunakan Xampp atau Appserv sebagai penyedia layanan data. download nya bisa cari di mbah gugel...
ok langsung siapain ja sebagai berikut :
1. download driver ODBC mysql untuk Vb 6 disini (sory ni link lokal bro)UPDATE
2. klo dah di download langsung ja instal. trus ikuti petunjuk dibwah ini:
  buka control panel -> System/security ->administratif tools -> data source ODBC. ni screen sootnya

3. trus klik add (tambah user  data source baru)
   lalu bakal muncul menu Create new data source cari trus pilih mysql odbc 3.51 driver
   klik finish.
   jadinya kaya gini :





Isi deh parameternya..kurang lebih kaya gambar diatas... password itu yang digunakan di xampp atau di appserv kamu...klo ga di password ya kosongin ajah....klik ok beres deh soal driver...

4. ok sekarang kita masuk dlu ke phpmyadmin di browser buat database baru... ni saya contoh aja yang sederhana :
5. langkah selanjutnya kita mulai deh sedikit koding di vb 6 ... yuk Ke Te Ka Pe
6. klo dah kebuka vb 6 nya kita buat dlu projek baru yang standard exe, trus klo bisa di save dlu..
7. trus pilih data environment


8. setelah itu masuk kemenu ini...ikuti saja gambarnya :


  klik kanan di Connection1 trus pilih properties... trus pilih Microsoft OLE DB provider for ODBC driver

.. klik next
..trus da menu baru lagi isi dengan sbb :

pilih  use data source name...sesuai dengan nama pas kita awal tadi bikin koneksi dari driver odbc di administrative tools... (klo disini namanya myodbc dengan nama database test... jika sudah klik test connectiontion buat memastikan koneksi lancar. lalu Ok.

9. setelah itu pada connection1 tadi klik kanan lagi... tapi kali ini pilih add command

muncul command baru...
10. setelah itu klik kanan lagi pada Command 1...lalu pilih properties... muncullah menu baru... trus ikuti saja gambarnya :


..di source of data pilih  database object-nya -> table.... dan pada object name adalah nama tabel yang kita    buat di database mysql tadi... klo disini namanya note..
.. trus pilih tab advanced di menu pilihan locke type pilih no 3 Optimistic.
.. trus ya udah klik ok....
.. eng ing eng kaya gini jadinya

11. nah gambar diatas sebenarnya pekerjaan kita tentang pengaturan data udah beres...soalnya cuma tinggal finishing code aja..
12. caranya gini nih klik kiri satu per satu item di bawah command 1 ke lembar kerja kita di vb 6 kaya gini nih jadinya :
..kalo udah kaya gini tinggal atur ajah semau kita tata letaknya... jika sudah ada data di database coba aja jalankan hasil yang sudah kita buat ini, kaya gini ni...

Penambahan segala rupanya kita lanjutkan setelah yang satu ini... wkwk to be continue...

sabar ye



nb: jikalau di dalam visual basic 6 kalian ndak ada data environment...wah klo kaya gitu berarti VB 6 anda ndak terinstal sempurna atau OS yang anda gunakan juga bermasalah.. coba install ulang vb 6 anda atau os anda..jika masih saja,... cari source lain dari installan/mentahan Vb 6 anda yg lain, kemungkinan corrupted pada installan vb 6 lama anda...
Labels:

Comments

Post a Comment

Popular posts from this blog

Membuat website dengan CodeIgniter Part1

Langsung aja saya jabarkan kebutuhan yg akan di pakai nanti untuk membuat sebuah website d ari framework codeigniter... pertama.. ya tentu saja source dari codeigniter-nya... bisa pake yg terbaru atau 2.0 ++ disini kedua.. database -nya bisa menggunakan MySql yg udah di bundle ke dalam Xampp disini ketiga (optional) Editor teks.... pake notepad oke... pake netbeans oke juga... Langkah selanjutnya adalah install terlebih dahulu xampp-nya jika sudah ada xamppnya, lanjut ke langkah selanjutnya, lalu kemudian extract source Codeigniter di htdocs xampp. berikut susunan direktori Codeigniter root dir....         .../application                   .../cache                   .../config                   .../controllers      ...
Post a Comment
Read more

A history of Einstein

Around 1886 Albert Einstein began his school career in Munich. As well as his violin lessons, which he had from age six to age thirteen, he also had religious education at home where he was taught Judaism. Two years later he entered the Luitpold Gymnasium and after this his religious education was given at school. He studied mathematics, in particular the calculus, beginning around 1891.  In 1894 Einstein's family moved to Milan but Einstein remained in Munich. In 1895 Einstein failed an examination that would have allowed him to study for a diploma as an electrical engineer at the Eidgenössische Technische Hochschule in Zurich. Einstein renounced German citizenship in 1896 and was to be stateless for a number of years. He did not even apply for Swiss citizenship until 1899, citizenship being granted in 1901.  Following the failing of the entrance exam to the ETH, Einstein attended secondary school at Aarau planning to use this route to enter the ETH in Zurich. While at Aarau he wr...
Post a Comment
Read more

A history of Michael Jackson

Okay Here i want post with history of King of the POP in world. For remember story of Jackson and his carier in world. Hard to believe - this was Michael Jackson. He was born August 28, 1958 - one of 9 kids. His father reportedly nicknamed him "Big Nose".  Mike was born a cute African-American guy. "Normal", if you will, and very talented. Despite the current, sad stories about his lonely, sad childhood, Mike grew up surrounded by famous people and an adoring public. At age 5, Mike and his brothers were the amazing 'Jackson 5'. They played locally, then in New York and Philly. They were "discovered" by Gladys Knight and pianist Billy Taylor at the famous Apollo Theater in Harlem. By age 11, Mike was a Superstar. At age 13 he went solo and had his first #1 hit at 14 with "Ben" (a touching love song to a rat). Who knew he'd get addicted to plastic surgery, face accusations of child molestation and end up America's Most Famous Sidesh...
Post a Comment
Read more