>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.

It sounds like you need to use a DataTable.