code for how to get values in dropdownlist at runtime from database in asp.net?

code which is to be write in page_load event


databse connectionopen()

Dim adaptername As New OleDbDataAdapter("sqlQuery, dbcon.connection)
Dim datasetname As New DataSet
adaptername.Fill(datasetname)

dropdownlistname.DataSource = datasetname
dropdownlistname.DataTextField = "field_name"
dropdownlistname.DataValueField = "field_name"
dropdownlistname.DataBind()
dropdownlistname.Items.Insert(0, " ") 'for empty


database connectionclose()