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