C#连接MySql数据库的方法

 用MySQLDriverCS连接MySQL数据库

    先下载和安装MySQLDriverCS，地址：

    http://sourceforge.net/projects/mysqldrivercs/

    在安装文件夹下面找到MySQLDriver.dll，然后将MySQLDriver.dll添加引用到项目中

    注：我下载的是版本是 MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe

using System;
    using System.Collections.Generic;
    using System.ComponentModel;
    using System.Data;
    using System.Data.Odbc;
    using System.Drawing;
    using System.Linq;
    using System.Text;
    using System.Windows.Forms;
    using MySQLDriverCS;
    namespace mysql
    {
        public partial class Form1 : Form
        {
            public Form1()
            {
                InitializeComponent();
            }
 
            private void Form1_Load(object sender, EventArgs e)
            {
 
            MySQLConnection conn = null;
            conn = new MySQLConnection(new MySQLConnectionString("localhost", "crm", "root", "qaz").AsString);
   
            conn.Open();
            //以下两行很重要，不然中文显示为乱码
            MySQLCommand commn = new MySQLCommand("set names gb2312", conn);
            commn.ExecuteNonQuery();
 
            string sql = "select * from exchange ";
            MySQLDataAdapter mda = new MySQLDataAdapter(sql, conn);
 
            DataSet ds = new DataSet();
            mda.Fill(ds, "table1");
 
           DataGridView1.DataSource = ds.Tables["table1"];
            conn.Close();
            }
        }
    }