博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

投票处理页面 vote.aspx.cs

Posted on 2006-10-06 08:14  孤峰皓月  阅读(327)  评论(0编辑  收藏  举报

using System;
using System.Data;
using System.Configuration;
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 _Default : System.Web.UI.Page
{

        private string voteID = "1";
        protected void Page_Load(object sender, EventArgs e)
        {
            SqlConnection con = DB.createConnection();
            con.Open();
            SqlCommand cmd = new SqlCommand("select voteTitle from voteMaster where voteID="+this.voteID,con);               //this.voteID=1 本页变量
            string title = Convert.ToString(cmd.ExecuteScalar()); //返回首行首列;
            this.lbltitle.Text = title;

            SqlCommand cmdItem = new SqlCommand("select voteDetailsID,voteItem from voteDetails where voteID="+this.voteID,con);
            SqlDataReader sdr = cmdItem.ExecuteReader();   //返回查询结果
 
            this.rBtnItems.DataTextField = "voteItem";
            this.rBtnItems.DataValueField = "voteDetailsID";
        
            this.rBtnItems.DataSource = sdr;
            this.rBtnItems.DataBind();

            sdr.Close();
           // con.Close();
        }

    protected void rBtnItems_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
    protected void btnVote_Click(object sender, EventArgs e)
    {
        //SqlConnection con =D
    }
}