In this article I’ll show you how to connect MySQL to Visual Studio 2010, where we download a connector that connects your IDE to MySQL.

Requirements:

  1. DotConnect for MySQL
  2. Wamp or Xamp Server
  3. Visual Studio

Step 1: Open Visual Studio, go to Tools, Extension Manager and search for Dot. Connect for MySQL, download and install it on your PC.

Step 2: Download Wamp server from here:

wampserver

Step 3: Install it on your PC and run wamp server from the notification bar. Once your wamp server goes green, Open your browser and type http://localhost/phpmyadmin/. You will see a login panel open up, now type Username as root and leave the Password blank.

php myadmin

  • Once you complete that, you will enter into the phpMyAdmin, where we create our database and a table.

    database

  • Under Database you will see you database. Click on your database and you will enter into the Create table panel.

    create table

  • Fill you table with columns:

    fill table

  • Fill Data into your table

    To insert data into table you have to click on Insert tab on the top part of phpMyAdmin.

    insert

    options

Step 4: Open Visual Studio and in the Server Explorer Open Add New Connection.

add connection

After pressing OK, you will see your MySQL database in the Server Explorer.

server explorer

You can use its connection string to bind data to any control.

properties

Hope you liked it. Thank you for reading. Have a good day.