What is faster to use in a DataGrid???
DataView, Dataset or DataTable
Thanks in advance,
Fabio Augusto
6  1495 
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"
"Fabio" <fa***@glb.com.br> wrote in message
news:ev***************@TK2MSFTNGP11.phx.gbl... What is faster to use in a DataGrid???
DataView, Dataset or DataTable
Thanks in advance,
Fabio Augusto
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
"Fabio" <fa***@glb.com.br> wrote in message
news:ev***************@TK2MSFTNGP11.phx.gbl... What is faster to use in a DataGrid???
DataView, Dataset or DataTable
Thanks in advance,
Fabio Augusto
And to add to Jay's comments. =)
"Jay B. Harlow [MVP - Outlook]" <Ja********@email.msn.com> wrote in message
news:O5**************@TK2MSFTNGP12.phx.gbl... 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
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
"Fabio" <fa***@glb.com.br> wrote in message
news:ev***************@TK2MSFTNGP11.phx.gbl... What is faster to use in a DataGrid???
DataView, Dataset or DataTable
Thanks in advance,
Fabio Augusto
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
"CJ Taylor" <no****@blowgoats.com> wrote in message
news:vn************@corp.supernews.com... And to add to Jay's comments. =)
"Jay B. Harlow [MVP - Outlook]" <Ja********@email.msn.com> wrote in
message news:O5**************@TK2MSFTNGP12.phx.gbl... 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
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
"Fabio" <fa***@glb.com.br> wrote in message
news:ev***************@TK2MSFTNGP11.phx.gbl... What is faster to use in a DataGrid???
DataView, Dataset or DataTable
Thanks in advance,
Fabio Augusto
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
Yeah...
my bad...saw that later...
-CJ
=)
"Jay B. Harlow [MVP - Outlook]" <Ja********@email.msn.com> wrote in message
news:OK**************@TK2MSFTNGP10.phx.gbl... 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
"CJ Taylor" <no****@blowgoats.com> wrote in message
news:vn************@corp.supernews.com... And to add to Jay's comments. =)
"Jay B. Harlow [MVP - Outlook]" <Ja********@email.msn.com> wrote in
message news:O5**************@TK2MSFTNGP12.phx.gbl... 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
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
"Fabio" <fa***@glb.com.br> wrote in message
news:ev***************@TK2MSFTNGP11.phx.gbl...
> What is faster to use in a DataGrid???
>
> DataView, Dataset or DataTable
>
>
> Thanks in advance,
> Fabio Augusto
>
>
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Brandon J. Van Every |
last post by:
I'm realizing I didn't frame my question well.
What's ***TOTALLY COMPELLING*** about Ruby over Python? What makes you jump
up in your chair and scream "Wow! Ruby has *that*? That is SO...
|
by: Stephen C. Waterbury |
last post by:
This seems like it ought to work, according to the
description of reduce(), but it doesn't. Is this
a bug, or am I missing something?
Python 2.3.2 (#1, Oct 20 2003, 01:04:35)
on linux2
Type...
|
by: YinTat |
last post by:
Hi,
I learned C++ recently and I made a string class.
A code example is this:
class CString
{
public:
inline CString(const char *rhs)
{
m_size = strlen(rhs);
|
by: Danny |
last post by:
I am trying to process a database and my code does so much that it takes a
whle to go through the database.
most of it is sql queries, updates and such.
For about 6000 records, it takes over a...
|
by: Mountain Bikn' Guy |
last post by:
I have a situation where an app writes data of various types (primitives and
objects) into a single dimensional array of objects. (This array eventually
becomes a row in a data table, but that's...
|
by: Jason Huang |
last post by:
Hi,
Would someone explain the following coding more detail for me? What's the
( ) for?
CurrentText = (TextBox)e.Item.Cells.Controls;
Thanks.
Jason
|
by: Andreas Klemt |
last post by:
Hello,
what has the better performance and what are you using?
Dim myObj As Object = 70
a) Dim myInt As Integer = DirectCast(myObj, Integer)
b) Dim myInt As Integer = Convert.ToInt32(myObj)
...
|
by: Tee |
last post by:
String Builder & String, what's the difference.
and when to use which ?
Thanks.
|
by: ctman770 |
last post by:
Hi Everyone,
Is it faster to save the precise location of an html dom node into a
variable in js, or to use getElementById everytime you need to access
the node?
I want to make my application...
|
by: pratap |
last post by:
Could someone clarify how could one reduce the size of an executable
code during compile time.
Could one use specific compile time flag with makefile or is it
advisable to go for dynamic linking....
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
