public int UpdateOrderIsPay()
{
string connectionString = "server = localhost; user id = root; password = root; database = datamonitor_anonymous";//连接mysql数据库
string sql = "";//mysql语句
MySqlConnection myconnection = new MySqlConnection(connectionString);
myconnection.Open();
//创建MySqlCommand对象
MySqlCommand mycommand = new MySqlCommand(sql, myconnection);
//通过MySqlCommand的ExecuteReader()方法构造DataReader对象
int myreader = Convert.ToInt32(mycommand.ExecuteScalar());
myconnection.Close();
return myreader;
}
C#链接mysql数据库
最新推荐文章于 2024-07-20 15:50:39 发布