How do you load this xml file into datagrid

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

gokujames

Did you try Xml datasource that comes with the .NET framework 3.5 as i am almost near to displaying it without anything other than Xml Datasource.
If you want the exact match , then please use the XPath expression and bind them individually.
Also did you try reading the xml file into a Dataset and then binding them

ASKER

Sorry, yes it is a web service response
I have tried using an XML Datasource but I get the error:
"There was an error renering the control.
The data source for gridview with id 'GridView3' did not have any properties or attributes for which to generate columns. Ensure that your data source has content.

SOLUTION

gokujames

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Hi
From the ns3:Child node and all within - thanks for your help

Can you post the web method declaration?

ASKER

Sorry for the delay in reply, have been side tracked by other work.

Update - I got some way to an acceptable answer using a dataset loaded from a text stream, however when the xml structure became more complicated a problem arrose when repeat nested element names ie address, being used as a child for client and for parent, this stopped the automatic creation of the table structure and caused an error, I think I may be going down the wrong road here.

It looks like I need to use either xpath or Linq, does anybody have a view to either preferrence, and if so direct me to a good resource suitable for thickies

As always thanks to everyone for their time

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

Right xpath it is then

In the above xml fragment do I have to create an xmlnamespace manager, if so what would the following code snippit look like

nsmgr.AddNamespace("", "");

and do I have to add all the namespaces to the manager

Thanks

ASKER

I am starting to have some success!!
The below hooks out the FamilyName. How can I change it to pull out a FamilyName that is equel to a value ie. FamilyName = 'LEWIS1'

Ta

XmlDocument doc = new XmlDocument();
doc.Load("c:\\testFile.xml");
XmlNode root = doc.DocumentElement;

XmlNamespaceManager nmMan = new XmlNamespaceManager(doc.NameTable);

nmMan.AddNamespace("ns1", "http://www.govtalk.gov.uk/Education/ContactPoint/Common");
nmMan.AddNamespace("ns2", "http://www.govtalk.gov.uk/people/bs7666");
nmMan.AddNamespace("ns3", "http://www.govtalk.gov.uk/Education/ContactPoint/Enquiry");
nmMan.AddNamespace("soapenv", "http://schemas.xmlsoap.org/soap/envelope/");

XmlNode nFamilyName = doc.SelectSingleNode("/soapenv:Envelope/soapenv:Body/ns3:SearchResponse/ns3:Child/ns3:Summary/
ns3:ChildName/ns1:FamilyName", nmMan);

if (nFamilyName != null)
{
TextBox2.Text = nFamilyName.InnerXml;
}
}

SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.