Question

int count = Convert.ToInt32(cmd.ExecuteScalar());输入字符串的格式不正确

string ACCESS_CONN_STRING = "UID=root;PassWord=sec1234;PORT=3306;DATABASE=healthcenter;SERVER=222.29.213.32;CHARSET=utf8";

using (MySqlConnection conn = new MySqlConnection(ACCESS_CONN_STRING))
{
string sql_MysqlCount = "select user_name,user_idNumber from User where user_name='" + hwexamername + "' and user_idNumber ='" + mysqldatsinfo + " '";

MySqlCommand cmd = new MySqlCommand(sql_MysqlCount, conn);
conn.Open();
int count = Convert.ToInt32(cmd.ExecuteScalar());
呵呵 谢谢 但是数据库表里面有相同的数据 int count = Convert.ToInt32(cmd.ExecuteScalar());这个取出来应该是count >0，但是现在是count =0 不知道怎么回事

Answer 1

用不到int32 这么大的数吧。int 对于一般来说都够用了。
还有把数据库连接串隐了吧。
try
{
count = int.Parse(cmd.ExecuteScalar().ToString());
}
catch
{
count = -1;
}