C#

private void cmdOlives_Click(object sender, EventArgs e)
{
  if (result.Count > 0)
  {
    TableOrderListView.Items.Clear();  //<============ Note only have this line if you only want one item in your listview

    ListViewItem newItem = new ListViewItem(result[1][0]) // <==== get the item (Olives)

    // Now get the sub items associated with Olives
    for (int i = 1; i < result[1].Length; i++)
    {
      newItem.SubItems.Add(result[1][i]);  // <==== and add them to the Olives Item
    }

    TableOrderListView.Items.Add(newItem);  // <== Now add the Item to the ListView
  }
}

List<FoodItem> foodItems=new List<FoodItem>();
while (reader.Read()) {
    FoodItem fi=new FoodItem();
    fi.Name=reader["Name"];
    fi.Calories=int.Parse(reader["Calories"]);
    ...
    foodItems.Add(fi);
}

private void cmdOlives_Click(object sender, EventArgs e)
        {
            if (menuItems.Count > 0)
            {
                System.Windows.Forms.ListViewItem newItem = new System.Windows.Forms.ListViewItem(menuItems[1]);

                
                for (int i = 1; i < menuItems[1].Length; i++)
                {
                    newItem.SubItems.Add(menuItems[i]);
                }

                TableOrderListView.Items.Add(newItem);
            }
        }

LAPEC wrote:

im having another problem

public partial class DtposMDIParentSystem : Form
    {
        
        List<MenuItems>; menuItems = new List<MenuItems>();

        
        public DtposMDIParentSystem()
        {
            InitializeComponent();

            //create the database connection
            OleDbConnection aConnection = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\AP_AE\Desktop\DTPOS_APP\DataBase\DtposDatabase.accdb;");

            //create the command object and store the sql query
            OleDbCommand aCommand = new OleDbCommand("SELECT * FROM Food", aConnection);

            try
            {
                aConnection.Open();

                //create the datareader object to connect to table
                OleDbDataReader reader = aCommand.ExecuteReader();
                while (reader.Read()) 
                {
                    MenuItems mi = new MenuItems();
                    mi.ItemName = reader["Name"].ToString();
                    mi.ItemPrice = Double.Parse(reader["Price"].ToString());

                    menuItems.Add(mi);
                }
                reader.Close();
                aConnection.Close();
            }
            catch (InvalidOperationException ex)
            {
                MessageBox.Show("Invalid Masseage = " + ex.Message);
            } 
        }

UserControl1 userC = new UserControl();
//====================================\\
private void cmdStarters_Click(object sender, EventArgs e)
{
    this.StartersPanel.Visible = true;
    this.userC.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
    this.userC.Location = new System.Drawing.Point(0, 0);
    this.userC.Size = new System.Drawing.Size(696, 556);
    this.userC.Enabled = true;
    this.userC.Visible = true;
    this.StartersPanel.Controls.Add(userC);
}

private void cmdOlives_Click(object sender, EventArgs e)
{
    if (menuItems.Count > 0)
    {
        System.Windows.Forms.ListViewItem newItem = new System.Windows.Forms.ListViewItem(menuItems[1].ToString());


        for (int i = 1; i < menuItems[1].ItemName.Length; i++)
        {
            newItem.SubItems.Add(menuItems[i].ToString());
            //newItem.SubItems.Add(menuItems[1].ToString());
        }

        TableOrderListView.Items.Add(newItem);
    }
}

string starterSql = @"SELECT * FROM Food WHERE Food_Type = 'Starter'";
string mainSql = @"SELECT * FROM Food WHERE Food_Type = 'Main'";
// add a statement for each of Dessert, Side Order etc.


using (SqlConnection conn = new SqlConnection(connString))
{
    try
    {
        conn.Open();
        SqlDataAdapter starterDa = new SqlDataAdapter(starterSql, conn);
        starterDa.Fill(menuDS, "Starter");
        SqlDataAdapter mainDa = new SqlDataAdapter(mainSql, conn);
        mainDa.Fill(menuDS, "Main");
        SqlDataAdapter dessertDa = new SqlDataAdapter(dessertSql, conn);
        dessertDa.Fill(menuDS, "Dessert");
        // repeat as necessary

        starterTable = menuDS.Tables["Starter"];
        mainTable = menuDS.Tables["Main"];
        dessertTable = menuDS.Tables["Dessert"];
        // repeat
    }
    catch (Exception e)
    {
        Console.WriteLine("Error: " + e);
    }
}