DataTable vs DataView

[Bruce A. Julseth]

I'm new to VB.NET and just gettng into database "Learning." How do I decide
if I need a DataTable or a DataView.

Thanks...

Bruce

 

[Ken Tucker [MVP]]

Hi,

A dataview is a customized view of a datatable that supports
filtering, sorting, and searching.

http://msdn.microsoft.com/library/d...ef/html/frlrfsystemdatadataviewclasstopic.asp


Ken
---------------------
I'm new to VB.NET and just gettng into database "Learning." How do I decide
if I need a DataTable or a DataView.

Thanks...

Bruce

 

[Bruce A. Julseth]

Hi,

A dataview is a customized view of a datatable that supports
filtering, sorting, and searching.

http://msdn.microsoft.com/library/d...ef/html/frlrfsystemdatadataviewclasstopic.asp


Ken
---------------------
I'm new to VB.NET and just gettng into database "Learning." How do I decide
if I need a DataTable or a DataView.

Thanks...

Bruce

So, if I'm using a datagrid and only want to display and edit the data, I
use a DataTable which I created from my DataAdaptor. If I want to filter,
sort or search my data, I need to use a DataView.

Is my understanding correct?

Bruce

 

[Cor Ligthert]

Bruce,

When you use a windowforms datagrid you can better or always use a dataview
or the in the datatable build in dataview what is the datatable.defaultview

The sort by the user in the datagrid is reflected in the
defaultview/dataview.

To get the rows you can than use the bindingmanagerbase.position

http://msdn.microsoft.com/library/d...formsbindingmanagerbaseclasspositiontopic.asp

I hope this helps?

Cor

 

[slonocode]

So, if I'm using a datagrid and only want to display and edit the data, I
use a DataTable which I created from my DataAdaptor. If I want to filter,
sort or search my data, I need to use a DataView.

Is my understanding correct?

Bruce

Another way to say what Cor posted is:

All datatables have a default dataview. When you bind a datatable to a
windows form datagrid you are actually binding to the datatables default
dataview.

datagrid.datasource = datatable
datagrid.datasource = datatable.defaultview

The above two statements result the same.