xml parse to class

You can acheive by using following way..

first xml data into DataTable

then Convert DataTable to List of Class

// Conversion Xml file to DataTable
public DataTable CreateDataTableXML(string XmlFile)
{
XmlDocument doc = new XmlDocument();
doc.Load(XmlFile);
DataTable Dt = new DataTable();
try
{
Dt.TableName = GetTableName(XmlFile);
XmlNode NodoEstructura = doc.DocumentElement.ChildNodes.Cast().ToList()[0];
progressBar1.Maximum = NodoEstructura.ChildNodes.Count;
progressBar1.Value = 0;
foreach (XmlNode columna in NodoEstructura.ChildNodes)
{
Dt.Columns.Add(columna.Name, typeof(String));
Progress();
}
XmlNode Filas = doc.DocumentElement;
progressBar1.Maximum = Filas.ChildNodes.Count;
progressBar1.Value = 0;
foreach (XmlNode Fila in Filas.ChildNodes)
{
List<string> Valores = Fila.ChildNodes.Cast().ToList().Select(x => x.InnerText).ToList();
Dt.Rows.Add(Valores.ToArray());
Progress();
}
}
catch (Exception ex)
{
}
return Dt;
}

Data Table to List of Class

public List DataTableToList(DataTable table) where T : class, new()
{
try
{
List list = new List();
foreach (var row in table.AsEnumerable())
{
T obj = new T();
foreach (var prop in obj.GetType().GetProperties())
{
try
{
PropertyInfo propertyInfo = obj.GetType().GetProperty(prop.Name);
propertyInfo.SetValue(obj, Convert.ChangeType(row[prop.Name], propertyInfo.PropertyType), null);
}
catch
{
continue;
}
}
list.Add(obj);
}
return list;
}
catch
{
return null;
}
}

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Altaf Ansari8y ago
You can acheive by using following way..
first xml data into DataTable
then Convert DataTable to List of Class
// Conversion Xml file to DataTable
public DataTable CreateDataTableXML(string XmlFile)
{
    XmlDocument doc = new XmlDocument();

    doc.Load(XmlFile);

    DataTable Dt = new DataTable();

    try
    {
        Dt.TableName = GetTableName(XmlFile);
        XmlNode NodoEstructura = doc.DocumentElement.ChildNodes.Cast().ToList()[0];
        progressBar1.Maximum = NodoEstructura.ChildNodes.Count;
        progressBar1.Value = 0;
        foreach (XmlNode columna in NodoEstructura.ChildNodes)
        {
            Dt.Columns.Add(columna.Name, typeof(String));
            Progress();
        }

        XmlNode Filas = doc.DocumentElement;
        progressBar1.Maximum = Filas.ChildNodes.Count;
        progressBar1.Value = 0;
        foreach (XmlNode Fila in Filas.ChildNodes)
        {
            List<string> Valores = Fila.ChildNodes.Cast().ToList().Select(x => x.InnerText).ToList();
            Dt.Rows.Add(Valores.ToArray());
            Progress();
        }
    }
    catch (Exception ex)
    {

    }
    return Dt;
}

Data Table to List of Class
public List DataTableToList(DataTable table) where T : class, new()
       {
           try
           {
               List list = new List();

               foreach (var row in table.AsEnumerable())
               {
                   T obj = new T();

                   foreach (var prop in obj.GetType().GetProperties())
                   {
                       try
                       {
                           PropertyInfo propertyInfo = obj.GetType().GetProperty(prop.Name);
                           propertyInfo.SetValue(obj, Convert.ChangeType(row[prop.Name], propertyInfo.PropertyType), null);
                       }
                       catch
                       {
                           continue;
                       }
                   }

                   list.Add(obj);
               }

               return list;
           }
           catch
           {
               return null;
           }
       }
0