Difference dataset and dataview with cache

A

Arjen

Hi,

What are the main differences between a dataset and a dataview?

What should I cache dataset or dataview... or what is the best thing to do
in what situation?

Thanks!
Arjen
 
D

Dave

DataSet holds the data in memory

DataView is a "view" of the data that is customizable, such as filtering and sorting, but the underlying data still remains in a
DataTable.

Caching a DataView might store the view settings but not the underlying data. I'm not sure how that will behave. I can only
suggest that you try caching a DataView (only if you specificly need a DataView) and see if you can access the underlying DataTable
upon a post-back.

It may just be easier (and more appropriate) to cache the DataTable (or complete DataSet) and recreate a DataView when you need one.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference between dataset and dataview. 2
How can I write RowFilter in this situation 2
Problem with DataView.Sort 2
DataView relation to DataSet 1
Converting dataset to dataview and sorting? 7
dataview not sorting properly 3
GetXML, DataSet and dataview 4
ListView DataView, it shows me this letters "System.Data.Row.View" 1

Top