allvote.aspx.cs

为达到最佳效果

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class AllVote : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }

    public string GetList()
    {
		SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConStr"]);
        con.Open();
        SqlCommand com = new SqlCommand("select * from tb_Vote ", con);
        SqlDataReader dr = com.ExecuteReader();
        string strBody = "<table width=150 align=center>";
        while (dr.Read())//循环读取
        {
            strBody += "<tr><td class=tableBottom>·<a href=vote.aspx?ID=" + dr["ID"] + " >" + dr["Title"].ToString() + "</a></td></tr>\n";
        }
        dr.Close();//关闭阅读器
        strBody += "</table>";
        return strBody;
    }
}