1.首先从网上下载mysql.data.dll
2.在vs程序中添加引用,引入下载的mysql.data.dll
3.添加一个类,名称为MySQLConn.cs
4.在类里面写入代码如下,其中前面的MySqlCon为连接字符串,注意:请对应修改数据库的用户名和密码
using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace KD_Control
{
class MySQLConn
{
public string MysqlConn = "Database=test;Data Source=127.0.0.1; User Id=root;Password=123456;pooling=false;"+
"CharSet=utf8;port=3306";
public DataTable ExecuteQuery(string sqlStr)
{
MySqlCommand cmd;
MySqlConnection con;
MySqlDataAdapter msda;
con = new MySqlConnection(MysqlConn);
con.Open();
cmd = new MySqlCommand(sqlStr,con);
cmd.CommandType = CommandType.Text;
DataTable dt = new DataTable();
msda = new MySqlDataAdapter(cmd);
msda.Fill(dt);
con.Close();
return dt;
}
public int ExecuteUpdate(string sqlStr)
{
MySqlCommand cmd;
MySqlConnection con;
con = new MySqlConnection(MysqlConn);
con.Open();
cmd = new MySqlCommand(sqlStr, con);
cmd.CommandType = CommandType.Text;
int iud = cmd.ExecuteNonQuery();
con.Close();
return iud;
}
}
}
5.在窗体应用程序中添加一个datagridview控件,并设置在父容器中停靠
6.添加一个按钮,在点击事件中添加如下代码
heightControllerFix1.Show();
string sql = "select * from 注册表";
heightControllerFix1.dataGridView1.DataSource = conn.ExecuteQuery(sql);
然后数据库里面的数据就填充到了datagridview控件里面了
原文地址:
链接地址