ComboBox Droplist

Question

hi,

i am new in c#. i need help to complete my final project on database as i cant figure out how to do my coding for combox drop list.

I have my databse in sql. i have created form with combobox droplist for the department list and a view button which suppose to pop up the list of employees belong to the department.

My question:-

how to do the code for the button? and getting information from my database.

for the combobox droplist ..i added the dept list manually as i cant bind them as i get repeated department name as some employees with same dept.

Look forward to some help with clear code sample.

thank you