下载地址:http://dev.mysql.com/downloads/connector/net/
1、安装:mysql-connector-net-6.9.9.msi
默认安装路径
C:\Program Files\MySQL\MySQL Connector Net 6.9.9
2.安装步骤如下:
安装后完成后
C:\Program Files\MySQL\MySQL Connector Net 6.9.9\Assemblies下有v4.0、v4.5。
(VS2010使用V4.0下的dll文件
VS2012/2013/2015使用v4.5下的dll文件)
安装完后我们选择使用v4.0。然后在应用工程中引用组件MySql.Data.dll。
3.新建一个C#控制台应用程序名为:ConnectMysql。在C#中添加引用“MySql.Data.dll”
然后在应用工程中引用组件:MySql.Data.dll。
代码:增删查改
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using MySql.Data.MySqlClient;
using System.Data.SqlClient;
namespace ConnectMysql
{
class Program
{
static void Main(string[] args)
{
//主机名localhost 数据库名userdemo 用户名MySQL57 密码1234
string constructorString = "Host=localhost;Database=userdemo;Username=MySQL57;Password=1234";
//创建SQL对象
MySqlConnection myConnect = new MySqlConnection(constructorString);
myConnect.Open();
//插入数据
MySqlCommand myCmd = new MySqlCommand("insert into students(ID,NAME) values(2,'CaiXuKun')",myConnect);
Console.WriteLine(myCmd.CommandText);
if(myCmd.ExecuteNonQuery()>0)
{
Console.WriteLine("数据插入成功");
}
//删除数据
myCmd = new MySqlCommand("delete from students where ID=1", myConnect);
Console.WriteLine(string .Format( "受影响行数{0}",myCmd.ExecuteNonQuery()));
//修改数据
myCmd = new MySqlCommand("update students set NAME='CaiXuKun' where ID=2", myConnect);
int result = myCmd.ExecuteNonQuery();
//查询
myCmd = new MySqlCommand("select * from students where ID=2", myConnect);
MySqlDataReader date = myCmd.ExecuteReader();
//读数据
while(date.Read())
{
Console.WriteLine("id="+date.GetString("ID")+"name="+date.GetString("NAME"));
}
myCmd.Dispose();
//关闭连接
myConnect.Close();
Console.ReadKey();
}
}
}
数据库表:
————————————————
原文链接:https://blog.csdn.net/liyuqian199695/article/details/53556639