Efficient ways to Append a DataTable with XML

[Ryan Ternier]

I have a XML File in the format:

<ItemTypes>
<Item TypeID="1">
<Field Type="Status" Hidden="False"></Field>
<Field Type="Goal" Hidden="False"></Field>
...
</Item>
</ItemTypes>
....

The list of Item Types can go on forever. I am trying to load this in a
DataGrid so users can see the Field description, type etc. and can
change the "Hidden" attribute of it (True or False).

My program needs to take all the Fields from the DB, store them in a
DataTable. Then grab all of these fields from a XML File, and append the
same data table, then bind it to a Data Grid. On this DataGrid there
will be a column with CheckBoxes in it so users can "hide" that field
from different items (hence the hidden attribute).

My initial thoughts were to grab the data from the DB, Fill the
DataTable with it, then run a loop going through each Item Type,
appending each field to it.

IS using the xmlTextReader the most efficient way of doing this?

When the page is loaded, I just need to spit everything out onto the
page. But then when the user submits it, I have to re-write the
attributes of the XML file to match the checkbox (un-checked, or checked).


Thanks in advance.


/Rternier
Code monkey