asked on 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><
Last Comment
JustAndrei
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.
ASKER
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.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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
foreach( var e in searchResults.First().DescendantsAndSelf() )
{
e.Name = XNamespace.None.GetName( e.Name.LocalName );
}