showresult.aspx.cs

来自「SQL数据库在App_Data下面 是sql格式的 用的时候只需要修改App」· CS 代码 · 共 33 行

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 showResult : System.Web.UI.Page
{
    DB DBManager=new DB();
    protected void Page_Load(object sender, EventArgs e)
    {
        int id = Convert.ToInt32(Request.QueryString["id"].ToString());
        string sqlgetSum = "select voteSum from voteMaster where id="+id;
        int voteSum=Convert.ToInt32(DBManager.executeGetReturn(sqlgetSum));

        string sqlvoteTitle = "select voteItem,voteNum from voteDetails where id="+id;        
        SqlDataReader sdr = DBManager.getSdr(sqlvoteTitle);
        while (sdr.Read())
        {
            int m = sdr.GetInt32(1);
            Response.Write("<img src='images/aa.jpg' height=20 width=" + m*20 + "/>" + sdr.GetString(0) + "(票数：" + m + ")<BR>");
        }
        sdr.Close();
        DBManager.clear();
    }
}