private void loadusers()
{
NpgsqlConnection conn = new NpgsqlConnection(WebConfigurationManager.ConnectionStrings["JE-banken"].ConnectionString);
string sql = "SELECT * FROM employees";
NpgsqlCommand cmd = new NpgsqlCommand(sql, conn);
conn.Open();
NpgsqlDataReader dr = cmd.ExecuteReader();
List<User> userlist = new List<User>();
while (dr.Read())
{
User u = new User();
u.fullname = Convert.ToString(dr["fullname"]);
u.employeenumber = Convert.ToInt16(dr["employeenumber"]);
u.username = Convert.ToString(dr["username"]);
if(Convert.ToString(dr["licensed"]) != "")
{
u.licensed = Convert.ToBoolean(dr["licensed"]);
}
userlist.Add(u);
}
conn.Close();
DropDownList1.Items.Add("---");
foreach (User user in userlist.OfType<User>())
{
DropDownList1.Items.Add(new ListItem(user.fullname, user.employeenumber.ToString()));
}
}
