Instead of calling the database everytime you bind a row to simply retrieve the status description, I would consider rewriting your code to either: a) retrieve it with your inital query or b) assuming the status codes are static, load the status lookup table in memory once and retrieve the description from that instead
On 10/25/05, Eric Cantrall <[EMAIL PROTECTED]> wrote: > The routine fires on every MyDataGrid_onItemDataBound event and a new > connection in the pool is being opened and closed every time the event > fires. -- Dean Fiala Very Practical Software, Inc http://www.vpsw.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/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/
