Using Dataset as temp tables
ASP.NET
1
Posts
1
Posters
0
Views
1
Watching
-
Hi, I am thinking of using an untyped dataset as a temp table to work with in my program. It seems to be much faster than using a database temp table and furthermore and the data table can be created with whatever columns is required and is destroyed when it is no longer required. 1) Is my above concept true? Or what are pros and cons of each? 2) How do you actually update records into a dataset using the primary key conditions rather than specify the row number which is more likely to be unknown. thx in advance for any answers : ) rgds, Nickson