What is Dataset??

[Arsalan]

What actually is dataset ?? I'm really confused, it can have more than one
table, so what is it??

 

[Sahil Malik]

The definition is - It is a collection of relations and tables.

In reality - it is like having a mini rdbms in memory that can be switched
to and from XML in a breeze. Also it can be thrown on a disc and it is
designed to work in a disconnected environment (disconnected from the
database).

- Sahil Malik
You can reach me thru my blog at
http://www.dotnetjunkies.com/weblog/sahilmalik

 

[Arsalan]

Thanks.

The definition is - It is a collection of relations and tables.

In reality - it is like having a mini rdbms in memory that can be switched
to and from XML in a breeze. Also it can be thrown on a disc and it is
designed to work in a disconnected environment (disconnected from the
database).

- Sahil Malik
You can reach me thru my blog at
http://www.dotnetjunkies.com/weblog/sahilmalik

 

[Guest]

hi
Datasets store data in a disconnected cache. The structure of a dataset is
similar to that of a relational database; it exposes a hierarchical object
model of tables, rows, and columns. In addition, it contains constraints and
relationships defined for the dataset.You use datasets if you want to work
with a set of tables and rows while disconnected from the data source. Using
a dataset is not always an optimal solution for designing data access

regards
Ansil

 

[Seth]

Hi Ansil,

So what are the other options for data access and their pros/cons?

Just out of curiousity.

Thanks,
Seth

 

[Guest]

hi
check these links out

http://sqljunkies.com/Newsgroups/microsoft.public.dotnet.framework.adonet/2004/5/31/241822.aspx

http://www.sitepoint.com/article/dataset-datareader

regards
Ansil