load xml file with particular atribute wise

Question

Please check main xml file present in belowcheck once Priyaranjan 29 Bangalore Sanjeev 28 Hyderabad 1 2 3 Prakash 29 Odisha Swetha 22 Hyderabad 11 22 33 MY REquirement is : This is my xml file.with TP Version 1.0 & 2.0.I am using code for load xml file to dataset ds.ReadXml(filename);//Filename is the path of xml file. so its loaded ATLASTPProcedureTestHistory table in dataset not consider about the Tp attribute Version No. My requirement is i want to load same table but only particular Version related data : suppose Version=1.0 I want only Priyaranjan 29 Bangalore Sanjeev 28 Hyderabad 1 2 3

Dipankar Biswas · Answer

Hi.. Check this link to help.. http://csharp.net-informations.com/xml/how-to-read-xml.htm

priyaranjan panda · Answer

Hi Sanjeeb I trid by using XpathI also fetch data correctly & failed to bind xml data in datatable.This is my code.. XPathDocument doc = new XPathDocument(fileName); XPathNavigator nav = doc.CreateNavigator(); XPathExpression expr; expr = nav.Compile(/ATLAS/TP[@VERSION='+VersionNumber+']); XPathNodeIterator iterator = nav.Select(expr);//here xml file is null DataTable dt= new DataTable(); while (iterator.MoveNext())//here only xm file loaded accourding to Version { //iterator.Current.Innerxml having VERSION attribute wise xml file. //Now how to bind this xml file in Datatable dt. } Check it once......

Sanjeeb Lenka · Answer

Use XPATH