download mysql connector net for visual studio 2010

GetAllItems() function returns all items from database table,.

Initialize mysql connection using following code,Ĭonnection = new MySqlConnection(ConnectionString).

Source code of this sample is very straight forward.

Run sample and it should give you list of items in grid.You can update, insert or delete items from this list.

Change database user name and password in connection string as per your database instance.

Inside Solution Explorer, open App.Config file and change connection string so that it points to MySQL database that you created before.

Open sample solution file with visual studio.

Once MySQL connector is installed successfully on your computer, download sample from following link and extract it in some folder.

When you install connector make sure that you close Visual Studio before installing. Go to following link to download connector and install it. Net library to support MySQL database connectivity in.

For Visual Studio, you need to install MySQL Connector for.

Run it and it should create items table in inventorydb database. Open this file with MySQL Admin tool or copy paste sql syntax from this file into MySQL Admin tool. It contains items table structure and data.

Download MySQL script from following link.

Go to MySQL admin tool, and create a new database, call it inventorydb.

I am using phpMyAdmin which is a web interface.

MySQL database admin tool that allows you to create database and run sql statements.

MySQL database installed on your local machine or remote host.

I will also show you how you can update mysql database records using C#. This article shows you how you can connect to MySQL database using MySQL Connector for.

Download mysql connector net for visual studio 2010