<% @ Page Language = " C # " %>
<% @ Import namespace = " System. Data " %>
<% @ Import namespace = " System. Data. oledb " %>
< Script runat = " Server " >
Oledbdatareader Dr;
Public Void Page_load (Object SRC, eventargs E)
... {
String Connstring = " Provider = Microsoft. Jet. oledb.4.0; Data Source = 'e: \ attend. mdb' " ;
String Querystring = " Select studentid, coursename from studentcourse " ;
Oledbconnection myconn = New Oledbconnection (connstring );
Oledbcommand mycomm = New Oledbcommand (querystring, myconn );
Mycomm. Connection. open ();
Dr = Mycomm. executereader ();
}
</ Script >
< Html >
< Head >
</ Head >
< Body >
< Form runat = " Server " >
<! -- Insert content here -->
< Table border = " 1 " >
< Tbody >
< Tr bgcolor = " Yellow " >
< TD >
Studentid </ TD >
< TD >
Coursename </ TD >
</ Tr >
<%
Int I = 0 ;
While (Dr. Read ())
... { %>
< Tr bgcolor = <% = (I % 2 = 0 ) ? " White " : " Yellow " %>
< TD >
<% = Dr [ " Studentid " ]. Tostring () %> </ TD >
< TD >
<% = Dr [ " Coursename " ]. Tostring () %> </ TD >
</ Tr >
< Tr >
<%
I ++ ;}
Dr. Close ();
%>
</ Tr >
</ Tbody >
</ Table >
</ Form >
</ Body >
</ Html >
Asp.net, a beginner, wrote a web page for dynamically generating tables, with the same color in different rows.