很怪异,同样的代码,连接我自己本地的MySQL数据库的时候,完全没有问题。但是改了一下ConnectionString连接公司的Linux服务器上的MySQL的时候,似乎是参数没有传过去,DataReader的结果是空的。有没有大神碰到过这样的问题,应该怎么处理?MySqlCommand cmdCourse = new MySqlCommand(@"SELECT courseid, coursename, `level` FROM course WHERE `level` = ?level ORDER BY courseid;", conn);
cmdCourse.Parameters.AddWithValue("?level", schoolType); MySqlDataReader dr = cmdCourse.ExecuteReader();
while (dr.Read())
{
Course course = new Course(); course.courseid = dr.IsDBNull(0) ? 0 : dr.GetInt32(0);
course.coursename = dr.IsDBNull(1) ? string.Empty : dr.GetString(1);
course.level = dr.IsDBNull(2) ? string.Empty : dr.GetString(2); listCourse.Add(course);
}
dr.Close();版本:VS2012,Win8 64
MySQL Connector:6.7.4(.net v4和v4.5都试过)
MySQL版本:Windows 5.6.12, 64位; CENT OS:5.1.69
cmdCourse.Parameters.AddWithValue("?level", schoolType); MySqlDataReader dr = cmdCourse.ExecuteReader();
while (dr.Read())
{
Course course = new Course(); course.courseid = dr.IsDBNull(0) ? 0 : dr.GetInt32(0);
course.coursename = dr.IsDBNull(1) ? string.Empty : dr.GetString(1);
course.level = dr.IsDBNull(2) ? string.Empty : dr.GetString(2); listCourse.Add(course);
}
dr.Close();版本:VS2012,Win8 64
MySQL Connector:6.7.4(.net v4和v4.5都试过)
MySQL版本:Windows 5.6.12, 64位; CENT OS:5.1.69
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货