Changing the Data in an XML Dataset

[Atley]

I want to edit the source of a Dataset I have set up using the Data Forms
wizard.

Is there a way to either filter the data to get the subset I want or to
change the recordsource of the Dataset all together?

btw this is in VB in VS.net 2003

[Eric Lemmon]

Hi Atley,

Are you referring to the XSD file? That is the schema definition file, so
it just describes the DataSet's schema. No data is contained in it.

It sounds like you want to use a DataView. Just set the Table property of
the DataView to the DataTable in the DataSet. You can then use the
DataView's RowFilter and Sort properties to get your data subset. Also, you
can change the DataSource/DisplayMember properties of your bound controls to
the DataView instead of the DataTable.

DataView.RowFilter Property:
http://msdn.microsoft.com/library/de...iltertopic.asp

DataView.Sort Property
http://msdn.microsoft.com/library/de...ssorttopic.asp

Take care,

Eric

"Atley" <at*****@homtmail.com> wrote in message
news:Oi**************@TK2MSFTNGP10.phx.gbl...

I want to edit the source of a Dataset I have set up using the Data Forms
wizard.

Is there a way to either filter the data to get the subset I want or to
change the recordsource of the Dataset all together?

btw this is in VB in VS.net 2003

[Atley]

What I am trying to do is get a variable subset of a table's data to show up
in a grid ready for editing...

What is the best way to do that?
"Eric Lemmon" <E_********************@hotmail.com> wrote in message
news:%2***************@TK2MSFTNGP10.phx.gbl...

Hi Atley,

Are you referring to the XSD file? That is the schema definition file, so
it just describes the DataSet's schema. No data is contained in it.

It sounds like you want to use a DataView. Just set the Table property of
the DataView to the DataTable in the DataSet. You can then use the
DataView's RowFilter and Sort properties to get your data subset. Also, you can change the DataSource/DisplayMember properties of your bound controls to the DataView instead of the DataTable.

DataView.RowFilter Property:
http://msdn.microsoft.com/library/de...iltertopic.asp
DataView.Sort Property
http://msdn.microsoft.com/library/de...ssorttopic.asp
Take care,

Eric

"Atley" <at*****@homtmail.com> wrote in message
news:Oi**************@TK2MSFTNGP10.phx.gbl...

I want to edit the source of a Dataset I have set up using the Data Forms wizard.

Is there a way to either filter the data to get the subset I want or to
change the recordsource of the Dataset all together?

btw this is in VB in VS.net 2003

[Cor Ligthert]

> What I am trying to do is get a variable subset of a table's data to show
up

in a grid ready for editing...

What is the best way to do that?

There is in VB.net no overall best way, however the way Eric told you is a
very good one for your question.

Just my thought,

Cor

[Atley]

How do I assign the dataview to the DataGrid?

"Cor Ligthert" <no**********@planet.nl> wrote in message
news:ux**************@TK2MSFTNGP09.phx.gbl...

What I am trying to do is get a variable subset of a table's data to

show up

in a grid ready for editing...

What is the best way to do that?

There is in VB.net no overall best way, however the way Eric told you is a
very good one for your question.

Just my thought,

Cor

[Cor Ligthert]

Hi Atley,

Eric as well as me did give an answer on your question some rows above to
resti, however it is nothing more than (with a windowsform)
\\\
dim dv as new dataview(ds.tables(0))
dv.rowfilter ............' if you need that
dv.sort ...............' if you need that
datagrid1.datasource = dv
///
I hope this helps

Cor