showresult.aspx.cs

来自「根据实际情况还可以在数据库中附加更多方面的投票」· CS 代码 · 共 36 行

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

namespace vote
{
    public partial class showResult : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            string voteID = Request.QueryString["voteid"].ToString();
            //创建连接
            SqlConnection con = DB.createConnection();
            con.Open();
            //查询对应的条目
            SqlCommand cmdItem = new SqlCommand("select * from voteDetails where voteID=" + voteID,con);
            SqlDataReader sdr=cmdItem.ExecuteReader();
            while (sdr.Read())
            {
                Response.Write("<font size=10>" + sdr.GetString(2) + "-" + sdr.GetInt32(3).ToString() + "</font><br>");
            }
            sdr.Close();
        }
    }
}