Item list med for loop, kan det lade sig gøres

CSharp kode 

 List<UserProfiles> allUser = new List<UserProfiles>();
             UserProfiles user;
 
             MySqlConnection dbConn = new MySqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["connstring"].ConnectionString);
 
             MySqlCommand command = dbConn.CreateCommand();
             command.CommandType = System.Data.CommandType.StoredProcedure;
             command.CommandText = "getAllUser";
 
             MySqlDataReader reader = null;
 
             try
             {
                 dbConn.Open();
                 reader = command.ExecuteReader();
             }
             catch (Exception)
             {
                 dbConn.Close();
                 command.Dispose();
             }
 
             DataTable dt = new DataTable();
             dt.Load(reader);
 
             foreach (DataRow row in dt.Rows)
             {
                 user = new UserProfiles();
                 user.UserName = row[0].ToString();
                 user.RoleType = row[1].ToString();
 
                 allUser.Add(user);
 
             }
 
             dbConn.Close();
             command.Dispose();
             reader.Dispose();
 
             return allUser;