Execute.scalar command always returns null

See more:

C#

SQL

Hello friends,

I have written a code in C# to fetch the data from database.

public string GetDatabaseValues(string value)
        {
            string strCon = System.Configuration.ConfigurationManager.ConnectionStrings["RestAPIConnectionString"].ConnectionString;
            string str = "";
            using (SqlConnection myConnection = new SqlConnection(strCon))
            {

                using (SqlCommand cmd = new SqlCommand(@"select Result from Output where Moviename=@0", myConnection))
                {
                    try
                    {
                        myConnection.Open();
                        cmd.Parameters.AddWithValue("@0", value);
                        str = cmd.ExecuteScalar().ToString();


                    }
                    catch (Exception e)
                    {
                        throw e;
                    }
                    finally
                    {
                        myConnection.Close();
                        myConnection.Dispose();
                    }
                }
            }
            return str;
        }

My database has the values. The problem here is despite my database containing proper values, the ExecuteScalar command is always sending null value and this results in "Object Reference set to null" error.

Please help in finding out the problem in my code or atleast let me know any alternative to ExecuteScalar command.

What I have tried:

tried Execute.Nonquery but failed.