protected void Page_Load(object sender, EventArgs e) { SQL sql = new SQL(); DataTable DT = sql.getUserNames(); if (DT.Rows.Count > 0) { foreach (DataRow r in DT.Rows) { ListItem item = new ListItem(r["username"].ToString(), r["identity"].ToString()); if (!userDrop.Items.Contains(item)) { userDrop.Items.Add(item); } } } }
protected void Reload() { userDrop.Items.Clear(); SQL sql = new SQL(); DataTable DT = sql.getUserNames(); if (DT.Rows.Count > 0) { foreach (DataRow r in DT.Rows) { ListItem item = new ListItem(r["username"].ToString(), r["identity"].ToString()); if (!userDrop.Items.Contains(item)) { userDrop.Items.Add(item); } } } }