Temporary tables on web

[SBGibson]

Hi guys,

how you solved problems of using temporary data storage in a multiuser-monoprocedure software such as an asp.net application?
I mean...in a win front-end application I can use a local database where downloading records from server, performing many operations and then use the result for printing or something else.
How we can do it in a asp.net application? Temporary tables on the server? A multipurpose table with userid in a field, datasets (but we cannot use sql statements on recordsets tables)....something else?

What's your ideas?

Tnx


Stevie B. Gibson

 

[merlyn2450]

use datasets and dataviews, and keep them in the applicationstate. i use a serializable class to manage the data and make for easy in-memory storage

 

[SBGibson]

And for SQL commands such as UPDATE, GROUP BY etc you have developped some methods in the class that emulate them scrolling through the datarows?

Stevie B. Gibson