protected void Page_Load(object sender, EventArgs e)
{
if (Session["userName"] == null || !(Session["roleNumber"].ToString().Equals("1")))
{
Response.Redirect("NotAuthorizatedPage.aspx");
}
String myConnectionString;
myConnectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
MySqlConnection conn = new MySqlConnection(myConnectionString);
conn.Open();
string query = "SELECT C.CANDIDATE_INFO FROM CANDIDATE C " +
";";
MySqlCommand cmd = new MySqlCommand(query, conn);
MySqlDataAdapter da = new MySqlDataAdapter { SelectCommand = cmd };
DataSet ds = new DataSet();
da.Fill(ds);
if (!IsPostBack)
{
DropDownListCandidate.DataTextField = ds.Tables[0].Columns["CANDIDATE_INFO"].ToString();
DropDownListCandidate.DataSource = ds.Tables[0];
DropDownListCandidate.DataBind();
DropDownListCandidate.SelectedItem.Text = "";
}
conn.Close();
}
protected void BtnShowCandidates_Click(object sender, EventArgs e)
{
string election = Request.Form[DropDownListElection.UniqueID];
int election_id = returnelectionId(election);
String query = "SELECT C.CANDIDATE_INFO FROM CANDIDATE C " +
";";
String myConnectionString;
myConnectionString = ConfigurationManager.ConnectionStrings["myConnectionString"].ConnectionString;
MySqlConnection conn = new MySqlConnection(myConnectionString);
conn.Open();
MySqlCommand cmd1 = new MySqlCommand(query, conn);
MySqlDataAdapter da = new MySqlDataAdapter {
SelectCommand = cmd1
};
DataSet ds = new DataSet();
da.Fill(ds);
DropDownListCandidate.DataTextField = ds.Tables[0].Columns["CANDIDATE_INFO"].ToString();
DropDownListCandidate.DataSource = ds.Tables[0];
DropDownListCandidate.DataBind();
DropDownListCandidate.SelectedItem.Text = "";
conn.Close();
}
