asp显示数据问题

来源:百度知道 编辑:UC知道 时间:2024/05/22 19:39:29
请问asp显示数据库问题,显示结果就像百度贴吧http://post.baidu.com/f?ct=&tn=&rn=&pn=&lm=&sc=&kw=asp&rs2=0&myselectvalue=1&word=asp&tb=on

里一行一种颜色(隔行显示数据),我该怎么写呢?
能否详细点,实在不明白,谢谢!
<%
Set rs = Server.CreateObject("ADODB.Recordset")
sql ="Select * From user Order By id desc "
rs.open sql, conn, 1, 1
if rs.bof and rs.eof then
rs.close
response.write "<tr><td colspan='6'><br><center>" & wherestr & "没有符合条件的记录</center><br></td></tr></table></td></tr></table>"
else
dim i
rs.pagesize = pagesize
if rs.pagecount < curpage then
rs.absolutepage=rs.pagecount
curpage=rs.pagecount
else
rs.absolutepage = curpage
end if

do while not rs.eof

....
操作
....

If theLine=1 Then
theColor = "gray"
theLine = 0
Else
theColor = "white"
theLine = 1
End if

....
操作
....

Loop

ASP基础教程
http://www.hlib.cn/search.asp?keyword=asp+%BB%F9%B4%A1

ASP提高篇
http://www.hlib.cn/search.asp?keyword=asp+%CC%E1%B8%DF

ASP数据库编程
http://www.hlib.cn/search.asp?keyword=asp+%CA%FD%BE%DD%BF%E2

应该是这样地,theColor是背景色,

i=1
do while not rs.eof

If i mod 2=0 Then
theColor = "gray"
Else
theColor =