download mysql connector net for visual studio 2010

I have two server running, so I used the port number to connect to the specific one. port: This is also optional, the port number for the server.This is optional, if your user doesn’t have any password, you don’t need this. password: The password of the user of the mysql database server.user id: The user of the mysql database server.Data Source: We have our database in our local machine, thus I have used “localhost”, if you have your DB at some other computer connected by LAN to your machine, you will put the IP address of that machine instead of localhost.Here, look at the connection string which as currently have 5 parts as follows MsgBox('Connection Error: ' & ex.Message.ToString) The code looks like the following dbconn = New MySqlConnection('Data Source=localhost user id=root password=demo port=3310 database=vb_mysql') We will open the connection to the DB in the load event of our form which now named as form1 by default. Okay, now we are going to make the connection. dbread is the one which will hold those data that we will fetch using query from DB.dbcomm is the MySqlCommand that will execute the query.sql is a string, which will actually hold our query.dbconn is the connection to the database.Here we are declaring 4 public objects that we will use. Now, just below Public Class Form1 write the followings Public dbconn As New MySqlConnection

This will allow us to use various types, methods and classes of the Connector. Now Double-Click on the form to bring the code editor.Ībove everything, write this Imports We are done with the database and form so far, lets start coding in the next part.

Download mysql connector net for visual studio 2010