File Manager

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE> New Document </TITLE>
<META NAME="Generator" CONTENT="EditPlus">
<META NAME="Author" CONTENT="">
<META NAME="Keywords" CONTENT="">
<META NAME="Description" CONTENT="">
</HEAD>

<BODY>
<%

response.write "<br>"

sqldata="select * from qn"
 set orsdata = Server.CreateObject("adodb.recordset")
 orsdata.open sqldata,conn,1,3
 if not orsdata.eof then
%>
<table>
<tr>
<%
	orsdata.movefirst
	 x=1
  do while not orsdata.eof 
  response.write "<tr><td>"
  response.write x&"<td>"&orsdata("stu_name")&" "&orsdata("stu_sur")

response.write "<td>"&orsdata("edu")&"</td><td>"&orsdata("type_edu")&"</td><td>"&orsdata("nom")&"</td><td>"&orsdata("year_entry")&"</td><td>"&orsdata("after_fedu")&"</td><td>"&orsdata("after_fedu_y")&"</td><td>"&orsdata("workpre")
  response.write "<td>"&orsdata("workname")&"</td><td>"&orsdata("workadd")&"</td><td>"&orsdata("workpo")&"</td><td>"&orsdata("work_po_name")&"</td><td>"&orsdata("worktrue")&"</td><td>"&orsdata("salary")&"</td><td>"&orsdata("id_goodness")
  response.write "<td>"&orsdata("g_name")&"</td><td>"&orsdata("g_type")&"</td><td>"&orsdata("g_year")&"</td><td>"&orsdata("g_auther")&"</td><td>"&orsdata("p_thesis")&"</td><td>"&orsdata("id_prize")&"</td><td>"&orsdata("p_name")&"</td>"
  response.write "<td>"&orsdata("p_name")&"</td><td>"&orsdata("p_auther")&"</td><td>"&orsdata("p_year")&"</td><td>"&orsdata("other_ac")&"</td><td>"&orsdata("social_ac")&"</td><td>"&orsdata("comment")&"</td><td>"&orsdata("id_present")&"</td>"
  response.write "<td>"&orsdata("pre_name")&"</td><td>"&orsdata("pre_journal")&"</td><td>"&orsdata("premeeting")&"</td><td>"&orsdata("datetime")&"</td><td>"&orsdata("nmobile")&"</td><td>"&orsdata("nemail")&"</td><td>"&orsdata("naddress")&"</td></tr>"
  x=x+1
  orsdata.movenext
  loop

%>
</tr>
</table>

end if
response.write sqldata
response.write "<meta http-equiv='refresh' content ='0;url=qn2.asp'>"

</BODY>
</HTML>

File Manager

Editing: alumni/all_alumni.asp