[Tangela]

I am trying to connect to my database I made in mysql workbench and I keep getting this error:
Unknown database 'sample'

I do not believe it has to do with my code i just think it has to do with mysql workbench. I am not sure if my server for mysql is running. But when I check test connection it tell me that its ok and i don't get errors. I also ran the MySQL Server Instance Config Wizard and i got no problems for it. Here is my code:

Program.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;

namespace Connect_to_MySQL_Database
{
    class Program
    {
        static void Main(string[] args)
        {
            string config = "Server=localhost;Port=3306;Database=sample;Uid=root;password=root;";
            MySqlConnection con = new MySqlConnection(config);
            MySqlCommand command = con.CreateCommand();
            Console.Write("Hello World");
            command.CommandText = "Insert into user (username,password) values('felice','roller')";
            con.Open();
            command.ExecuteNonQuery();
            con.Close();
        }
    }
}

[Mitja Bonca]

You code is wrong. Change it to the code that will look like this:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace Okt10DBAccess
{
    class Program
    {
        static void Main(string[] args)
        {
            string connString = @"Server=localhost;Port=3306;Database=sample;Uid=root;password=root;";
            using (SqlConnection sqlConn = new SqlConnection(connString))
            {
                string queryString = String.Format(@"Insert into user (username,password) values(@userName, @password)");
                using (SqlCommand cmd = new SqlCommand(queryString, sqlConn))
                {
                    cmd.Parameters.Add("@userName", SqlDbType.VarChar, 50).Value = "felice";
                    cmd.Parameters.Add("@password", SqlDbType.VarChar, 50).Value = "roller";
                    sqlConn.Open();
                    try
                    {
                        cmd.ExecuteNonQuery();
                    }
                    catch { }
                    finally
                    {
                        sqlConn.Close();
                    }
                }
            }
        }
    }
}

[Tangela]

Hey I tried your code and I got a to the open function and I got a new error:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)