C#.NET连接mysql方法

一。 mysql.data.dll拷贝到bin下面并引用一下
using MySql.Data.MySqlClient;
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        string myConnectionString = "Database=test;Data Source=localhost;User Id=root;Password=admin";
        MySqlConnection mycn = new MySqlConnection(myConnectionString);
       
        try
        {
            mycn.Open();
            Response.Write("<mce:script type="text/javascript"><!--
alert('连接成功')
// --></mce:script>");
        }
        catch (Exception ex)
        {
            Response.Write("<mce:script type="text/javascript"><!--
alert(" ex.ToString() ")
// --></mce:script>");
        }
    }
}
也可以配置app.config (web.config):
<appSettings>
    <add key="Con" value="Provider=MySQLProv;Data Source=test;User Id=root;Password=admin;pooling=false;CharSet=utf8;port=3306"/>
</appSettings>
二。要添加对MySql.Data.dll的引用。
连接：
string connStr = "server=localhost;user id=root; password=; database=aa; pooling=false";//
连接字符串
以下为引用的内容：
MySqlConnection conn = new MySqlConnection( connStr );//构造数据库连接
try
{
conn.Open();//打开连接
MySqlCommand cmd = new MySqlCommand("select * from list",conn);//构造查询命令
this.DataGrid1.DataSource=cmd.ExecuteReader();//执行查询，返回一个DataReader，设置DataGrid1的数据源为该DataReader