Build a website from the ground up by first learning the fundamentals of HTML5 and CSS3, the two popular programming languages used to present content online. HTML deals with fonts, colors, graphics, and hyperlinks, while CSS describes how HTML elements are to be displayed.
How cam I xtract xml content into a new stream
Hello all
Below is a complete xml file. I would like to extract the following tag <SearchResults> and all it's content into a new stream using c#
Note I DO NOT want <SearchResults xmlns:i="http://www.w3.org/2001/XMLSchema-instance"> tag
I WANT <SearchResults> and all it's contents
Sorry if I was rude in using capitals!!!
Here goes the xml:
<s:Envelope xmlns:s="http://schemas.xmlsoap.org/soap/envelope/">
<s:Body>
<VacancyDetailsResponse xmlns="http://Navms.Ms.ExternalInterfaces/2011">
<MessageId>8d947e6f-f3c2-4
<SearchResults xmlns:i="http://www.w3.org/2001/XMLSchema-instance">
<AVMSHeader>
<ApprenticeshipVacanciesDe
<ApprenticeshipVacanciesUR
</AVMSHeader>
<SearchResults>
<VacancyFullData>
<VacancyLocationType>Stand
<VacancyAddress>
<AddressLine1>Kelvin Place</AddressLine1>
<AddressLine2/>
<AddressLine3/>
<AddressLine4/>
<AddressLine5/>
<County>Norfolk</County>
<GridEastM>585823</GridEas
<GridNorthM>281921</GridNo
<Latitude>52.4033195889</L
<Longitude>0.7319373790</L
<PostCode>IP24 3RR</PostCode>
<Town>Thetford</Town>
</VacancyAddress>
<ApprenticeshipFramework>P
<ClosingDate>2012-11-30T00
<ShortDescription>Great opportunity to work for a successful company in Thetford as a Manufacturer / Machinist.</ShortDescripti
<EmployerName>Polypads Limited</EmployerName>
<LearningProviderName>Deli
<NumberOfPositions>1</Numb
<VacancyTitle>Manufacturer
<CreatedDateTime>2012-10-0
<VacancyReference>98571</V
<VacancyType>IntermediateL
<VacancyUrl>https://apprenticeshipvacancymatchingservice.lsc.gov.uk/NAVMS/Forms/Vacancy/VacancyDetails.aspx?Query=WgjHmG7hReZCalVznA0EzjTdgvTfmmXSS787Cl2KUOjAF0b6anssFkf0eoS3q02D1QEkH6w2AGnOpwHWszd%2bSPVQQaoRu5gPdXVyZlziKMJg0bJb9PJ1Axze9JCU5Mu4OcsJCktAOaW0ztnbbmujGMflOqnj9KKyxb8M2gXAxGGG7lW2Qo6sW62SndaKjHslTWXkGR8nydthAigiaEXo8Nd05GmR0TdmqDXPXwbWsCE2nUu9d8UpfE3eZDds%2bLx3z5N34NtrO8hFbaXB%2fHmNXg%3d%3d</VacancyUrl>
<FullDescription><
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You can try something along these lines:
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Xml.Linq;
namespace ConsoleApplication46
{
class Program
{
static void Main(string[] args)
{
XDocument xdoc = XDocument.Load("input.xml");
MemoryStream newStream = new MemoryStream();
XNamespace i = "http://Navms.Ms.ExternalInterfaces/2011";
IEnumerable<XElement> searchResults = xdoc.Descendants(i + "SearchResults")
.Descendants(i + "SearchResults");
searchResults.First().Save(newStream);
}
}
}
Sorry for offtopic, why do you want to get rid of xmlns:i? It's just a declaration of an alias for the namespace, while the element itself does not belong to that namespace, so the declaration does not make your post-processing any harder.
Hi sorry for the delay in replying
Thanks for the above help, I will give it a try later today and update you
As to the offtopic comment:
I am putting the fragment into a datatable which I will then staore to an sql database, this works fine and seems staright forward, but if I try loading the whole documnet into a datatable I get errors, I'm a bit new this and have chosen the path of least resistance!!!
Thanks for the above help, I will give it a try later today and update you
As to the offtopic comment:
I am putting the fragment into a datatable which I will then staore to an sql database, this works fine and seems staright forward, but if I try loading the whole documnet into a datatable I get errors, I'm a bit new this and have chosen the path of least resistance!!!
@JustAndrei
Hopefully I'll be corrected if I am wrong ; )
I initially thought he was trying to strip out the alias, but I looked a bit closer and there are actually two SearchResults elements--one a descendant of the other. The ancestor has the namespace declaration whereas the descendant does not. The code above reflects trying to get the descendant, not the ancestor.
Hopefully I'll be corrected if I am wrong ; )
I initially thought he was trying to strip out the alias, but I looked a bit closer and there are actually two SearchResults elements--one a descendant of the other. The ancestor has the namespace declaration whereas the descendant does not. The code above reflects trying to get the descendant, not the ancestor.
Oh, I didn't notice there were two elements, so I thought Puds32 wanted to remove the declaration. Now it seems the descendant is needed indeed. Sorry, it's my mistake.
Btw, kaufmed, I suspect your code may output namespace navms.ms... Doesn't it? (I haven't tried)
I'm asking because Puds32 seems to want to get rid of all namespaces.
I'm asking because Puds32 seems to want to get rid of all namespaces.
Hi kaufmed
Your solution seems to have worked beautifully, the resulting xml fragment loaded into a datatable and that desplayed in a grid
Hi JustAndrei
You right it did include a namespace in the fragment, but this didn't seem to stop it loading into a datatable so I can live with it, if you know how to get rid of the namespace that would be good
Thanks to you both
Regards Puds32
Your solution seems to have worked beautifully, the resulting xml fragment loaded into a datatable and that desplayed in a grid
Hi JustAndrei
You right it did include a namespace in the fragment, but this didn't seem to stop it loading into a datatable so I can live with it, if you know how to get rid of the namespace that would be good
Thanks to you both
Regards Puds32
Premium Content
You need an Expert Office subscription to comment.Start Free Trial