For displaying country private sub binddropdown() try dim da as new sqldataadapter("select * from countries order by country", myconnection) dim ds as new dataset myconnection.open() da.fill(ds)...