rec2table.asp

来自「ASP+SQL Server动态网站开发从基础到实践教程」· ASP 代码 · 共 24 行

<%
function Rec2Table(objRS)
dim strT
dim fldF

strT="<table width=80% border=1><TR>"

	for each fldF in objRS.Fields	'each feild as colum name
	strT=strT & "<TD>" & fldF.name & "</TD>"
	next
strT=strT & "</TR>"

	while not objRS.eof
	strT = strT & "<TR>"
		for each fldF in objRS.fields
		strT = strT & "<TD>" & fldF.value & "</TD>"
		next
	strT= strT & "</TR>"
	objRS.movenext
	wend
strT = strT & "</TABLE>"
Rec2Table =strT 'return the table string
end function  
%>