Populating a dropdown with data from an SqlServer stored procedure

[Elmo_loves_you]

Hi, I am rather new to programming. I have a stored procedure that simply reads a 'CourseCode' from a Course table, the stored procedure code is as follows:

--------------------------------------------
ALTER PROCEDURE dbo.Courses

AS
SELECT CourseCode
FROM Course
RETURN
---------------------------------------------

I have C# code in the code behind page to try and popuate a dropdownlist with a list of CourseCodes, it is as follows:

public void getCourseDropDown()
        {
            try
            {
                command = new SqlCommand("Courses", myConnection);
                myConnection.Open();
                reader = command.ExecuteReader(CommandBehavior.CloseConnection);

                while (reader.Read())
                {
                    DD_Course_uploadBrief.Items.Add(new ListItem(reader("CourseID".ToString())));
                }
                reader.Close();
            }
            catch (Exception objException)
            {
                //Display the exception message 
                string strError = objException.Message;
                if ((objException.InnerException != null))
                {
                    strError += objException.InnerException.Message;
                }
            }
            finally
            {
                // Clean Up 
                reader = null;
            }
        }

------------------------------------------------------------------------------
When I build the asp.net website application I get the following error:

'reader is a field but is used like a method'

I would be very grateful for any help you all may have,

thanks in advance :)

[Ramy Mahrous]

Please move your thread to ASP.NET forum http://www.daniweb.com/forums/thread117180.html

reader.GetString(coulmnNumber); or
reader.GetInt32(columnNumber); based on your column data type and its number.

[peter_budo]

Post moved