vb.net - Insert distinct data into Combobox List

Question

I just want to ask if how to insert my distinct data to my combobox?

i.e.

dim query as string
query = "SELECT DISTINCT Department FROM tblEmployees" 

combobox1.text = ????

thanks!

Answer 1

dim query as string
query = "SELECT DISTINCT Department FROM tblEmployees" 

Me.ComboBox1.RowSource = query
Me.ComboBox1.Refresh