首先下载MySql.Data.dll
在C#中添加该引用,然后在代码前添加using MySql.Data.MySqlClient;
之后就可以访问操作mysql数据库了
示例代码:
mysqltest ()
{
string mysqlstr="Database=datatest;Data Source='localhost';User=root;Password=1234;port=3306;CharSet=utf8;"; //设置CharSet是为了正常插入汉字
MySqlConnection mysql = new MySqlConnection(mysqlstr);
string sqlinsert = "insert into student values('王小小','16','二班‘)";
mysql.Open();
MySqlCommand mysqlcommand = new MySqlCommand(sqlinsert, mysql);
mysqlcommand.ExecuteNonQuery();
mysql.Close();
}