showresult.aspx.cs

投票系统VS2005+SQL2000 三层结构

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;
using System.Drawing;
using System.Web.SessionState;

public partial class ShowResult : System.Web.UI.Page
{
    public int VoteID
    {
        get
        {
            if (Request.QueryString["id"] == null)
                return -1;
            else
                return (Convert.ToInt32(Request.QueryString["id"]));
        }
    }
    
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindGrid();
        }

    }

    /// <summary>
    /// 数据绑定
    /// </summary>
    private void BindGrid()
    {
        string strConn = ConfigurationSettings.AppSettings["ConnectionString"];
        SqlConnection conn = new SqlConnection(strConn);
        SqlCommand cmd = conn.CreateCommand();
        cmd.CommandText = "GetOptions";
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Parameters.Add("@vote_id", VoteID);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();

        try
        {
            conn.Open();
            da.Fill(ds);
            dgOptions.DataSource = ds.Tables[0].DefaultView;
            dgOptions.DataBind();
        }
        catch (SqlException ex)
        {
            Response.Write(ex.Message);
        }
        finally
        {
            conn.Close();
        }
    }
}