lunes, 28 de mayo de 2012

serialize desserialize xml2Datatable and dataTable2xml

Como pasar, convertir, trasformar de xml a datatable y de datatable a xml,

convert transform, Serialize datatable to xml and deserialize xml to datatable

      private void xml2DataTable()
        {
            XmlDocument xmlAPDP = new XmlDocument();
            xmlAPDP.LoadXml(_xmlSource);
            dataSet = new DataSet();
            using (XmlReader xmlReader = new XmlNodeReader(xmlAPDP))
            {
                dataSet.ReadXml(xmlReader, XmlReadMode.ReadSchema);
                xmlReader.Close();
            }
            this._dataTable = dataSet.Tables[0];
        }

         private void dataTable2Xml()
        {
            StringBuilder sb;
            StringWriter sw;

            sb = new StringBuilder();
            sw = new StringWriter(sbSQL);

            _dataTable.WriteXml(sw, XmlWriteMode.WriteSchema);
            _xmlSource = sb.ToString();
        }

No hay comentarios:

Publicar un comentario