SteveInBeloit
Well-known member
- Joined
- May 22, 2006
- Messages
- 132
- Programming Experience
- 10+
Hi,
I have an ASP to develop that needs to do the following:
(The page will be connected to an Access mdb.)
Needs to have a list of 8 dropdownlists across the top that will act as a filter for a grid view of data from the database. The more of these they populate, the more filtered the data in the gridview will get. Once they have it filtered as they wish, they want to click on their chosen record in the gridview and then based on that data, it will populate numerous lists, textboxes, and gridviews on the page, which will have numerous datasources all from different tables in the access mdb.
There is no updating, just display.
So, I guess my question is, do you see any gotcha's here? Anything I need to watch out for, or does it sound pretty straight forward? I am not really for sure how to do the dropdownlists as filters? I can add the dropdownlists, create datasources for them and populate them. But how to get one to many of them applied to the gridview?
My thoughts are on the Page_load to populate the dropdownlists. Then let them choose which ever filters from them they need and push a "filter" button. I then will somehow see which ones they have populated, and build the SQL on the fly?? to select from the ACCESS tables? Then try to take the result of that and use it as the record source of a gridview -- can I do this in code? Then when they select a gridview record, grab the info from that and use it to make several other calls to the tables to return data to populate numerous controls on the page.
How does this sound? Ok, or have I missed the boat here? Any advice on the topics I mentioned that I didn't really know how to do? One more thing, can I call ACCESS queries from the ASP, or do I need to create all of the SQL in the code dynamically.
Thanks a lot for reading and any advice. This is not my first ASP, but the first one with any meat to it.
Steve
I have an ASP to develop that needs to do the following:
(The page will be connected to an Access mdb.)
Needs to have a list of 8 dropdownlists across the top that will act as a filter for a grid view of data from the database. The more of these they populate, the more filtered the data in the gridview will get. Once they have it filtered as they wish, they want to click on their chosen record in the gridview and then based on that data, it will populate numerous lists, textboxes, and gridviews on the page, which will have numerous datasources all from different tables in the access mdb.
There is no updating, just display.
So, I guess my question is, do you see any gotcha's here? Anything I need to watch out for, or does it sound pretty straight forward? I am not really for sure how to do the dropdownlists as filters? I can add the dropdownlists, create datasources for them and populate them. But how to get one to many of them applied to the gridview?
My thoughts are on the Page_load to populate the dropdownlists. Then let them choose which ever filters from them they need and push a "filter" button. I then will somehow see which ones they have populated, and build the SQL on the fly?? to select from the ACCESS tables? Then try to take the result of that and use it as the record source of a gridview -- can I do this in code? Then when they select a gridview record, grab the info from that and use it to make several other calls to the tables to return data to populate numerous controls on the page.
How does this sound? Ok, or have I missed the boat here? Any advice on the topics I mentioned that I didn't really know how to do? One more thing, can I call ACCESS queries from the ASP, or do I need to create all of the SQL in the code dynamically.
Thanks a lot for reading and any advice. This is not my first ASP, but the first one with any meat to it.
Steve
