What is the right way to populate a DropDownList from a database?
I am populating a DropDownList from a SQL Server database as shown below. It works fine, but I’m not sure it’s a good way. Can someone shed some light on this method, and give some improvements?