WPF read data from XML to list<>

Question

I need to read data from XML to a List<>. The XML file contains three table format XML:

<?xml version="1.0" standalone="yes"?>
<Test>
  <Table1>
    <Column_tb1>8</Column_tb1>
  </Table1>
  <Table2>
    <Column_tb2_AA>1</Column_tb2_AA>
    <Column_tb2_BB>11</Column_tb2_BB>
  </Table2>
  <Table2>
    <Column_tb2_AA>2</Column_tb2_AA>
    <Column_tb2_BB>22</Column_tb2_BB>
  </Table2>
  <Table3>
    <Column_tb3_AA>2</Column_tb1_AA>
    <Column_tb3_BB>1</Column_tb1_BB>
    <Column_tb3_CC>25</Column_tb1_CC>
  </Table3>
</Test>

Dataset can read that quite simple,

DataSet dsProfile = new DataSet();
dsProfile.ReadXml(strProfile);

By this way three datatables will in dsprofile automatic. How can use a list as a container to save XML file data? if only one table format, i can do that:

List<Table1> listtable1 = new List<Table1>();
XmlSerializer serializer = new XmlSerializer(typeof(List<Table1>));
FileStream stream = File.OpenWrite("data.XML");
serializer.Serialize(stream, listtable1);

But there are 3 types of tables in file. What can i do if i still want to use List<>?

Best Regards.

Please remove "WPF" from the titel, your question has nothing to do with it .. — SvenG
– SvenG, Commented Jun 20, 2012 at 8:38

Myrtle · Accepted Answer · 2012-06-20 07:47:07Z

1

I think your approach is not very safe. You can choose to make everything strong-typed and defined by:

Create XSD for the XML file
Use XSD.EXE to generate a serializable class
Use XmlSerializer to deserialize the XML into a class instance
Modify the instance
Use XmlSerializer to serialize back to XML

Another option is to make a base class for the three derived classes. That way the list can still serialize its contents as their derived types. However, the serializer will then serialize type information.

answered Jun 20, 2012 at 7:47

Myrtle

5,87935 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

LIU Over a year ago

Thanks Aphelion, if a choice option 2, XSD still in need?

Myrtle Over a year ago

Well somehow the serializer should know how to serialize. You can either manually create the classes using the XML serialization attributes, or you can use the XSD tool to create them for you based on the XSD.

Ricardo Romo · Accepted Answer · 2014-05-08 21:36:00Z

0

you can use this example

  using (XmlTextReader xmlReader = new XmlTextReader(your file.xml))
      {
          XDocument xdoc = XDocument.Load(xmlReader);
          var programs= from programItem in xdoc.Root.Elements()
                      select new yourclass {
            Id  = Convert.ToInt32( programItem.Attribute("Id").Value),
            value1 = programItem.Attribute("value1").Value,
            value2 = programItem.Attribute("value2").Value
        };

        result = programs.ToList();
    }

answered May 8, 2014 at 21:36

Ricardo Romo

1,60413 silver badges25 bronze badges

Comments

DeshDeep Singh · Accepted Answer · 2015-07-16 13:07:05Z

try this:

ViewModelSerializer viewModelData = ViewModelSerializer.Deserialize(path);
            foreach(ViewModelBase view in viewModelData.Views) {
                WidgetList.Add(view);
            }

viewModelBase.cs File

   /// <summary>
    /// Provides common functionality for ViewModel classes
    /// </summary>
    public abstract class ViewModelBase : INotifyPropertyChanged, IMVVMDockingProperties
    {
        #region Data

        public event PropertyChangedEventHandler PropertyChanged;

        #endregion // Data

        #region Protected Methods

        /// <summary>
        /// Raises event property changed.
        /// </summary>
        /// <param name="propertyName">An property expression representation.</param>
        protected void OnPropertyChanged<T>(Expression<Func<T>> action)
        {
            var propertyName = GetPropertyName(action);
            OnPropertyChanged(propertyName);
        }

        /// <summary>
        /// Raises event property changed.
        /// </summary>
        /// <param name="propertyName">A property name.</param>
        protected void OnPropertyChanged(string propertyName)
        {
            PropertyChangedEventHandler handler = PropertyChanged;

            if (handler != null)
            {
                handler(this, new PropertyChangedEventArgs(propertyName));
            }
        }

        /// <summary>
        /// Helper to set dependency property value.
        /// </summary>
        /// <typeparam name="T">Property type</typeparam>
        /// <param name="target">Target Dependency property</param>
        /// <param name="value">Value to set</param>
        /// <param name="changedProperties">argument list on changed property names we going notify about notify</param>
        /// <returns></returns>
        protected virtual bool SetValue<T>(ref T target, T value, params string[] changedProperties)
        {
            if (Object.Equals(target, value))
            {
                return false; // no changes, same value
            }

            target = value;

            foreach (string property in changedProperties)
            {
                OnPropertyChanged(property);
            }

            return true;
        }

        #endregion // Protected Methods

        #region Private Methods

        /// <summary>
        /// Helper method to get Property name from Expression.
        /// </summary>
        /// <typeparam name="T">Generic type.</typeparam>
        /// <param name="action">Expression.</param>
        /// <returns>A property name.</returns>
        private static string GetPropertyName<T>(Expression<Func<T>> action)
        {
            var expression = (MemberExpression)action.Body;
            var propertyName = expression.Member.Name;
            return propertyName;
        }

        #endregion // Private Methods

        #region IMVVMDockingProperties Members

        public string TargetName { get; set; }

        #endregion
    }
}

Collectives™ on Stack Overflow

WPF read data from XML to list<>

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related