C#

<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>

        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();
        }

Blubbo wrote:

I have 256 textboxes on a GUI