|
![]() |
名片设计 CorelDRAW Illustrator AuotoCAD Painter 其他软件 Photoshop Fireworks Flash |
|
color.asp <% Const adInteger = 3 Const adVarChar = 200 \\\' 声明变量 Dim myRecordset Dim iLetter Dim Field Dim strAltColor Dim bColor bColor = False \\\' 此例利用内存中的recordset,你需要做的只是修改你的数据显示的部分就可以了。 Set myRecordset = Server.CreateObject("ADODB.Recordset") myRecordset.Fields.Append "ID", adInteger myRecordset.Fields.Append "Title", adVarChar, 25 myRecordset.Fields.Append "Description", adVarChar, 255 myRecordset.Open \\\' Fill RS with sample data: For iLetter = Asc("A") To Asc("M") myRecordset.AddNew myRecordset.Fields("ID").Value = iLetter - 64 myRecordset.Fields("Title").Value = "字母:" & Chr(iLetter) myRecordset.Fields("Description").Value = "这里测试字母:" & Chr(iLetter) & "." myRecordset.Update Next \\\'iLetter \\\'移动到头部开始位置,以便下面的循环开始. myRecordset.MoveFirst \\\' 在表格中显示数据 Response.Write "<table border=""0"" cellspacing=""0"" cellpadding=""3"">" & vbCrLf \\\'表头 Response.Write vbTab & "<tr>" & vbCrLf For Each Field in myRecordset.Fields Response.Write vbTab & vbTab & "<td bgcolor=""#CCCCCC""><strong>" Response.Write Field.Name Response.Write "</strong></td>" & vbCrLf Next \\\'Field Response.Write vbTab & "</tr>" & vbCrLf Do While Not myRecordset.EOF \\\' 循环改变单元格的背景颜色 bColor = Not bColor If bColor Then strAltColor = "#FFFFFF" Else strAltColor = "#FF8040" End If \\\'循环改变单元格的背景颜色 Response.Write vbTab & "<tr>" & vbCrLf For Each Field in myRecordset.Fields Response.Write vbTab & vbTab & "<td bgcolor=""" Response.Write strAltColor Response.Write """>" & Field.Value & "</td>" & vbCrLf Next \\\'Field Response.Write vbTab & "</tr>" & vbCrLf myRecordset.MoveNext Loop \\\' End the table Response.Write "</table>" & vbCrLf \\\' 关闭对象、释放资源 myRecordset.Close Set myRecordset = Nothing %> 返回类别: 教程 上一教程: ASP组件高级入门与精通系列之三 下一教程: 最简化分页程序,附源代码 您可以阅读与"制做行背景颜色交替变换的表格"相关的教程: · 实现可动态改变宽度的表格简朴方式 · 面向对象的ASP编程之六-用于自动显示RECORDSET的表格 · 将ASP纪录集输出成N列的的表格形式显示的方式 · 分栏显示记录集的表格演示,并实现了分页 · ASP与电子表格EXCEL的交互操作 |
![]() ![]() |
快精灵印艺坊 版权所有 |
首页![]() ![]() ![]() ![]() ![]() ![]() ![]() |