public wndw_OrderHistory(DatabaseConnection conn, string username) { InitializeComponent(); this.conn = conn; userID = GetUserID(username); dataGrid.IsReadOnly = true; list = conn.ReadData("SELECT Date, Orders.ID FROM Orders WHERE Orders.Users_ID = " + userID); int counter = 1; for (int i = 0; i < list.Count; i += 2) { comboBox.Items.Add(counter + ". " + list[i].Substring(0, list[i].IndexOf(" "))); counter++; } }
public void Init(DatabaseConnection conn) { this.conn = conn; shipmnetsList = new List<Shipment>(); List<string> list = conn.ReadData("select ID, Name, Price from Shipping_methods"); for (int i = 0; i < list.Count; i += 3) { decimal result = decimal.Parse(list[i + 2], CultureInfo.InvariantCulture); Shipment s = new Shipment(Convert.ToInt32(list[i]), list[i + 1], result); shipmnetsList.Add(s); } foreach (Shipment s in shipmnetsList) comboBox.Items.Add(s.Name); }