Currently I've been populating DropDownList in the code behind of web page. Opening the connection, using the command object to run the stored proc, and binding it to the DropDownList with a procedure and calling it in the page load event.
I could end up having 24 or more of these through out the site. So I think it's time for me to try using a Data Access Layer and Business Logic Layer.
What would be the best approach for the following code? It populates three DropDownList using the same stored procedure but with different parameter values.
I haven't found any examples out there as of yet.