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/de...classtopic.asp
Ken
---------------------
"Bruce A. Julseth" <br***********@attglobal.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
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]

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:eq**************@tk2msftngp13.phx.gbl...

Hi,

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

http://msdn.microsoft.com/library/de...classtopic.asp

Ken
---------------------
"Bruce A. Julseth" <br***********@attglobal.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
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/de...itiontopic.asp

I hope this helps?

Cor

[slonocode]

Bruce A. Julseth wrote:

"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:eq**************@tk2msftngp13.phx.gbl...

Hi,

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

http://msdn.microsoft.com/library/de...classtopic.asp

Ken
---------------------
"Bruce A. Julseth" <br***********@attglobal.net> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl.. .
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

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.