I have a form in which I am attempting to point to different connection strings based on a user dropdownlist selection after page load. If I leave the connectionstring property undefined (and let it be populated by a switch on the .cs page's DropDownList1_SelectedIndexChanged call) it fails since the page DataSource runs on page load. If I try pointing to a default connectionString and change from the drop down the connectionstring used on the aspx page always loads and the switch on the cs page fails to update a GridView. How can I delay the call to the SqlDataSource but still load the page? I have tried putting everything in the .cs page but that hasn't worked yet.
View Complete Post