I use following loop in asp.

<table align=center border="1" bordercolor="black" cellspacing="1" cellpadding="1" border=1 width="1100" height="15">
  <tr bgcolor=c0c0c0>

<th width="80" height="9" bgcolor="#C0C0C0"><span style="font-weight: 400">
    <em style="font-style: normal"><strong>
      Employee No</strong></em></span></th>
........ // all heading, before beginning the loop.

 </tr>

do while rs.eof=false
Response.Write("<td>" & rs("empno") & "</td>")
Response.Write("<td>" & rs("Name") & "</td>")
Response.Write("<td>" & rs("dept") & "</td>")
...........

rs.movenext
loop

</table>


how can display two color in each row ?
ie one row print data in light bue and next line (second line) print data in light green color.
1. light blue row
2. light green row
3. light blue row
4. light green row
5. ........
and so on.............

regards.

Mateen

dim v
v = 1
do while rs.eof=false
if v mod 2 = 0 then
   Response.Write("<tr bgcolor=blue>")
else
   Response.Write("<tr bgcolor=green>")
end if
Response.Write("<td>" & rs("empno") & "</td>")
Response.Write("<td>" & rs("Name") & "</td>")
Response.Write("<td>" & rs("dept") & "</td>")
...........
v = v + 1
rs.movenext
loop

Hope this helps..


Om Prakash

thanks for coding.

regards.

Mateen