Re: creating csv from xml file in c# - C# Discussion Boards

I'm looking to ramp up in learning visual programming with C# for Windows and am wondering what are good resources, such as books or in-depth online breakthroughs. Any good suggestions?

what is your level of knowledge of C#, or let's say the level of programming knowledge?

I'm pretty familiar with C++ and have been working with programming languages for a long while. What I don't understand, and would love to grasp, is how program flow/interactions work with WinForms/WPF, which of the latter to use, and really how to see the whole picture of visual coding for Windows.

I would suggest Wrox publication books for C# and Winforms to begin with

hello guys, I want to create a csv file from xml document, can someone please point me on some article to see how is this done?
Thanks in advance, Laziale

post the xml

<restaurants>
<Business name="someBusiness">
    <Address>
      <Street>someStreet</Street>
      <City>Las Vegas</City>
      <Zip>89169</Zip>
      <State>NV</State>
    </Address>
    <Contact>
      <ContactPerson>someCP</ContactPerson>
      <PhoneNumber>(702) 889-5587</PhoneNumber>
      <MantaWebsite>http://www.sdadas.com</MantaWebsite>
    </Contact>
  </Business>
</restaurants>

thanks for helping me

The easiest way is to dump the xml into a dataset and enumerate throught the rows and write to file. Look at the code below.

        public static void SaveXmlToFile(string xml, string output)
        {
            string seperator = ";";
            DataSet ds = new DataSet();
            DataTable bzTable = null;
            DataTable adTable = null;
            DataTable cntTable = null;
            StringBuilder sb = new StringBuilder();

            //Dump xml into dataset
            using (MemoryStream ms = new MemoryStream())
            {
                using (StreamWriter sw = new StreamWriter(ms))
                {
                    sw.BaseStream.Seek(0, SeekOrigin.Begin);
                    sw.Write(xml);
                    sw.Flush();
                    sw.BaseStream.Seek(0, SeekOrigin.Begin);
                    ds.ReadXml(sw.BaseStream);
                }
            }

            //Set tables after ds has been built
            bzTable = ds.Tables["Business"];
            adTable = ds.Tables["Address"];
            cntTable = ds.Tables["Contact"];

            //Read Business table
            foreach (DataRow bzRow in bzTable.Rows)
            {
                //Get Business_id; Generated when dumping data into ds
                int curBzId = Convert.ToInt32(bzRow["Business_Id"]);

                //Enumerate though business tables and write data into string builder
                foreach (DataColumn bzCol in bzTable.Columns)
                {
                    sb.Append(string.Format("{0}{1}", bzRow[bzCol].ToString(), seperator));
                }

                //Filter Address column for curBzId and write values to string builder
                foreach (DataRow adRow in adTable.Select(string.Format("[Business_Id]={0}", curBzId)))
                {
                    foreach (DataColumn adCol in adTable.Columns)
                    {
                        sb.Append(string.Format("{0}{1}", adRow[adCol].ToString(), seperator));
                    }
                }

                //Filter Contact column for curBzId and write values to string builder
                foreach (DataRow cntRow in cntTable.Select(string.Format("[Business_Id]={0}", curBzId)))
                {
                    foreach (DataColumn cntCol in cntTable.Columns)
                    {
                        sb.Append(string.Format("{0}{1}", cntRow[cntCol].ToString(), seperator));
                    }
                }

                //Row completed.  Add new line constant
                sb.Append(Environment.NewLine);
            }

            //Save file
            using (StreamWriter sw = new StreamWriter(output))
            {
                sw.BaseStream.Seek(0, SeekOrigin.Begin);
                sw.Write(sb.ToString());
                sw.Flush();
            }
ds.Dispose();
bzTable.Dispose();
adTable.Dispose();
cntTable.Dispose();
        }

thanks, that really helped me.
have a nice day, Laziale

I have done that with XSLT, but it's tricky.

I see you posted a snippet of XML, could you also post how you want the CSV to look?

Sorry for such question (I think it was earlier, but my problem is below):

I'm trying to find transparent controls and all I'd found are only ones, which background-transparent, but not on-control-transparent:

picture:
Transparent[^]

As you can see, usual button cannot be seen under glass transparent button.

it's because, in WinForm, transparency is faked by calling OnPaintBackground() of the parent from the child control.

There is no solution I'm afraid...

But it works like a charm in WPF if you must know! Poke tongue | ;-P