C# Convert xml to datatable

BlackSwan answered on May 13, 2022 Popularity 8/10 Helpfulness 4/10

answer C# Convert xml to datatable

C# Convert xml to datatable

Comment

/// <summary>
        /// Convert XML to DataTable
        /// </summary>
        /// <param name="filePath">XML FIle Path</param>
        /// <returns>DataTable</returns>
        public DataTable Read(string filePath)
        {
            try
            {
                XmlDocument document = new XmlDocument();
                document.Load(filePath);
                XmlNode parent = document.DocumentElement.ChildNodes.Cast<XmlNode>().ToList()[0];
                //Column 
                foreach (XmlNode column in parent)
                {
                    dt.Columns.Add(column.Name, typeof(string));
                }

                XmlElement root = document.DocumentElement;
                XmlNodeList childNodes = root?.ChildNodes;

                for (int i =0; i <= childNodes.Count - 1; i++)
                {
                    XmlNode child = document.DocumentElement.Cast<XmlNode>().ToList()[i];
                    List<string> rContent = new List<string>();
                    //rows
                    foreach (XmlNode item in child)
                    {
                        rContent.Add(item.InnerText);
                    }

                    dt.Rows.Add(rContent.ToArray());
                    rContent.Clear();
                }
                return dt;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }

Popularity 8/10 Helpfulness 4/10 Language csharp

Source: Grepper

Tags: c# datatable xml

Link to this answer
Share Copy Link

Contributed on May 13 2022

BlackSwan

0 Answers Avg Quality 2/10

C# Convert xml to datatable

Contents

More Related Answers

C# Convert xml to datatable

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.