谢谢大侠们帮帮忙吧

public int countmessage(string name)
{
SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["SQLCONNECTIONSTRING"]);
SqlCommand myCommand = new SqlCommand("select count * as count from answer where name='"+name+"'", myConnection);
myConnection.Open();
int zyID=(int)myCommand.ExecuteScalar ();
myConnection.Close();
return zyID;
}