How to get displayed values from database using dropdownlist?

See more:

C#3.0

C#

ASP.NET

I have created one form containing 2 dropdownmenu(dpmtList amd empList)
accessing items through database.One dropmenu contains list of department (from database) and other dropmenu is list of employees of specified department which is selected

i have used nested if else statement and always i get list of employees which are in else statement...
coding is below

created two functions
loademploeelist()
loaddepartmentlist()

protected void Page_Load(object sender, EventArgs e)
    {
        
            loademploeelist();
           loaddepartmentlist();
        
    }
 protected void loaddepartmentlist()
    {
        SqlConnection CON;
        SqlCommand COM;
        SqlDataReader READER;

        string ConnectionString = ConfigurationManager.ConnectionStrings["EMP"].ConnectionString;
        CON = new SqlConnection(ConnectionString);
        COM = new SqlCommand("Select department from dpmt", CON);

        try
        {
            CON.Open();
            READER = COM.ExecuteReader();
            dpmtList.DataSource = READER;
            dpmtList.DataValueField = "department";
            dpmtList.DataBind();
            READER.Close();
            
        }

        catch
        {
            CON.Close();
        }
      
    }
 protected void loademploeelist();
    {
                   SqlConnection CON;
                        SqlCommand COM;
            
            SqlDataReader READER;

            string ConnectionString = ConfigurationManager.ConnectionStrings["EMP"].ConnectionString;
            CON = new SqlConnection(ConnectionString);

            if (dpmtList.Text == "Administrartor")
            {
                COM = new SqlCommand("Select Name,ID from AD",CON);
            }

            else if (dpmtList.Text == "hr")
            {
                COM = new SqlCommand("Select Name,ID from Her", CON);
               
            }
            else if (dpmtList.Text == "IT")
            {
               COM = new SqlCommand("Select Name,ID from IT", CON);


            }
            else 
            {
            COM = new SqlCommand("Select Name,ID from HD",CON);

            }
           
            
            CON.Open();
            READER = COM.ExecuteReader();
            empList.DataSource = READER;
            empList.DataValueField = "ID";
            empList.DataTextField = "Name";
            empList.DataBind();

            READER.Close();

            CON.Close();

        }
    }

here administerartor,HR IT ,HD are department

Pls do tell me abut my mistake and rectify it
regards,