csharp-mysql

发表于 2022-07-04 更新于 2022-07-06 分类于 Language 阅读次数：本文字数： 531 阅读时长 ≈ 1 分钟

using MySql.Data.MySqlClient;

MySql.Data
MySql.Data.EntityFrameworkCore


String connetStr = "server=192.168.0.129;port=3306;user=root;password=lanbe123; database=monitor;";
MySqlConnection con = new MySqlConnection(connetStr);

con.Open();
Console.WriteLine("数据库连接成功");

MySqlCommand cmd = new MySqlCommand("select * from module", con);
IDataReader read = cmd.ExecuteReader();
while (read.Read())
{
    Console.WriteLine(read[0].ToString());
    Console.WriteLine(read[1].ToString());
    Console.WriteLine(read[2].ToString());
}
con.Close();