reading Dataset xml file

  • Thread starter Thread starter microsoft.news.com
  • Start date Start date
M

microsoft.news.com

i have a dataset and the first row of the dataset is empty. It looks like
this

<NewDataSet>
<ImportData />
<ImportData>
<State>Delaware</State>
<City>Dover</City>
</ImportData>
<ImportData>
<State>New York</State>
<City>Fishkill</City>
</ImportData>
<ImportData>
<State>Delaware</State>
<City>Wilmington</City>
</ImportData>
<ImportData>
<State>New York</State>
<City>Syracuse</City>
</ImportData>
</NewDataSet>

How can I read this skip the first <ImportData> tag since it will always be
blank, then group the states so i see
Delaware Dover
Wilmington
New York Fishkill
Syracuse
 
Just remove the row after you read it in. Then, use
the .Select method on the DataTable object.
 
I never done this before, do you have a code snippet or can you point me to
an example of this being done?
 
Back
Top