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); } } }