How to convert database table to xml file

 

  private static XmlNode xmlBuilder(IDataReader reader)
        {
            XmlDocument xmlDoc = new XmlDocument();
            XmlElement node = xmlDoc.CreateElement("Result");
            xmlDoc.AppendChild(node);
            ArrayList arr = new ArrayList();
            for (int i = 0; i < reader.FieldCount; ++i)
            {
                arr.Add(reader.GetName(i));
            }
            while (reader.Read())
            {
                XmlElement row = xmlDoc.CreateElement("Row");
                for (int i = 0; i < arr.Count; ++i)
                {
                    XmlAttribute att = xmlDoc.CreateAttribute((String)arr[i]);
                    att.Value = reader.GetValue(i).ToString();
                    row.Attributes.Append(att);
                }
                node.AppendChild(row);
            }

            return xmlDoc;
        }