c# - nested loops from classic asp to asp.net webforms -
<% sql ="select distinct qf_id,description vwwqf_avg_4 teacher_id ="&teacher_id &" order qf_id" objrs1.open sql, dbdsn, adopenforwardonly, adlockreadonly count=1 while not objrs1.eof '************************************************ main loop performa questions ******************************** qf_id=objrs1("qf_id") %> <tr> <td align=center><%=count%></td> <td align=left class="fd1"><%=objrs1("description")%></td> <% sql ="select * vwwqf_avg_4 teacher_id ="&teacher_id &" , qf_id = "&qf_id&" order offered_course_id" 'response.write sql & "<br>" objrs2.open sql, dbdsn, adopenforwardonly, adlockreadonly while not objrs2.eof '******************************************** inner loop average in each selected course ************************ %> <td align=center><%=round(objrs2("average"),2)%></td> <% objrs2.movenext wend %> </tr>
i need convert type of code classic asp web forms in asp.net ,
this code iterates on multiple recordsets, 1 record set value given query , record set appended in html, there many this, in whole page, how best translate in asp.net webforms.
Comments
Post a Comment