C#访问MySql数据库(通过MySql.Data)

2024年4月28日发(作者：)

string ConnectionString = "server = 127.0.0.1; userid = root; password = 123456; database = test_db; persistsecurityinfo = True;";

MySqlDatabaseHelper db_Test = new MySqlDatabaseHelper(ConnectionString);

// 打开数据库

db_();

// sql 查询语句

string sqlCmdStr = null;

// 新增记录

sqlCmdStr = "insert into chipinfo_20200209(chipid, chiptype) values('5','S10')";

db_eNonQuery(sqlCmdStr);

// 删除记录

sqlCmdStr = "delete from chipinfo_20200209 where chipid = 4";

db_eNonQuery(sqlCmdStr);

// 修改数据

sqlCmdStr = "update chipinfo_20200209 set boardid = '666' where chipid = '5'";

db_eNonQuery(sqlCmdStr);

// 查询数据

sqlCmdStr = "select * from chipinfo_20200209";

MySqlDataReader dataReader = db_eReader(sqlCmdStr);

while (())

{

string str = dataReader["chiptype"].ToString();

}

();

// 关闭数据库

db_();

}

}

}

View Code