1using System;
 2using System.Data;
 3using System.Configuration;
 4using System.Collections;
 5using System.Web;
 6using System.Web.Security;
 7using System.Web.UI;
 8using System.Web.UI.WebControls;
 9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11using System.Data.SqlClient;
12
13public partial class AllVote : System.Web.UI.Page
14...{
15    protected void Page_Load(object sender, EventArgs e)
16    ...{
17
18    }
19
20    public string GetList()
21    ...{
22        SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConStr"]);
23        con.Open();
24        SqlCommand com = new SqlCommand("select * from tb_Vote ", con);
25        SqlDataReader dr = com.ExecuteReader();
26        string strBody = "<table width=150 align=center>";
27        while (dr.Read())//循环读取
28        ...{
29            strBody += "<tr><td class=tableBottom>·<a href=vote.aspx?ID=" + dr["ID"] + " >" + dr["Title"].ToString() + "</a></td></tr>\n";
30        }
31        dr.Close();//关闭阅读器
32        strBody += "</table>";
33        return strBody;
34    }
35}
36