private void AddItemToOrder(string itemName, int quantity) { int.TryParse(insertedOrderId, out int orderNumber); // Get item ID int itemId = GetItemId(itemName); // Setting up a variable for the datatable from the database RestaurantDataSet.OrderItemsDataTable orderItems = new RestaurantDataSet.OrderItemsDataTable(); // Setting up an order items adaptor and it's to fill in the datatable RestaurantDataSetTableAdapters.OrderItemsTableAdapter orderItemsTableAdap = new RestaurantDataSetTableAdapters.OrderItemsTableAdapter(); // Getting the order items data from the database orderItemsTableAdap.GetData(); // Filling the data to the datatable orderItemsTableAdap.Fill(orderItems); // Add the selection to the preview list orderPreviewListBox.Items.Add(itemName + " (" + quantity + ")"); // Adding the new record to the database orderItemsTableAdap.Insert(quantity.ToString(), itemId, orderNumber); }