.NET连接MySQL数据库方法

添加MySQLDriverCS.dll的引用，下载地址：http://downloads.sourceforge.net/mysqldrivercs/MySQLDriverCS-n-EasyQueryTools-4.0.1-DotNet2.0.exe

using System;
using System.Web.UI.WebControls;
using System.Data;
using MySQLDriverCS;

public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        MySQLConnection conn = null;
        conn = new MySQLConnection(new MySQLConnectionString("Localhost", "CNPCEdit", "root", "").AsString);
        conn.Open();
        MySQLCommand commn = new MySQLCommand("set names gb2312", conn);
        commn.ExecuteNonQuery();
        string sql = "select * from Checklist where family='Apiaceae'";
        MySQLDataAdapter mda = new MySQLDataAdapter(sql, conn);
        DataSet ds = new DataSet();
        mda.Fill(ds, "Checklist");
        grdFamily.DataSource = ds;
        grdFamily.DataBind();
        conn.Close();
    }
    protected void grdFamily_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        grdFamily.PageIndex = e.NewPageIndex;
    }
}