1、添加引用MySql.Data

2、在命名空间中添加

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

3、声明MySqlConnection对象

 MySqlConnection conn = new MySqlConnection();

4、声明MySqlCommand对象

MySqlCommand command = new MySqlCommand();

5、声明连接字段

string con_inf = "server='localhost';user id=root;password='12345';database=mysql";

6、连接数据库

//连接数据库
public void ConnectionDB(){
conn.ConnectionString = con_inf;
conn.Open();
command.Connection = conn;
}

7、关闭连接

//关闭数据库
public void closeDB()
{
command.Dispose();
conn.Close();
}

8、查询

//查询
public MySqlDataReader query(string sql)
{
MySqlDataReader reader = null;
try
{
command.CommandText = sql;
reader = command.ExecuteReader();
}
catch (System.Exception ex)
{

}

return reader;
}

9、添加

//添加
public void add(string sql)
{

command.CommandText = sql;
command.ExecuteNonQuery();
}

10、删除

//删除
public void delect(string sql)
{

command.CommandText = sql;
command.ExecuteNonQuery();
}

11、更新

//更新
public void update(string sql)
{

command.CommandText = sql;
command.ExecuteNonQuery();
}