Difference Between Typed Dataset and Untyped Dataset

[thomson]

Hi All,
What is the difference between a typed dataset and an untyped
datset,
Where can be this used actually, I mean in which situation
which has to be used,
In case anyone has got some articles please let me know
Thanks in Advance

Regards

thomson

 

[Steve C. Orr [MVP, MCSD]]

Typed datasets are more self documenting and easier to work with at design
time (overall).

MyTypedDataSet.MyDoctor.FirstName = "Fred"
vs.
MyUntypedDataSet.Tables("Doctors").Row(0).Item(1)="Fred"

 

[Eliyahu Goldin]

With typed datasets you are the one who tells what to do. You specify
exactly what you want, no matter if it is not exactly what you have in the
database.

With untyped dataset you have to follow the database structure. The database
tells you what to do. The select statements may return much more columns
that you need, or with different names.

As Steve has mentioned, typed datasets give you nice automatically-generated
classes with properties and method suited exactly for your needs.

For more or less serious project you would likely want to use typed datasets
only. For a simple task, like, demo or testing something, you can go with
untyped ones.

Eliyahu