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