ansaurus

Question

Generating XML dynamically from the data entered on UI.

Answer 1

A:

You could just store it directly in the DOM, and serialise when desired.

Paul Butcher 2010-06-25 10:41:00

Thanks Paul but i wud need more information!

Varun 2010-06-25 11:49:39

Like what? Create a DOM of the skeleton XML, then when the user changes the values, store those values into the appropriate nodes in the DOM. When you want the XML to become a file, save it.

Paul Butcher 2010-06-25 12:48:31

Right Paul. I feel i have to store the values into the database but i need to decide the table structure.

Varun 2010-06-25 13:00:44

Why do you have that feeling? Are you doing something other than create this XML? If the only purpose of this UI is to create an XML representation of the inputs, then messing about with databases and tables is pointless.

Paul Butcher 2010-06-25 14:50:50

Paul, let me get bit in detail. The xml file is used by flash developer for something like google map feature. User needs to have the facility to delete and modify the data(i.e. nodes and attributes). So I feel that storing it in database can be handy. I believe just fetch the data do something like dataset.getXML or dataset.wrtieXml

Varun 2010-06-28 06:04:08

All of that can be achieved via the DOM. Unless you wish to run queries that you can't write in XPath, a Tabular Database is a pointless bit of cruft that will hamper future maintenance.

Paul Butcher 2010-06-28 08:49:59

Right, Can you give some sample/code or start -up sort of which matches my requirement.You saw my xml data right.

Varun 2010-06-28 09:00:36

Here: http://support.microsoft.com/kb/317665

Paul Butcher 2010-06-28 09:13:57

Thanks paul. Let me go through it. Will get back to you for further suggestions :)

Varun 2010-06-28 09:29:55

Here I get my answer :http://support.microsoft.com/kb/317666Now the challenge is how to make a UI which allows user to enter the values and attributes they want to add,remove, and modify

Varun 2010-06-28 12:51:40

Answer 2

A:

If I were you I would just store the data in a db and then use an xmltexwriter to write it to where ever.

using (XmlTextWriter writer = new XmlTextWriter(OutputStream, Encoding.UTF8)) {
writer.Formatting = Formatting.Indented;
writer.WriteStartDocument();
writer.WriteStartElement("DATA");
writer.WriteStartElement("SDACTS");
foreach ( SDACT in SDACTs) {
    writer.WriteStartElement("SDACT");
    writer.WriteAttributeString("TYPE", SDACT.Type);
    writer.WriteAttributeString("COLOUR", SDACT.COLOUR);
    writer.WriteEndElement();
}
writer.WriteEndElement();
writer.WriteEndElement();
writer.WriteEndDocument();

}

You could also take advantage of using .nets XML serialization see http://msdn.microsoft.com/en-us/library/ms950721.aspx

Mike 2010-06-25 10:43:27

Hi Mike, Thanks for replying.I would like to tell you that I have not worked more in xml, have just stared and also I use C# as my language but that is ok...Now I would like to have some more information in details like the loop which you are doing is of table SDACTS? And the columns of the table would be Type and colour?Can you please just give a detailed information on my first few lines of xml file starting from SDACTS to Country tag and what kind of table structure wud i need to make to store data and then the code which builds the xml file?I wud appreciate tat.I saw d link but :(

Varun 2010-06-25 11:47:59

I updated it for c#. I made alot of assumptions here so it is more or less psudocode. I was assuming a generic list for the SDACTS list<SDACT>. If I were you I would create a class with for each item in your xml. Starting with DATA. Data would then have properties such as SDACTs which would be of the generic list type I mentioned earlier. Then the SDACT class would have properties of Type and Colour. and so on. this may be overkill for what you are doing, so if you have the data you could just manually write it out the same way without lopping through collections.

Mike 2010-06-25 12:28:59

Thanks Mike. I would like to have your personal mail id if u r ok with that.

Varun 2010-06-25 12:57:55

@Mike: +1 for using the `using` block, but -1 for using `new XmlTextWriter()`. that's been deprecated since .NET 2.0! Use `XmlWriter.Create()` instead.

John Saunders 2010-07-02 04:10:32

Thanks John!!!!

Mike 2010-07-02 11:24:44

ansaurus

tags:

views:

answers:

Generating XML dynamically from the data entered on UI.

related questions