I need to generate the XML dynamically from a dataset for
FCF_MSLine.swf
where i need to generate tags <Categories></categories> and <Dataset></Dataset> dynamically .Please find my code and help me out...
strXML +=
"<categories>";
while (oRs.ReadData.Read()){
strXML += "<category name='" + oRs.ReadData["Day Name"].ToString() + "' />";}
strXML +=
"</categories>";strXML +=
"<dataset seriesName='For Sample Test' color='1D8BD1' anchorBorderColor='1D8BD1' anchorBgColor='1D8BD1'>";
while (oRs.ReadData.Read()){
strXML +=
"<set value='" + oRs.ReadData["Estimated Efforts"].ToString() + "' />";}
strXML +=
" </dataset>";
but the value of oRs.ReadData.Read() becomes false and the second condtion is not executing faling to generate the <dataset > tag...
please help me out.....