Archives

Archives / 2005 / May
  • How do I get around the "The same table (xxxx) cannot be the child table in two nested relations" error?

    I bet this is a schoolboy problem but even the mighty google is not helping. I am trying to read chunks of DMOZ RDF xml into a dataset.

    I am getting a "The same table (xxxx) cannot be the child table in two nested relations." error which I think I can sort out by doing a XSL transform .. which is where I am stuck.

    What I am doing is

           Dim DS As DataSet = New DataSet
           DS.ReadXml(MapPath("xml/" + Request("x") + ".xml"))
           DataGrid1.DataSource = DS.Tables("externallinks")
           DataGrid1.DataBind()
           DS = Nothing

    How do I wedge in a transform to take out the offending relation before I do the ReadXml statement?

    The XSL examples I see online either output to a file or use methods that VS is telling me is obselete :O(