using?System;
using?System.Data;
using?System.Configuration;
using?System.Web;
using?System.Web.Security;
using?System.Data.Common;
using?System.Web.UI;
using?System.Web.UI.WebControls;
using?System.Web.UI.WebControls.WebParts;
using?System.Web.UI.HtmlControls;

public?partial?class?_Default?:?System.Web.UI.Page?
{
????protected?void?Page_Load（object?sender?EventArgs?e）
????{
????????if?（Request.QueryString[“vid“]?!=?null）//判斷是否選擇了投票主題
????????{
????????????this.TextBox1.Visible?=?true;//設置可見
????????????int?i=0;
????????????//讀取數據表，以獲得該投票主題的具體信息
????????????string?strVoteID?=?Request.QueryString[“vid“];
????????????string?strSql?=?“select?*?from?z_VoteInfo?where?Vote_ID=‘“?+?strVoteID?+?“‘;“;
????????????string?strConn?=?“Data?Source=ADIR;Initial?Catalog=vote;User?ID=sa;Password=93626wenbo“;
????????????DbProviderFactory?dbProviderFactory?=?DbProviderFactories.GetFactory（“System.Data.SqlClient“）;
????????????DbConnection?dbConn?=?dbProviderFactory.CreateConnection（）;
????????????dbConn.ConnectionString?=?strConn;
????????????dbConn.Open（）;
????????????DbCommand?dbComm?=?dbProviderFactory.CreateCommand（）;
????????????dbComm.Connection?=?dbConn;
????????????dbComm.CommandText?=?strSql;
????????????DbDataAdapter?adapter?=?dbProviderFactory.CreateDataAdapter（）;
????????????adapter.SelectCommand?=?dbComm;
????????????DataSet?dsDataSet?=?new?DataSet（）;
????????????adapter.Fill（dsDataSet?“table“）;
????????????DataTable?dtTable?=?dsDataSet.Tables[“table“];
????????????//顯示主題內容和主題標題
????????????this.lbltitle.Text?=?dtTable.Rows[0][“Vote_title“].ToString（）;
????????????this.TextBox1.Text?=?dtTable.Rows[0][“Vote_Question“].ToString（）;
????????????//獲得該主題的選項表
????????????strSql?=?“select?*?from?z_VoteOptions?where?Vote_ID=‘“?+?strVoteID?+?“‘;“;
????????????dbComm.CommandText?=?strSql;
????????????adapter.SelectCommand?=?dbComm;
????????????adapter.Fill（dsDataSet?“table1“）;
????????????DataTable?table?=?dsDataSet.Tables[“table1“];
????????????//新建一個列，用來顯示序號
????????????DataColumn?column?=?new?DataColumn（“no“）;
????????????table.Columns.Add（column）;
????????????foreach（DataRow?row?in?table.Rows）
????????????{
????????????????i++;
????????????????row[“no“]=?i.ToString（）;
????????????}
????????????//綁定數據源
????????????this.GridView1.DataSource?=?table.DefaultView;
????????????this.GridView1.DataBind（）;
????????????//生成GridView控件中的每一行的條形圖和“投票”按鈕是否顯示
????????????foreach?（GridViewRow?gvr?in?GridView1.Rows）
????????????{
????????????????Label?lbl?=?（Label）gvr.FindControl（“Label1“）;
????????????????lbl.Width?=?Unit.Parse（gvr.Cells[3].Text）;
????????????????linkButton?lb1?=?（linkButton）gvr.FindControl（“linkButton1“）;
????????????????if?（Request.Cookies[Request.QueryString[“vid“]]?==?null）
????????????????{
????????????????????lb1.Visible?=?true;
????????????????}
????????????????else?if?（Request.Cookies[Request.QueryString[“vid“]].Values.Count

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????1048576??2006-05-25?15:12??ch14\Database\vote_Data.MDF

?????文件????1048576??2006-05-25?15:12??ch14\Database\vote_Log.LDF

?????文件???????6991??2006-05-12?15:16??ch14\Default.aspx

?????文件???????7525??2006-05-12?16:58??ch14\Default.aspx.cs

?????文件???????5083??2006-05-12?14:44??ch14\Vote_Add.aspx

?????文件???????1942??2006-05-12?10:38??ch14\Vote_Add.aspx.cs

?????文件???????6409??2006-05-12?14:44??ch14\Vote_Info.aspx

?????文件???????1942??2006-05-11?15:29??ch14\Vote_Info.aspx.cs

?????文件???????3779??2006-05-12?14:44??ch14\Vote_Manage.aspx

?????文件???????1590??2006-05-10?14:04??ch14\Vote_Manage.aspx.cs

?????文件???????5720??2006-05-12?14:44??ch14\Vote_Modify.aspx

?????文件???????3505??2006-05-11?15:29??ch14\Vote_Modify.aspx.cs

?????文件???????5468??2006-05-12?15:12??ch14\Vote_OptionModify.aspx

?????文件???????1693??2006-05-12?15:12??ch14\Vote_OptionModify.aspx.cs

?????文件???????1876??2006-05-10?20:05??ch14\web.config

?????目錄??????????0??2008-11-08?18:38??ch14\App_Data

?????目錄??????????0??2008-11-08?18:38??ch14\Database

?????目錄??????????0??2008-11-08?18:38??ch14

-----------?---------??----------?-----??----

??????????????2150675????????????????????18