Convert Xml to DataTable

Question

I have an XML file I want to insert that in a Datatable  The format of the xml file is like below    lt userid ID  37729  gt     lt TestId ID  84  TimeRemaining  60    gt     lt QuestId ID  1  gt       lt Answer1 gt       lt  Answer1 gt       lt Answer2 gt B lt  Answer2 gt       lt Answer3 gt       lt  Answer3 gt       lt Answer4 gt       lt  Answer4 gt     lt  QuestId gt   lt  userid gt    Now I want to insert that in a data table like below   Question Id     Answer1      Answer2        Answer3        Answer4 1                 A                                         D  2                             B              C       3                                            C                        Can any one help me to achieve this

User · Answer

How To Read XML Data into a DataSet by Using Visual C# .NET contains some details. Basically, you can use the overloaded DataSet method ReadXml to get the data into a DataSet. Your XML data will be in the first DataTable there.

There is also a DataTable.ReadXml method.

User · Answer

You can use this code Recommended    MemoryStream objMS   new MemoryStream     DataTable oDT   new DataTable     Your DataTable which you want to convert  oDT WriteXml objMS    objMS Position   0   XPathDocument result   new XPathDocument objMS     This is another way but first ex  is recommended   StringWriter objSW   new StringWriter    DataTable oDt   new DataTable     Your DataTable which you want to convert oDt WriteXml objSW   string result   objSW ToString

User · Answer

DataSet ds   new DataSet    ds ReadXml fileNamePath

User · Answer

Maybe this could be a little older article  but must of the above answers don  t help me as I need  Then I wrote a little snippet for that    This accepts any XML that hast at least 3 levels  Like this sample     lt XmlData gt       lt XmlRow gt           lt XmlField1 gt Data 1 lt  XmlField1 gt             lt XmlField2 gt Data 2 lt  XmlField2 gt             lt XmlField3 gt Data 3 lt  XmlField3 gt                         lt  XmlRow gt   lt  XmlData gt   public static class XmlParser            lt summary gt          Converts XML string to DataTable          lt  summary gt           lt param name  Name  gt DataTable name lt  param gt           lt param name  XMLString  gt XML string lt  param gt           lt returns gt  lt  returns gt      public static DataTable BuildDataTableFromXml string Name  string XMLString                XmlDocument doc   new XmlDocument            doc Load new StringReader XMLString            DataTable Dt   new DataTable Name           try                        XmlNode NodoEstructura   doc FirstChild FirstChild                  Table structure  columns definition               foreach  XmlNode columna in NodoEstructura ChildNodes                                Dt Columns Add columna Name  typeof String                               XmlNode Filas   doc FirstChild                  Data Rows              foreach  XmlNode Fila in Filas ChildNodes                                List lt string gt  Valores   new List lt string gt                     foreach  XmlNode Columna in Fila ChildNodes                                        Valores Add Columna InnerText                                     Dt Rows Add Valores ToArray                             catch Exception                                return Dt            This solve my problem

User · Answer

I would first create a DataTable with the columns that you require  then populate it via Linq-to-XML   You could use a Select query to create an object that represents each row  then use the standard approach for creating DataRows for each item      class Quest       public string Answer1      public string Answer2      public string Answer3      public string Answer4     public static void Main         var doc   XDocument Load  filename xml         var rows   doc Descendants  QuestId   Select el   gt  new Quest               Answer1   el Element  Answer1   Value          Answer2   el Element  Answer2   Value          Answer3   el Element  Answer3   Value          Answer4   el Element  Answer4   Value                  iterate over the rows and add to DataTable

[c#] Convert Xml to DataTable

Examples related to c#

Examples related to asp.net

Examples related to xml

Examples related to datatable