110,534
社区成员
发帖
与我相关
我的任务
分享
using (MySqlConnection connect = new MySqlConnection(ConfigurationManager.ConnectionStrings["connectStringVersion"].ConnectionString))
{
connect.Open();
using (MySqlCommand cmd = connect.CreateCommand())
{
cmd.CommandText = "select `TopVersion`,`TopicVersion`,`MovieVersion`,`SoftVersion`,`SoftContent`,`SystemVersion`,`SystemContent`,`SystemMustUpdate`,`UpdateTime` from version";
using (MySqlDataReader reader = cmd.ExecuteReader())
{
reader.Read();
ver = new Models.Version() { MovieVersion = (uint)reader["MovieVersion"], SoftContent = (string)reader["SoftContent"], SoftVersion = (uint)reader["SoftVersion"], SystemContent = (string)reader["SystemContent"], SystemMustUpdate = (byte)reader["SystemMustUpdate"], SystemVersion = (uint)reader["SystemVersion"], TopicVersion = (uint)reader["TopicVersion"], TopVersion = (uint)reader["TopVersion"], UpdateTime = ((DateTime)reader["UpdateTime"]).ToString("yyyy-MM-dd") };
}
}
}
或者还有更简单的,直接用MySqlHelper就行了,上面这些代码都不用写