C# 连接mysql 数据库
1.先导入引用MySql.Data,可直接在nugut管理里选择安装
2.在相应窗体添加引用 using MySql.Data.MySqlClient;
3.如果MySql.Data.dll跟.net版本不一致还会报“KeyNotFoundException, 给定关键字不在字典中”的异常
String connetStr = "server=127.0.0.1;port=3306;user=root;password=1234; database=test_db;";
// server=127.0.0.1/localhost 代表本机,端口号port默认是3306可以不写
MySqlConnection conn = new MySqlConnection(connetStr);
try
{
//打开通道,建立连接
conn.Open();
Console.WriteLine("数据连接成功");
string sql = "select * from test01;";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(reader[0].ToString() + reader[1].ToString() + reader[2].ToString());
//Console.WriteLine(reader.GetInt32(0)+reader.GetString(1)+reader.GetString(2));
//Console.WriteLine(reader.GetInt32("userid") + reader.GetString("username") + reader.GetString("password"));//"userid"是数据库对应的列名,推荐这种方式
}
}
catch (MySqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
conn.Close();
}