public void AddOrderItemToExistingOrder(string nameOfItem) { var addOrderItem = new Order_MenuItemTableAdapter(); var menuItemTable = new MenuItemTableAdapter(); var menuItemDT = menuItemTable.GetData(); int menuItemID = 1; foreach (dsDinerMax3000.MenuItemRow row in menuItemDT.Rows) { if (row.Name.ToLower() == nameOfItem.ToLower()) { menuItemID = row.Id; } } addOrderItem.InsertOrderItem(_databaseID, menuItemID); }