Asp.net制作滚动条（从数据库读取数据）

1.建立一个UserControl代码如下：

前台：

<table id="tblScrolling" cellspacing="1" cellpadding="1" width="100%" border="0"
    runat="server">
    <tr id="rowScrolling" runat="server">
    </tr>
</table>

后台：

 protected void Page_Load(object sender, EventArgs e)
    {
        // Put user code to initialize the page here
        //SqlConnection myCon = new SqlConnection(ConfigurationSettings.AppSettings["connectionString"]);
        //string strSql = "SELECT * FROM tbl_News order by dateCreated asc";
        string strScrolling = "";
        HtmlTableCell cellScrolling = new HtmlTableCell();
        //SqlCommand myComd = new SqlCommand(strSql, myCon);

        SqlDataReader sqlRdr = JZQYBll.GetNewJZQY();
        try
        {
            //myCon.Open();
            //sqlRdr = myComd.ExecuteReader();

            strScrolling = "<Marquee OnMouseOver='this.stop();' OnMouseOut='this.start();' direction='up' scrollamount='2' bgcolor='#000000' width='40%'>";
            while (sqlRdr.Read())
            {
                strScrolling = strScrolling + "<a href='#' OnClick=" + "javascript:window.open('newsDetail.aspx?NewsId=" + sqlRdr.GetValue(0) + "','NewsDetail','width=400,height=400;toolbar=no;');" + "><font face='verdana' size='2' color='#ffffff'>" + sqlRdr.GetValue(1) + "</a>&nbsp;&nbsp;" + sqlRdr.GetValue(2).ToString() + "</font><br><br>";
            }
            strScrolling = strScrolling + "</Marquee>";
            sqlRdr.Close();
            cellScrolling.InnerHtml = strScrolling;
            rowScrolling.Cells.Add(cellScrolling);
        }
        catch (Exception msg)
        {
            Response.Write(msg.Message);
        }
        finally
        {
            //close sql connection   
            //myCon.Close();
        }
    }

2.在主页上引用就可以了。