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.