I have a Classic ASP application that uses an MS SQL Server database. I am going to migrate the ASP app to ASP.NET and make some enhancements. I will be making some changes to the database tables for this enhancement.
I created a new DataSet and added datatables manually to the DataSet to represent the changes I will be making for the enhancement. (I can't change the database yet and don't want to wait to begin my development.)
What I need to do now is add a GridView to my form using data from a table in my newly created DataSet. When I choose Object as my DataSource Type, it doesn't allow me to choose my new DataSet even though it exists in my App_Code folder.
My plan is to populate the new DataSet during the PageLoad Event as a temporary measure until I can make the database changes.
I am using VS 2010. Any help would be greatly appreciated!