I have this string available to me stored in a varable. How can I transform
this string so that I can use it in a datagrid, to set the headings and fill
the grid?
sXML =
<Results><Result QID="1" Question="Do you make thoughtless remarks or
accusations which you later regret?" AID="1" Response="Yes"
Score="2"/><Result QID="1" Question="Do you make thoughtless remarks or
accusations which you later regret?" AID="3" Response="No"
Score="6"/><Result QID="2" Question="Is it hard on you when you fail?"
AID="3" Response="No" Score="6"/><Result QID="3" Question="When others are
getting rattled do you remain fairly composed?" AID="1" Response="Yes"
Score="6"/><Result QID="4" Question="Do you find yourself being extra active
for periods lasting several days?" AID="3" Response="No" Score="6"/><Result
QID="5" Question="Do you browse through railway timetables, directories or
dictionaries just for pleasure?" AID="1" Response="Yes" Score="6"/><Result
QID="6" Question="Do you resent the efforts of others to tell you what to
do?" AID="3" Response="No" Score="4"/><Result QID="7" Question="When asked
to make a decision would you be swayed by your like or dislike of the
personality involved?" AID="3" Response="No" Score="6"/><Result QID="8"
Question="Is it normally hard for you to "own up and take the
blame"?" AID="3" Response="No" Score="6"/><Result QID="9" Question="Do
you intend two or less children in your family even though your health and
income will permit more?" AID="3" Response="No" Score="5"/><Result QID="10"
Question="Do you have a small circle of close friends rather than a large
number of friends and speaking acquaintances?" AID="3" Response="No"
Score="5"/><Result QID="11" Question="Are your actions considered
unpredictable by others?" AID="3" Response="No" Score="5"/></Results>