将ASP纪录集输出成n列表格的方法
时间:2008-03-19 13:27:00
前些日子有网友问:将ASP纪录集输出成n列的的表格形式显示的方法?
现在写了一个,方便大家使用。
'定义变量
Dim cn,rs,Sql
Sql = "select CustomerID from Orders"
'记录总数
Dim TotalNumbe
Set cn = Server.CreateObject("ADODB.Connection")
cn.Open "Provider=SQLOLEDB.1;User ID=sa;Initial Catalog=NorthWind;Data Source=.;Password=;"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open Sql, cn, 3, 1
TotalNumber = rs.RecordCount
If TotalNumber = 0 Then
Response.Write "没有记录输出。"
Else
Dim jj,nLeft,cCol
jj = 0
nCol = 415
nLeft = nCol- (TotalNumber Mod nCol)
If nLeft = nCol Then nLeft = 0
Response.Write "<table border><tr>" & vbCrLf
While not rs.EOF
Response.Write "<td>" & rs("CustomerID") & "</td>" & vbCrLf
'If (jj Mod nCol) = (nCol - 1) And jj <> TotalNumber - 1 Then Response.Write "</tr><tr>" & vbCrLf
'If (jj Mod nCol) = (nCol - 1) And jj = TotalNumber-1 Then Response.Write "</tr>" & vbCrLf
If (jj Mod nCol) = (nCol - 1) Then
If jj <> TotalNumber - 1 Then
Response.Write "</tr><tr>" & vbCrLf
Else
Response.Write "</tr>" & vbCrLf
End If
End If
jj = jj + 1
rs.MoveNext
Wend
If nLeft <> 0 And nLeft <> nCol Then
If nCol < TotalNumber Then
For i = 1 to nLeft
Response.Write "<td> </td>" & vbCrLf
Next
End If
Response.Write "</tr>" & vbCrLf
End If
Response.Write "</table>"
End If
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
Response.End
标签:表格,记录,sql
0
投稿
猜你喜欢
用不着妄自菲薄对ASP和ASP程序员的一些话
2007-08-22 15:09:00
WEB移动应用框架构想
2010-09-28 16:26:00
sqlserver中获取月份的天数的方法分享
2011-09-30 11:27:52
SQL 2008邮件故障排除:发送测试电子邮件
2008-12-02 14:28:00
关于reflow
2007-09-23 13:30:00
浅谈javascript面向对象编程
2009-03-03 12:04:00
不用为美化select烦恼模仿combox(select)控件
2007-08-04 21:08:00
ASP程序员面试题
2011-09-15 20:51:20
asp防止盗链HTTP_REFERER判断代码
2010-03-12 10:41:00
浅析网页色彩应用
2009-12-21 16:17:00
合理利用页面标签元素有利用搜索引擎收录
2008-11-03 11:49:00
配置SQL Server以允许远程连接
2010-03-08 13:12:00
WAP设计基础
2011-01-06 12:13:00
关于CSS中字号控制的兼容性研究[译]
2009-02-24 16:35:00
如何编写一个过滤掉HTML代码的函数?
2009-11-08 18:53:00
ASP同一站点不同编码程序出现乱码解决办法
2008-11-10 12:08:00
Asp的上下午时间格式问题
2009-04-13 16:06:00
请谨慎对待程序的图标和名称
2011-06-16 20:35:22
mysql myisam 优化设置
2010-03-25 10:18:00
PHP结构型模式之代理模式
2023-05-25 06:55:34