c# Invalid attempt to read when no data is present

Question

I am unable to find the problem here but this does not work! Any help will be appreciated.

It is a bool thing BTW.Every time i debug, it logs an error as follows

Invalid attempt to read when no data is present

ICCqueueLabelDropDownList.Items.Clear();
string queryString = "(SELECT  [name] FROM [asterisk].[dbo].[sip_friends] where name = '" + phoneNumberDropDownList.SelectedItem + "');";
        SqlConnection conn = new SqlConnection(connectionString);

        SqlCommand selectCmd = new SqlCommand(queryString, conn);
        SqlDataReader myReader = null;
        bool value = false;
        try
        {
            conn.Open();                                
            myReader = selectCmd.ExecuteReader();          

            //myReader.Read();

            if (myReader["name"].ToString() != "" )  /*   ( myReader["name"].ToString() != ""  */
            {
                myReader.Read();


                value = true;
            }





        }
        catch (Exception ex)
        {
            //ErrorLabel.Text = ex.Message;
            hiba.Visible = true;
            hiba.Text = ex.Message + "\n Check Insert Call User Device ÁLERT!";

        }
        myReader.Close();
        conn.Close();
        return (value);
    }

Answer 1

@andrew, kindly go through below code and let me know is it working for you or not?

        string connectionString = "[YOUR_CONNECTION_STRING]";
        ICCqueueLabelDropDownList.Items.Clear();
        string queryString = "(SELECT  [name] FROM [asterisk].[dbo].[sip_friends] where name = '" + phoneNumberDropDownList.SelectedItem + "');";
        SqlConnection conn = new SqlConnection(connectionString);
        SqlCommand selectCmd = new SqlCommand(queryString, conn);
        SqlDataReader myReader = null;
        bool value = false;
        try
        {
            conn.Open();
            myReader = selectCmd.ExecuteReader();
            if (myReader.Read())
            {
                if (myReader["name"].ToString() != "")  
                {
                    value = true;
                }
            }
        }
        catch (Exception ex)
        {
        }
        myReader.Close();
        conn.Close();
        return (value);
    }