C#连接MySql

下载MySql连接Dll文件下载http://dev.mysql.com/downloads/connector/net/

下载完成后安装，安装完成后在引用中添加，浏览位置参考C:\Program Files\MySQL\MySQL Connector Net 6.7.4\Assemblies

添加引用

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

连接MySql

//初始化连接字符串server=localhost;User Id=用户名;password=密码;Database=数据库
string strConn = "server=localhost;User Id=test;password=test123;Database=test";
//初始化连接
using (MySqlConnection myConn = new MySqlConnection(strConn))
{
    //打开连接
    myConn.Open();
    using (MySqlCommand myCmd = myConn.CreateCommand())
    {
        //Insert命令
        myCmd.CommandText = "insert into user(UserName,PassWord) values(@UserName,@PassWord)";
        //实例化MySqlParameter对象，为@UserName等建立映射关系  
        MySqlParameter parmUserName = new MySqlParameter("@UserName", this.txtUserName.Text);
        MySqlParameter parmPassWord = new MySqlParameter("@PassWord", this.txtPwd.Text);
        //将映射关系添加到cmd中  
        myCmd.Parameters.Add(parmUserName);
        myCmd.Parameters.Add(parmPassWord);
        //执行命令
        if (myCmd.ExecuteNonQuery() == 1)
        {
            MessageBox.Show("数据插入成功！");
        }
    }
}