xmwriter and dataset plus formating issues

Reply

Member

542 Points

xmwriter and dataset plus formating issues

May 13, 2014 02:29 PM|bobmmp|LINK

I posted once under Getting Started and only getting one response after 5 days, I realized I should have posted the issue here. I am actually experiencing two issues, well one issue and one total lack of knowledge... well two lacks of knowledge.

My experience writting xml to this point has been extremely minimal, thus the getting started post. So here goes, hope I explain it well enough to make sence?

I need to product an xml document that fits this format:

<order>
  <ordercust>
    <ordernumber>123</ordernumber>
    <customername>john doe</customername>
    <customeraddr>123 test lane</customeraddr>
    <customercity>City Name</customercity> 'and so on
  </ordercust>
  <orderproducts>
    <orderitem>
      <itemnumber>222</itemnumber>
      <itemname>toothpaste</itemname>
      <itemqty>3</itemqty>
      <itemprice>12.123</itemprice>
    </orderitem>
    <orderitem>
      <itemnumber>111</itemnumber>
      <itemname>tooth brush</itemname>
      <itemqty>1</itemqty>
      <itemprice>1.53</itemprice>
    </orderitem>
    <orderitem>
      <itemnumber>555</itemnumber>
      <itemname>mouthwash</itemname>
      <itemqty>2</itemqty>
      <itemprice>3.50</itemprice>
    </orderitem>
  </orderproducts>
</order

The first part (ordercust) is customer info that is provided through a web form. The second part of the xml document is the product or item information which I need to pul from a data set.... for each xml document, there will be only 1 ordercust entry and as many orderitems as products put into there cart. It has to follow this format because it gets sucked into another system that I have no control over.

The second part of my issues is getting my output formated. Here is some of my code that does not do the job:

' sets outputted file name and path
Dim strXFile As String = "~/App_Data/xmlOrders/" + CustNumber + "-" + OrderID + "-" + sDate.ToString(Format) + ".xml"

'file setting for format
Dim settings As New XmlWriterSettings() 
settings.Indent = True
settings.NewLineOnAttributes = True

' Create a new XmlTextWriter instance
Dim writer As New XmlTextWriter(Server.MapPath(strXFile), Encoding.UTF8)

And here is also another issue... I would have thought to put the settings after the encodeing.utf8 but here I get an error that there are to many attributes:

   writer.WriteStartDocument()
   writer.WriteStartElement("order")
        
   writer.WriteStartElement("ordercust")
        
   writer.WriteElementString("ordernum", intOrder)
   writer.WriteElementString("customername", strName)
   writer.WriteElementString("customeraddr", straddr)
   writer.WriteElementString("customercity", strCity)
   
   writer.WriteEndElement()

' Somehow this is where I need to have my dataset??? just how?

   writer.WriteStartElement("orderproducts")
   writer.WriteStartElement("orderitem")
   
   writer.WriteElementString("itemnumber", intItem)
   writer.WriteElementString("itemname", strItem)
   writer.WriteElementString("orderqty", intQty)
   writer.WriteElementString("itemprice", dblPrice)

'close dataset??

   writer.WriteEndElement()
   writer.WriteEndElement()

'ending and closing the xml doc

   writer.WriteEndElement()
   writer.WriteEndElement()
   writer.WriteEndDocument()
   writer.Close()

The abover is a very simplied structure but if I could get a working sample I can figure the rest of it out? Am I going about this all wrong?

Any and all help is appreciated.... thanks.

Bob B.
aDigitalHost.com

Reply

Kevin Shen -...

All-Star

16806 Points

2777 Posts

Microsoft

Re: xmwriter and dataset plus formating issues

May 14, 2014 02:33 AM|Kevin Shen - MSFT|LINK

Hi bobmmp,

For your problem,I suggest you can try to use Linq to xml to create new element and add to xml.

About your post ,I write a sample for you in c#.Here is my code:

First xml file:

<order>
  <ordercust>
    <ordernumber>123</ordernumber>
    <customername>john doe</customername>
    <customeraddr>123 test lane</customeraddr>
    <customercity>City Name</customercity>
  </ordercust>
  <orderproducts>
 
  </orderproducts>
</order>

Here is sercer code:

    protected void Button3_Click(object sender, EventArgs e)
        {
            XElement ex = XElement.Load(Server.MapPath("XMLFile2.xml"));
           //you can find ordercust node ,add child to it
            //XElement tx=ex.Element("ordercust");
            //tx.Add(new XElement("name","value"));

            //find the orderproducts node,
            XElement eo = ex.Element("orderproducts");
            //get the data from database or dataset
            DataTable dt=getDataTable();

            foreach (DataRow dr in dt.Rows) {
                XElement ex1 = new XElement("orderitem");
                ex1.Add(new XElement("itemnumber", dr[0]));
                ex1.Add(new XElement("itemname", dr[1]));
                ex1.Add(new XElement("itemqty", dr[2]));
                ex1.Add(new XElement("itemprice", dr[3]));
                eo.Add(ex1);
            }

            ex.Save(Server.MapPath("XMLFile2.xml"));

        }

DataTable  getDataTable() {
            DataTable dt = new DataTable();
            dt.Columns.Add("itemnumber", typeof(int));
            dt.Columns.Add("itemname", typeof(string));
            dt.Columns.Add("itemqty", typeof(int));
            dt.Columns.Add("itemprice", typeof(decimal));


            DataRow dr1 = dt.NewRow();
            dr1["itemnumber"] = 222;
            dr1["itemname"] = "toothpaste";
            dr1["itemqty"] = 3;
            dr1["itemprice"] = 12.123;


            DataRow dr2 = dt.NewRow();
            dr2["itemnumber"] = 111;
            dr2["itemname"] = "tooth brush";
            dr2["itemqty"] = 1;
            dr2["itemprice"] = 1.53;

            dt.Rows.Add(dr1);
            dt.Rows.Add(dr2);

            return dt;

        }

About how to use LINQ to XML ,please refer to link below:

http://msdn.microsoft.com/en-us/library/bb387061.aspx

Hope it can help you.

Best Regards,

Kevin Shen.

Please Mark as Answer If it help you,thanks

Reply

bobmmp

Member

542 Points

278 Posts

Re: xmwriter and dataset plus formating issues

May 14, 2014 11:44 AM|bobmmp|LINK

I would if I could.... this is a legacy project on asp.net 2.0

Bob B.
aDigitalHost.com

Reply

Kevin Shen -...

All-Star

16806 Points

2777 Posts

Microsoft

Re: xmwriter and dataset plus formating issues

May 15, 2014 12:23 AM|Kevin Shen - MSFT|LINK

Hi bobmmp,

you can use XmlDocument to select specify node,and add XElement to the node ,just like below:

DataTable dt = getDataTable();
            XmlDocument xmlDoc = new XmlDocument();
            xmlDoc.Load(Server.MapPath("XMLFile2.xml"));


            XmlNode root = xmlDoc.DocumentElement.SelectSingleNode("orderproducts");


            foreach (DataRow dr in dt.Rows) {
                XmlNode orderitem = xmlDoc.CreateElement("orderitem");
                XmlElement itemnumber = GetXmlElement(xmlDoc, "itemnumber", dr[0].ToString());
                XmlElement itemname = GetXmlElement(xmlDoc, "itemnumber", dr[1].ToString());
                XmlElement itemqty = GetXmlElement(xmlDoc, "itemnumber", dr[2].ToString());
                XmlElement itemprice = GetXmlElement(xmlDoc, "itemnumber", dr[3].ToString());
                orderitem.AppendChild(itemnumber);
                orderitem.AppendChild(itemname);
                orderitem.AppendChild(itemqty);
                orderitem.AppendChild(itemprice);
                root.AppendChild(orderitem);
              
            }

Hope it can help you.

Best Regards,

Kevin Shen.

Please Mark as Answer If it help you,thanks

xmwriter and dataset plus formating issues [Answered]RSS

3 replies

Shortcuts

xmwriter and dataset plus formating issues

Re: xmwriter and dataset plus formating issues

Re: xmwriter and dataset plus formating issues

Re: xmwriter and dataset plus formating issues