what is faster???

[Fabio]

What is faster to use in a DataGrid???

DataView, Dataset or DataTable


Thanks in advance,
Fabio Augusto

 

[CJ Taylor]

Ummm...

DataTable is a child of dataset

Dataview is a interpretation of Dataview... i do'nt know if anyone is
particularly faster since they are all based of a "dataset"

 

[Jay B. Harlow [MVP - Outlook]]

Fabio,
In addition to CJ's comments.

The DataGrid only binds to the DataView (to display values), so I would
think it will be the fastest.

Remember you do not bind to a DataSet you bind to a member of the DataSet,
this member is a DataTable.

Also remember if you set the DataSource property of a DataGrid to just a
DataSet, without setting the DataMember property, you are presented a list
of DataTables (in a tree like control) to select which DataTable to display
the values of.

Further when you bind to a DataTable the DataGrid uses the
DataTable.DefaultView property to get a DataView which the DataGrid actually
uses to retrieve & maintain data.

Hence, you only bind to a DataView, so its the fastest.

This and a number of other exciting ADO.NET topics is covered at length in
David Sceppa's book "Microsoft ADO.NET - Core Reference" from MS Press.

Hope this helps
Jay

 

[CJ Taylor]

And to add to Jay's comments. =)

Fabio,
In addition to CJ's comments.

The DataGrid only binds to the DataView (to display values), so I would
think it will be the fastest.

Remember you do not bind to a DataSet you bind to a member of the DataSet,
this member is a DataTable.

Did some research on this, actually, it binds to the DefaultView object in a
DataTable... which is an object of type System.Data.DataView... =) So no
matter what, you use a Dataview.

However, using your own dataview lets you customize the view obviously. =)
Fun little fact that I didn't know.

I alos have Sceppa's book sitting right next to me. Great reference ( and
this dude knows ADO, you can talk to him on the adonet newsgroup if you have
real advanced questions too).

-CJ

 

[Jay B. Harlow [MVP - Outlook]]

CJ,

Did some research on this, actually, it binds to the DefaultView object in a
DataTable... which is an object of type System.Data.DataView... =) So no
matter what, you use a Dataview.

I did go on to state that ;-)

But its good to reiterate it sometimes!

Jay

 

[Cor]

Fabio,
Like all time dependable questions, it depends how you implement them.
Normaly I think a standalone datatabel in "read only mode from the datagrid"
will be the fastest.
Just a thought.
Cor

 

[CJ Taylor]

Yeah...

my bad...saw that later...

-CJ

=)

CJ, in
I did go on to state that ;-)

But its good to reiterate it sometimes!

Jay

in length