public void loadRepairs() { clsDBRepair dbRepair = new clsDBRepair(); List <clsRepair> repairs = dbRepair.RepairList(); Int32 Index = 0; lstRepairJobs.Items.Clear(); while (Index < repairs.Count) { clsRepair repair = repairs[Index]; ListViewItem NewItem = new ListViewItem(); NewItem.Text = repair.CustomerName; NewItem.SubItems.Add(repair.PhoneModel); NewItem.SubItems.Add(repair.SerialNo_IMEI); NewItem.SubItems.Add(repair.Fault); NewItem.SubItems.Add("£" + repair.Balance.ToString("F")); NewItem.SubItems.Add(repair.CollectionDate.ToShortDateString()); NewItem.Tag = repair; lstRepairJobs.AutoResizeColumns(ColumnHeaderAutoResizeStyle.ColumnContent); lstRepairJobs.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize); lstRepairJobs.Items.Add(NewItem); //Add the item to ListView Index++; //move the index to the next record } }