Using MySQL with Visual Basic .Net

Before you use this code, here are my assumptions:
  1. You have background on database management system
  2. You know how to create a database in mysql
  3. You know how to add tables to the database
  4. You are familiar with Visual Basic .Net
Things needed/installed:
  1. MySQL Connector
  2. Microsoft Visual Basic Express 2008 (Since this is what I'm using right now. You can use Visual Basic Express 2005 or the full version included in the Microsoft Visual Studio Package)
  3. MySQL Editor (I'm using WAMP's phpMyAdmin)

Things to do:
  1. Create a database in MySQL with at least 1 table. I'm using the following in this sample:
Database Name: Contacts
Table Name: ContactInformation
Fields: Id (int, autoIncrement), Name (varchar(64)), ContactNumber (varchar(20))

Sample Contents:
Full Texts Id Name ContactNumber
Edit Delete 1 John Doe (yyy) yyy-yyyy
Edit Delete 2 Jane Doe (xxx) xxx-xxxx

Visual Basic .Net Code
  1. Create a new Visual Basic Windows Forms Application.
  2. Add a DataGridView to the form
  3. On the code view, overwrite the code with the following:
Imports System.Data.Odbc

Public Class Form1
Private cn As OdbcConnection
Private adp As OdbcDataAdapter
Private dt As DataTable

Private Sub Form1_Load(ByVal sender As System.Object, B
yVal e As System.EventArgs) Handles MyBase.Load
cn = New OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=Contacts; User=root;Password=;Option=3;")
Call cn.Open()
adp = New OdbcDataAdapter("select * from ContactInformation", cn)
dt = New DataTable()
Call adp.Fill(dt)
DataGridView1.DataSource = dt
End Sub
End Class


0 Responses to "Using MySQL with Visual Basic .Net"