>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=3

HTH,

Enmanuel