General

Re: loop through repeated section

Potemkine — Sun, 16 Jan 2011 14:36:34 GMT

Hi, as Jimmy said you have to use relative Xpath:
string EmplID = rows.Current.SelectSingleNode("EMPLID", NamespaceManager).Value;
instead of
string EmplID = rows.Current.SelectSingleNode("/dfs:myFields/dfs:dataFields/tns:GetEmployeeDataResponse/tns:GetEmployeeDataResult/NewDataSet/EmplEdu/EMPLID", NamespaceManager).Value;

Re: loop through repeated section

Amigo1982 — Sun, 16 Jan 2011 13:04:59 GMT

I didnt understand

Re: loop through repeated section

Jimmy — Sun, 16 Jan 2011 12:56:28 GMT

Two words: relative XPath.

loop through repeated section

Amigo1982 — Sun, 16 Jan 2011 11:51:30 GMT

Hi, i m trying to do loop through rows in repeating table, i managed to do that. if there is 3 lines i m able to to loop 3 times but the the value are not changing they keep the first line data

here is my code:

XPathNavigator navigator = MainDataSource.CreateNavigator();
XPathNodeIterator rows = navigator.Select("/dfs:myFields/dfs:dataFields/tns:GetEmployeeDataResponse/tns:GetEmployeeDataResult/NewDataSet/EmplEdu", NamespaceManager);

while (rows.MoveNext())

{

string EmplID = rows.Current.SelectSingleNode("/dfs:myFields/dfs:dataFields/tns:GetEmployeeDataResponse/tns:GetEmployeeDataResult/NewDataSet/EmplEdu/EMPLID", NamespaceManager).Value;

string Education = rows.Current.SelectSingleNode("/dfs:myFields/dfs:dataFields/tns:GetEmployeeDataResponse/tns:GetEmployeeDataResult/NewDataSet/EmplEdu/Education", NamespaceManager).Value;
string Desc = rows.Current.SelectSingleNode("/dfs:myFields/dfs:dataFields/tns:GetEmployeeDataResponse/tns:GetEmployeeDataResult/NewDataSet/EmplEdu/Descr", NamespaceManager).Value;
}