I'm trying to figure out which method is the best to use for my projects that I'm working on. All projects are not related and I'm programming in C# using ASP.NET and using the ADO.NET for Data Access.
My question is that I have at least 1-4 DropDown Controls that I need to retrieve data for and then bind that data to the DropDown contros and I'm not sure If i should use a DataSet and DataTable or DataReader to retrive the data to bind to the DropDownList controls.
1.) which method is faster to bind the controls to.
2.) which method has the best performance on the server (i.e. CPU and Memory performance)