protected void loadPageDefaults()
 {
     if (userDrop.Items.Count > 0)
     {
         userDrop.Items.Clear();
     }
     if (gr.DataSource != null)
     {
         gr.DataSource = null;
         gr.DataBind();
     }
     SQL sql = new SQL();
     DataTable DT = sql.getCandidates();
     gr.DataSource = DT;
     gr.DataBind();
     foreach (DataRow r in DT.Rows)
     {
         string name = r["Candidate"].ToString();
         string guid = r["UserKey"].ToString();
         if (!userDrop.Items.Contains(new ListItem(name, guid)))
         {
             ListItem item = new ListItem(name, guid);
             userDrop.Items.Add(item);
         }
     }
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     SQL sql = new SQL();
     DataTable DT = sql.getCandidates();
     gr.DataSource = DT;
     gr.DataBind();
     foreach (DataRow r in DT.Rows)
     {
         string name = r["Candidate"].ToString();
         string guid = r["UserKey"].ToString();
         if (!userDrop.Items.Contains(new ListItem(name, guid)))
         {
             ListItem item = new ListItem(name, guid);
             userDrop.Items.Add(item);
         }
     }
 }