Connecting C# Visual Studio to MySQL Database

1. Download and install mysql .net connector http://dev.mysql.com/downloads/connector/net/
2. Add mysql .net on your reference.
    > at Visual Studio. Solution Explorer. Right Click Reference >> Add Reference
    > Search MySQL. Choose MySQL.Data
3. On your code:
    Sample:

    MySqlConnection myConnection = new MySqlConnection();
    MySqlCommand myCommand = new MySqlCommand();

    private string cs = "user id=root;password=;server='localhost';database=water_db; Convert Zero                                         Datetime=True;";
   
    myConnection.ConnectionString = cs;
    myConnection.Open();


// Smaple for Query - Save Data to Data Table
        DataTable tblResult = new DataTable();
        MySqlDataAdapter da = new MySqlDataAdapter("Select * from table", myConnection);
        da.Fill(tblResult);

// Sample for NonQuery
    myCommand.CommandText = "Insert Into etc.etc.etc.";
    myCommand.Connection = myConnection;
    myCommand.ExecuteNonQuery();

Simple?