I can imagine. Your first task should be to eliminate the subqueries; they don't benefit from indices. I had to change some of my JOINs the other day because the statements seemed to just sit there, now they zip along.

That seems like the best solution. Use an array to hold the data and built an interface around it. Thanks!

Thanks for the info! Too bad, I like the skinning options.

Nevermind, I solved the problem. (I moved the class initialization into a method of the calling class rather than doing class Blah = new Blah() when declaring it as a property)

We do plan to include a SessionStateProvider class in our next beta, so I wanted to make you aware of this technology. You are encouraged to download the current Persistore beta and experiment with it, it will be possible to persist session and other data in ASP.NET apps easily and efficiently. The current beta includes a basic implementation of a MembershipProvider, which may be enough to whet your appetite. (Our own website uses it for user registration and login etc). Questions, comments etc always welcome. Hugh Advanced .NET Persistence http://www.morantex.com

The issue is that your client controls all have names created by ASP.NET.  So, you need to insert this script with RegisterClientScriptBlock, and do something like: "if(document.getElementById("" + ddSampleLookup.ClientID + "").outerHTML == "Other")"  ( not corrected for quotes The other option is this: if(document.getElementById("<%ddSampleLookup.ClientID%>").outerHTML == "Other") which can go in your aspx, the <% %> block is server side code. You should also always check that document.getElementById has returned you something, or you will risk this sort of error. Christian Graus - C++ MVP 'Why don't we jump on a fad that hasn't already been widely discredited ?' - Dilbert

You know, I really really should've thought of calling from the UI thread myself...:wtf: I'll give it a shot, I'm sure it'll work. Thank you very much!

Yeah you need a smidgen of ASP/ASP.Net to get by developing WebParts... Where did my glasses go...