c# mysql executescalar为什么返回值是空,c#ExecuteScalar()返回值的有关问题

C# codeMySql.Data.MySqlClient.MySqlConnection con = new MySql.Data.MySqlClient.MySqlConnection("Database=gkphpcms;Data Source=localhost;User Id=root;Password=root");

con.Open();

MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand("select count(contentid) from phpcms_c_news where contentid="+id, con);

int count = 0;

count = Convert.ToInt32(cmd.ExecuteScalar());//[color=#FF0000]Sql语句查询出来的是0,但是转换过后就变成1了[/color]

if (count == 0)

{

MySql.Data.MySqlClient.MySqlCommand cmdsetgbk = new MySql.Data.MySqlClient.MySqlCommand("set names 'utf8'", con);

cmdsetgbk.ExecuteNonQuery();

MySql.Data.MySqlClient.MySqlCommand cmdinsert = new MySql.Data.MySqlClient.MySqlCommand(@"insert into phpcms_c_news(contentid,template,content,DocUrl,DownType) values(" + id + ",'" + content + "','" + downurls + "','" + classtype + "')", con);

cmdinsert.ExecuteNonQuery();

}

con.Close();