tjjg.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.OleDb;

public partial class tjjg : System.Web.UI.Page
{
    DB dbobj = new DB();

    protected void Page_Load(object sender, EventArgs e)
    {
        
        if (!IsPostBack)
        {
            int votesum = 0;
            decimal bilv;
            OleDbConnection con = dbobj.GetConnection();
            con.Open();
            OleDbCommand cmd = new OleDbCommand("select * from toupiao", con);
            OleDbDataReader dr = cmd.ExecuteReader();
            while (dr.Read())
            {
                votesum +=(int) dr["counts"];
            }
            con.Close();
            con.Open();
            OleDbDataReader dr2 = cmd.ExecuteReader();
            message.Text = "<TABLE width=400 height='168' border=1 cellPadding=2 cellSpacing=0 borderColor=#111111  style='BORDER-COLLAPSE: collapse' ><TBODY><tr bgcolor='#fdecde'><TD height='32' colspan='5' style='BORDER-COLLAPSE: collapse' border=1 > <strong><span class='font10'>您最喜欢大悟哪个旅游景点？</span></strong> 　</TD></tr><TR><TD width=70 height='63' align=middle bgColor=#b8e6f9>投票项</TD><TD align=middle width=100 bgColor=#b8e6f9>大悟烈士陵园</TD><TD align=middle width=100 bgColor=#b8e6f9>双桥古镇</TD><TD align=middle width=100 bgColor=#b8e6f9>泉水山庄</TD> <TD align=middle bgColor=#b8e6f9 style='width: 100px'>夏店石林</TD></TR><TR><td bgColor=#edf6ff height=32>得票</td>";
            while (dr2.Read())
            {
                message.Text += "<td bgColor=#edf6ff height=32>" + dr2["counts"] + "</td>";
            }
            message.Text += "</tr>";
            message.Text += "<tr>";
            message.Text += "<td bgColor=#edf6ff height=32>" + "百分比" + "</td>";

            con.Close();
            con.Open();
            OleDbDataReader dr3 = cmd.ExecuteReader();
            while (dr3.Read())
            {
                bilv = Convert.ToDecimal(dr3["counts"]) / Convert.ToDecimal(votesum);

                message.Text += "<td bgColor=#edf6ff >" + "" + bilv.ToString("0.##% ") + "" + "</td>";
            }
            message.Text += "</tr>";
            message.Text += "</table>";
            

        }
    }
}