导航

生成动态表格

Posted on 2004-06-30 17:49  ChenRui  阅读(1416)  评论(5)    收藏  举报
<%@ 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，写了个动态生成表格的web页，隔行同色，见笑了