Try the following code,

string user_stat = Convert.ToString(cmd.ExecuteScalar())
 
    if(Convert.ToBoolean(user_stat ))
    {
    -----
    -----
    }

In side if condition, You will get either true/false

Try the following code,

string user_stat = Convert.ToString(cmd.ExecuteScalar())
if(Convert.ToBoolean(user_stat ))
{
-----
-----
}

In side if condition, You will get either true/false

Try the following code,

string user_stat = Convert.ToString(cmd.ExecuteScalar())

if(Convert.ToBoolean(user_stat )) {

}

In side if condition, You will get either true/false

Try the following code,

string user_stat = Convert.ToString(cmd.ExecuteScalar())

    if(Convert.ToBoolean(user_stat ))
    {
    -----
    -----
    }

In side if condition, You will get either true/false