hi Guys,
I have this code:
Code:
Dim table As DataTable = New DataTable()
table = BL.GetPeople(1)
If (table.Rows.Count > 0) Then
Dim doc = <?xml version="1.0"?>
<Registration xmlns="">
<Header>
</Header>
<%= From people As DataRow In table.Rows _
Order By people("LearnerSurname") _
Select <Information>
<Biographical>
<Record>
<LearnerSurname><%= people("LearnerSurname") %></LearnerSurname>
<LearnerName1><%= people("LearnerName1") %></LearnerName1>
<LearnerName2><%= people("LearnerName2") %></LearnerName2>
</Record>
</Biographical>
'insert code here
</Information> %>
Now just before the closing of the </Information> node I need to insert a few more nodes based on the rows of another datatable but using a field called peopleid from the datarow above.
I need to do something like:
Code:
dim dtSubjects as datatable = bl.GetSubjectsByPeopleID(people("peopleid")
if dtSubjects.rows.count > 0 then
<%= From subject As DataRow In dtSubjects.Rows _
Select <Subject xmlns="">
<Code><%= subject("code") %></Code>
</Subject>%>
end if
Please help me.