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>20 01-09-03T00:00:00.000 0000-05:00</DateCreated>
<OriginalAuthor >Eric</OriginalAuthor>
<OriginalAuthor Email>er**@eric kraemer.com</OriginalAuthorE mail>
</Info>
<Cards>
<Section>GI</Section>
<Category>Neopl asm</Category>
<First>Findin g</First>
<Second>Differe ntial</Second>
<Third>Distingu ishing Features</Third>
<DateReviewed>2 001-09-03T00:00:00.000 0000-05:00</DateReviewed>
<KnowledgeLevel >1</KnowledgeLevel>
</Cards>
<Cards>
<Section>GI</Section>
<Category>Neopl asm</Category>
<First>Findin g</First>
<Second>Mnuemon ic</Second>
<Third>Differen tial/Distinguishing Features</Third>
<DateReviewed>2 001-09-03T00:00:00.000 0000-05:00</DateReviewed>
<KnowledgeLevel >1</KnowledgeLevel>
</Cards>
<Cards>
<Section>GI</Section>
<Category>Neopl asm</Category>
<First>Findin g/Entity</First>
<Second>Questio ns</Second>
<Third>Informat ion about findings, answers to questions</Third>
<DateReviewed>2 001-09-03T00:00:00.000 0000-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.co m> wrote in message
news:ux******** ******@TK2MSFTN GP09.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>20 01-09-03T00:00:00.000 0000-05:00</DateCreated>
<OriginalAuthor >Eric</OriginalAuthor>
<OriginalAuthor Email>er**@eric kraemer.com</OriginalAuthorE mail>
</Info>
<Cards>
<Section>GI</Section>
<Category>Neopl asm</Category>
<First>Findin g</First>
<Second>Differe ntial</Second>
<Third>Distingu ishing Features</Third>
<DateReviewed>2 001-09-03T00:00:00.000 0000-05:00</DateReviewed>
<KnowledgeLevel >1</KnowledgeLevel>
</Cards>
<Cards>
<Section>GI</Section>
<Category>Neopl asm</Category>
<First>Findin g</First>
<Second>Mnuemon ic</Second>
<Third>Differen tial/Distinguishing Features</Third>
<DateReviewed>2 001-09-03T00:00:00.000 0000-05:00</DateReviewed>
<KnowledgeLevel >1</KnowledgeLevel>
</Cards>
<Cards>
<Section>GI</Section>
<Category>Neopl asm</Category>
<First>Findin g/Entity</First>
<Second>Questio ns</Second>
<Third>Informat ion about findings, answers to questions</Third>
<DateReviewed>2 001-09-03T00:00:00.000 0000-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******** ******@TK2MSFTN GP10.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