How to connect MySQL database in C#?

Hi,

You can implement the below way to connect with mySQL db.

1) Add namespaces in your page
i)using MySql.Data;
ii)using MySql.Data.MySqlClient;

2) get connection string or create in format

String ConnectionString= "server=127.0.0.1;uid=test;pwd=test@123;database=test;";

3) In the class from where you want to connect to database write below Line of code,

Public Class Test
{

// appilcation logic goes here

try
{

// Application logic goes here

MySqlConnection Myconn = new MySqlConnection();
Myconn.ConnectionString = ConnectionString;
Myconn.Open();
}
catch (MySqlException ex)
{
MessageBox.Show(ex.Message);
}

finally
{
if(Myconn.State==ConnectionState.Open)
{
Myconn.Close();
}

}

}


// if you want to pass some command then follow below steps

// create command as below after opening the connection in MyConn.Open()statement.

MySqlCommand cmd=MyConn.CreateCommand();
cmd.CommandText="Select * FROM Employee";
MySqlDataAdapter adpt=new MySqlDataAdapter(cmd);
Dataset ds=new Dataset();
adpt.Fill(ds);
//find the dataset with any control or manipulate accordingly

Hope you understand the concept now..

First of all you need Connector/Net
http://dev.mysql.com/downloads/connector/net/[^]

Moreover you should read MySQL Connector/Net Developer Guide
http://dev.mysql.com/doc/connector-net/en/index.html[^]

you can install MySql.Data via NuGet
http://www.nuget.org/packages/MySql.Data/[^]
to install Nuget check
http://docs.nuget.org/docs/start-here/installing-nuget[^]
to install package via dialog or console check
http://docs.nuget.org/docs/start-here/managing-nuget-packages-using-the-dialog[^]
http://docs.nuget.org/docs/start-here/using-the-package-manager-console[^]