无法将类型“object”隐式转换为“int”。存在一个显式转换(是否缺少强制转换?)

Question

public int CheckUserName(String UserName)
        {
            OleDbConnection objconn = new OleDbConnection("provider=Microsoft.Jet.OleDb.4.0;Data Source=UserInfo.mdb");
            OleDbCommand objcmd = new OleDbCommand("select count(*) from Users where YongHuMing='" + UserName + "'", objconn);
            objconn.Open();
            int count = 0;
            count=objcmd.ExecuteScalar();
            objconn.Close();
            return count;
        }错误原因:无法将类型“object”隐式转换为“int”。存在一个显式转换(是否缺少强制转换?)

Answer 1

public int CheckUserName(String UserName)
        {
            OleDbConnection objconn = new OleDbConnection("provider=Microsoft.Jet.OleDb.4.0;Data Source=UserInfo.mdb");
            OleDbCommand objcmd = new OleDbCommand("select count(*) from Users where YongHuMing='" + UserName + "'", objconn);
            objconn.Open();
            int count = 0;
            count=Convert.ToInt32(objcmd.ExecuteScalar());
            objconn.Close();
            return count;
        }

Answer 2

count=int.Parse(objcmd.ExecuteScalar().ToString();

Answer 3

Convert.ToInt32(objcmd.ExecuteScalar());