make a Datatable and make it the source for both rather than a reader. You can employ data caching to ensure many pages do not have to do repetitve database requests or OutputCaching with user controls to ensure same
http://www.learnasp.com/freebook/learn/datacaching.aspx Data Caching Sample http://www.learnasp.com/freebook/learn/searcherUCCached.aspx UserControl Caching On Sun, 31 Oct 2004 18:42:34 -0000, Cady <[EMAIL PROTECTED]> wrote: > > > hi, i don't know whether this problem of mine has been asked by > another user or not? > ok here the thing > i have 2 dropdown box. and i want to fill it with the same data from > the database. > the dropdown is in the same page.. > right now what i use is, i make the connection twice... > and it make my page load like a turtle... > > can anybody help me.. > thank you > > > > > > > > > > > > Yahoo! Groups Sponsor > > ADVERTISEMENT > > > ________________________________ > Yahoo! Groups Links > > To visit your group on the web, go to: > http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ > > To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ------------------------ 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/AspClassicAnyQuestionIsOk/ <*> 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/
