XML -> Dataset, retrieving specific rows from dataset

Apr 19 2010 3:28 PM
I've been at this for quite some time, but to no avail.

I have an xml file that is structured like the following (I've simplified for readability). I can only be certain that the recipe id is unique. I need to pull the settings for just recipe1.group1.

I can get the file into an xml reader, and then into a dataset from there. How do I filter on the data set to just get the setting rows for recipe1.group1? Ideally, I'd like something like the following pseudo-code.

DataTable settings = RecipeDataSet.Tables.Select('Get settings from Group where Recipe='recipe1' and Group='group1')


Thanks,

SteveJ



<doc_element>
   <recipe id="recipe1">
       <group id="group1">
           <setting id="setting1">
           <setting id="setting2">
        <group id="group2">
           <setting id="setting1">
           <setting id="setting2">
     <recipe id="recipe2">
         <group id="group1">
         etc......


Answers (4)