string sql = string.Format(select * from department"
DataTable tab = new DataTable();
open_con();
SqlDataAdapter adp = new SqlDataAdapter(sql, con);
adp.Fill(tab);
close_con();
Dropdepartment.DataSource = tab;
Dropdepartment.DataTextField = "Department_name";
Dropdepartment.DataValueField = "DepartmentID";
Dropdepartment.DataBind();
then in button click event
u you can write
string colleageID =Dropdepartment.SelectedValue;