} // Orders_ListBox_SelectedIndexChanged public void LoadOrderItems(string OrderID) { try { int ordercount = 0; // the number of order items to display List <string>[] ManagerItemdata; // the order items that will be displayed ArrayList ListBoxInfo = new ArrayList(); // Array list where formatted text will be stored // connect to DB if it is not connected if (!nsadb.Connected()) { nsadb.OpenConnection(); } //request the Records to display on the manager order litems list ordercount = nsadb.ManagerOrderItemData(out ManagerItemdata, OrderID); // If there is no data in the database skip attempting to load the List // It will cause an error. if (ordercount == 0) { return; } //loop over the records and format them in the Array List for (int index = 0; index < ordercount; index++) { if (ManagerItemdata[2][index] == "0") { ListBoxInfo.Add(new BoxFormat(ManagerItemdata[1][index], ManagerItemdata[0][index])); } else { ListBoxInfo.Add(new BoxFormat(ManagerItemdata[1][index] + " - Refunded", ManagerItemdata[0][index])); } } // Insert Array List into the List Box OrderItems_Listbox.DataSource = ListBoxInfo; // Define which information is actually displayed by the listbox and returned OrderItems_Listbox.DisplayMember = "displayText"; OrderItems_Listbox.ValueMember = "databaseID"; } catch (Exception ex) { MessageBox.Show(ex.Message, "Error loading Order Items List", MessageBoxButtons.OK, MessageBoxIcon.Error); } } // LoadOrderItems