이게 C#으로 가야되냐? MySql로 가야되냐?

    using Mysql.Data.MysqlClient;

    string connStr = "Data Source=server;Database=dbname;User Id=user;Password=password";

    MySqlConnection conn = new MySqlConnection(connStr);

    string query = "select * from tablename";

    MySqlCommand cmd = new MySqlCommand(query);

    cmd.Connection = conn;

    conn.Open();

    MySqlDataReader reader = cmd.ExecuteReader();

    conn.Close();

[참조] http://kongpill.tistory.com/entry/c-MySql-connection-test