>>I was thinking that we want to convert XML to datatable first, but perhaps LINQ to XML will work as well.
>
>What would convert the XML to a datatable ?

I found our implementation of parsing quazi XML string into a dictionary. May be it can help

/*========================================================================================
       *                Dictionary<String, String> from SQML
       *=======================================================================================*/
      /// <summary>
      /// Populates a <string, string> dictionary using a SQML string.    
      /// </summary>
      /// <param name="tDictionary"></param>
      /// <param name="tcSQML"></param>
      public static void PopulateFromSQML(this Dictionary<String, Object> tDictionary, String tcSQML)
      {
         tDictionary.Clear();

         String pattern = @"<(?<field>[^/>]+)>(?<data>.*)</\k<field>>";

         MatchCollection matches = Regex.Matches(tcSQML, pattern, RegexOptions.Singleline);
         foreach (Match m in matches)
         {
            if (!tDictionary.ContainsKey(m.Groups["field"].ToString()))
               tDictionary.Add(m.Groups["field"].ToString(), m.Groups["data"]);
         }
      }