使用C#链接MYSQL数据库的最简单例子

using System;
using System.Data;
using MySql.Data;
using MySql.Data.MySqlClient;

namespace ConsoleTest
{
    class Program
    {
        static void Main(string[] args)
        {
            string theConnectionString = 
                "server=localhost;user=lqs2011;database=test;port=3306;password=******";
            MySqlConnection conn = new MySqlConnection(theConnectionString);
            conn.Open();
            if (conn.State == ConnectionState.Open)
                Console.WriteLine("Database is opened!");
        }
    }
}

MYSQL的链接字符串非常简单。