C#: Connecting to mysql database

Dear John,

First of all the connection string will be :

con="Data Source=datasourcename; uid=root; pwd=12345;database=db1";

here password could be your desired text but user id is by default root in mysql.

Then you have to download a DLL named as MySql.Data.dll. It has the class and methods like System.data.SqlClients DLL. So you can use it easily.

here is the link on how to connect

http://www.c-sharpcorner.com/UploadFile/8af3e0/connecting-to-mysql-using-C-Sharp-net/

here is the link on populating the grid ( you can look at the code and use it similar for listview)

http://www.c-sharpcorner.com/UploadFile/65fc13/linq-with-mysql-database-in-visual-studio-2010/