将ASP记录集输出成n列的表格形式显示的方法
2018-09-06 11:28
定义变量
Dim cn,rs,Sql
Sql = select CustomerID from Orders
记录总数
Dim TotalNumbe
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
下一篇：如何防范ASP木马
文章标题：将ASP记录集输出成n列的表格形式显示的方法
文章链接：http://soscw.com/index.php/essay/9402.html