19,502
社区成员
发帖
与我相关
我的任务
分享
private void connMySQLData() {
// 查询语句
string sqlStr = "select * from storage";
// 连接属性
string connStr = "Server=192.168.1.112;User Id=root;Password=root;Persist Security Info=True;Database=storage";
MySqlConnection conn = new MySqlConnection(connStr); // 创建连接
conn.Open(); // 打开链接
MySqlCommand command = new MySqlCommand(sqlStr, conn);
/*执行查询命令*/
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
Console.WriteLine(reader[0]);
//reader.GetInt32(0);
//reader.GetString(1);
Console.WriteLine(reader[1]);
Console.WriteLine(reader[2]);
}
conn.Close();
command = null;
reader.Close();
}