>I would like to create a work table to be used by an ASP.NET app. I want it to act like a table but not be in the database -- IOW, the equivalent of a FoxPro cursor. It will contain data from several tables as well as calculated fields. Can I do this, or do I need to add a table to the database. This is a simulation app -- lots of data is displayed for the user to consider, but I only want/need to save parts of it.
You can use a disconnected dataset
http://www.awprofessional.com/articles/article.asp?p=27151&seqNum=3HTH,
Enmanuel
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain