XML Dataset editor

[Eric]

Hi,

I am making a flash card type program for the PocketPC. I am using a dataset
to contain the cards, all of that works great.

I thought I would just import the XML into word or excel, copy/paste the
data from other sources or add new records, and then save it as xml. As i
have Office XP, that does not work.

Is there a freeware XML dataset editor out there? I've found many editors,
but I just need something simple - oriented towards a dataset with a couple
of tables.

Making something like this would not be that hard, but would sort of be
re-inventing the wheel.

Any suggestions?

thanks

e
-------

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Info>
<Version>1.0</Version>
<DateCreated>2001-09-03T00:00:00.0000000-05:00</DateCreated>
<OriginalAuthor>Eric</OriginalAuthor>
<OriginalAuthorEmail>er**@erickraemer.com</OriginalAuthorEmail>
</Info>
<Cards>
<Section>GI</Section>
<Category>Neoplasm</Category>
<First>Finding</First>
<Second>Differential</Second>
<Third>Distinguishing Features</Third>
<DateReviewed>2001-09-03T00:00:00.0000000-05:00</DateReviewed>
<KnowledgeLevel>1</KnowledgeLevel>
</Cards>
<Cards>
<Section>GI</Section>
<Category>Neoplasm</Category>
<First>Finding</First>
<Second>Mnuemonic</Second>
<Third>Differential/Distinguishing Features</Third>
<DateReviewed>2001-09-03T00:00:00.0000000-05:00</DateReviewed>
<KnowledgeLevel>1</KnowledgeLevel>
</Cards>
<Cards>
<Section>GI</Section>
<Category>Neoplasm</Category>
<First>Finding/Entity</First>
<Second>Questions</Second>
<Third>Information about findings, answers to questions</Third>
<DateReviewed>2001-09-03T00:00:00.0000000-05:00</DateReviewed>
<KnowledgeLevel>1</KnowledgeLevel>
</Cards>
</NewDataSet>

[Dino Chiesa [Microsoft]]

Why not use MS Excel to store the table of data (whatever it is) and then
write a small export utility, maybe ~20 lines of code, to extract the
DataSet and write it to an XML file?

Here's an example that reads a dataset from MS Excel.
http://www.winisp.net/cheeso/srcview...xcel-adonet.cs

Using this as a start, all you would need to do is
modify the query to represent your spreadsheet (use a "named range" in MS
Excel)
modify the xls filename the program is using
add a statement that writes the dataset, as xml, to Console.Out or to a
specified file.

-Dino
"Eric" <er**@nospam.com> wrote in message
news:ux**************@TK2MSFTNGP09.phx.gbl...

Hi,

I am making a flash card type program for the PocketPC. I am using a dataset to contain the cards, all of that works great.

I thought I would just import the XML into word or excel, copy/paste the
data from other sources or add new records, and then save it as xml. As i
have Office XP, that does not work.

Is there a freeware XML dataset editor out there? I've found many editors, but I just need something simple - oriented towards a dataset with a couple of tables.

Making something like this would not be that hard, but would sort of be
re-inventing the wheel.

Any suggestions?

thanks

e
-------

<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<Info>
<Version>1.0</Version>
<DateCreated>2001-09-03T00:00:00.0000000-05:00</DateCreated>
<OriginalAuthor>Eric</OriginalAuthor>
<OriginalAuthorEmail>er**@erickraemer.com</OriginalAuthorEmail>
</Info>
<Cards>
<Section>GI</Section>
<Category>Neoplasm</Category>
<First>Finding</First>
<Second>Differential</Second>
<Third>Distinguishing Features</Third>
<DateReviewed>2001-09-03T00:00:00.0000000-05:00</DateReviewed>
<KnowledgeLevel>1</KnowledgeLevel>
</Cards>
<Cards>
<Section>GI</Section>
<Category>Neoplasm</Category>
<First>Finding</First>
<Second>Mnuemonic</Second>
<Third>Differential/Distinguishing Features</Third>
<DateReviewed>2001-09-03T00:00:00.0000000-05:00</DateReviewed>
<KnowledgeLevel>1</KnowledgeLevel>
</Cards>
<Cards>
<Section>GI</Section>
<Category>Neoplasm</Category>
<First>Finding/Entity</First>
<Second>Questions</Second>
<Third>Information about findings, answers to questions</Third>
<DateReviewed>2001-09-03T00:00:00.0000000-05:00</DateReviewed>
<KnowledgeLevel>1</KnowledgeLevel>
</Cards>
</NewDataSet>

[Eric]

Thanks. That will work great.

e
"Dino Chiesa [Microsoft]" <di****@online.microsoft.com> wrote in message
news:uJ**************@TK2MSFTNGP10.phx.gbl...

Why not use MS Excel to store the table of data (whatever it is) and then
write a small export utility, maybe ~20 lines of code, to extract the
DataSet and write it to an XML file?

Here's an example that reads a dataset from MS Excel.
http://www.winisp.net/cheeso/srcview...xcel-adonet.cs

Using this as a start, all you would need to do is
modify the query to represent your spreadsheet (use a "named range" in MS Excel)
modify the xls filename the program is using
add a statement that writes the dataset, as xml, to Console.Out or to a
specified file.

-Dino