Fetch top 50 records from xml

Chandra Sekhar

I need to fetch first 50 records from a XML which return 250 records

Name1

Desc1

Name2

Desc2

Name2

Desc2

Name2

Desc2

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Chandra Sekhar7y ago
I have implemented the same but its not working
0
Arun Kumar Tiwari7y ago
Try this:

XmlDocument xml = new XmlDocument();
xml.LoadXml(myXmlString);
XmlNodeList xNodeList = xml.SelectNodes("/content/post[position() <= 50]");

Now you can iterate over xNodeList to fetch particular value inside the post tag.

You can also select TOP N records from data table then Linq will be better option

dt.AsEnumerable().Take(5);
0
Amit Mohanty7y ago
Hey Chandra Sekher if you are getting response as xml string then try this.
XmlDocument xml = new XmlDocument();
xml.LoadXml(myXmlString);
0
Chandra Sekhar7y ago
While converting it says XMLdocument doenot contain definition for GetResponseStream();

response is a xmldocument.
0
Amit Mohanty7y ago
Convert response to xml.
StreamReader ResponseDataStream = new StreamReader(response.GetResponseStream());
string res = ResponseDataStream.ReadToEnd();

XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(res);
0
Salman Beg7y ago
Hi. You can follow up with this link and in place of 5 you can put 50, https://stackoverflow.com/questions/17231446/select-top-5-records-from-xml-with-c-sharp
0
Chandra Sekhar7y ago
1. XmlDocument xmlDoc = new XmlDocument();
2. xmlDoc.Loadxml(response.outerxml);
3. XmlNodeList nodeList = xmlDoc.DocumentElement.SelectNodes("/rootnode/Step[position() <= 50]");
i have to assign this nodelist to response as i return response.How can i do it?
0

Hey try this.

XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load("[XML PATH]");
XmlNodeList nodeList = xmlDoc.DocumentElement.SelectNodes("/rootnode/Step[position() <= 50]");