Querying or Parsing Datasets?

[Ryan Ramsey]

I am looking for some advice or best practices on how to do this..

I have an XML file, that I read into a dataset via ReadXML:

PlayersDataSet.Clear();
PlayersDataSet.ReadXml(filePath);

What I would like to do is query the dataset so I can search for people from
California, or people older than 65 or something?

Is there any way to make a SQL data adapter that uses a dataset as the
source data?

How can I parse the content of the dataset?

I have also tried a DataGridView but haven't found the mechanism to do this
since ReadXML is being used to generate the schema information currently.

[Miha Markic [MVP C#]]

Hi Ryan,

There is DataTable.Select method. Or you could use the DataView with its
RowFilter property.

--
Miha Markic [MVP C#, INETA Country Leader for Slovenia]
RightHand .NET consulting & development www.rthand.com
Blog: http://cs.rthand.com/blogs/blog_with_righthand/

"Ryan Ramsey" <ry********@yahoo.com> wrote in message
news:29******************************@adelphia.com ...

I am looking for some advice or best practices on how to do this..

I have an XML file, that I read into a dataset via ReadXML:

PlayersDataSet.Clear();
PlayersDataSet.ReadXml(filePath);

What I would like to do is query the dataset so I can search for people
from
California, or people older than 65 or something?

Is there any way to make a SQL data adapter that uses a dataset as the
source data?

How can I parse the content of the dataset?

I have also tried a DataGridView but haven't found the mechanism to do
this
since ReadXML is being used to generate the schema information currently.