How to store data with XML
09-Aug-1212 Leave a comment
- One option is to set-up a dataset
- Add a manual table and columns.
- Add XML file
- See first two lines here
<?xml version=”1.0″ standalone=”yes”?>
<dsSystemNames xmlns=”http://tempuri.org/dsSystemNames.xsd”>
<SystemNames>
<ID>1</ID>
<SystemName>Fred</SystemName>
<DateInput>2012-08-09T10:45:00</DateInput>
</SystemNames>
</dsSystemNames>
- It is very fussy about format. For instance DateTime format must have T and full time down to hundreths of a second