Pete, I am not sure what I gain by caching a datatable instead of the data view? Let me ask this... I have been reading since my question post... Can I Cache the data view which only has one table in it and then use filtering to dynamically build the drop downs? If so... how complex can the filtering get? I would have seven drop downs that are all related. For example if you select cats from the animal drop down no need to have drug sniffer show up in the drop down for jobs... the only issue is all seven drop downs are inter related. I am getting them all with one stored proc and would like to only get them once every 15 minutes.
Travis D. Falls |Consultant, Raft.Net IT | 860.547.4070 | [EMAIL PROTECTED] -----Original Message----- From: Peter Brunone [mailto:[EMAIL PROTECTED] Sent: Thursday, December 02, 2004 9:58 AM To: [EMAIL PROTECTED] Subject: RE: [AspNetAnyQuestionIsOk] Data View and Data Caching Hi Travis, If you cache a dataview, I believe you'll need to hit the DB again to get different stuff. However, if you cache a datatable instead, you can just come back and populate based on a dataview that is a subset of the table. OR As long as you have client script available, you could always save yourself the trouble of caching or postback and do it client-side, like this: http://www.learnasp.com/freebook/learn/elb_searcherDependent.aspx There are some articles on rolling your own at http://easylistbox.com/listBoxResources.aspx Cheers, Peter -----Original Message----- From: Falls, Travis D (HTSC, CASD) [mailto:[EMAIL PROTECTED] I have several drop downs that are bound to data views. When an item in drop down 'n' is selected the other drop downs rebuild to reflect the first selection. I do this by going back to the SQL Server and rebinding passing the arg(s) into the stored proc. Is this a good way to do this? Can I still use data caching or will these items then not rebuild? Can I query against the data view detached thus allowing me to cache for a little while? If I can is this querying of the detached data view efficient? Sorry for the 20 questions. Just trying to figure out the best way to do this. Thanks! :-) Travis D. Falls |Consultant, Raft.Net IT | 860.547.4070 | [EMAIL PROTECTED] Yahoo! Groups Links This communication, including attachments, is for the exclusive use of addressee and may contain proprietary, confidential or privileged information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return email and delete this communication and destroy all copies. ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
