I'm having troubles generating values from a table (database) on to the dropdownlist control. DataSet = "dropdownlist". Your help is greatly appreciated. Thank you all in advance.

My code are as follows:

try
            {
                Database database = new Database();
                OracleConnection connection = database.RHRD();
                string sql = "SELECT PROG_ID FROM SPOOL_CONTROL";
                connection.Open();
                OracleCommand command = new OracleCommand(sql,connection);
                OracleDataReader reader = command.ExecuteReader(System.Data.CommandBehavior. CloseConnection);

                if(reader.HasRows)
                {
                    DataSet.DataSource = reader;
                    DataSet.DataBind();
                }
                else
                {
                    Response.Write("Database is not available!");
                }
            }
            catch(Exception ex)
            {
                Response.Write(ex.Message);
            }
            finally
            {
            DataSet.Items.Insert(0,"Choose from list!");
            DataSet.SelectedIndex = 0;
            }

I would like to note that the database connection works, but the values displayed on the dropdownlist looks funky. It shows "System.Data.Common.DbDataRecord".

Problem solved. I forgot to add DataSet.DataValueField = "PROG_ID"; and DataSet.DataTextField = "PROG_ID"; to the code. Thanks all.