Howto populate ListView with database records on click event button

See more:

C#

Dear people

How to populate a ListView with database records on click event button. Basically I have a form, and in this form I have a button (called Starters), and a listview. On my database I have a table called Food.
The attributes of this table are:

=============================================
FoodID    FoodName     FoodType     FoodPrice
=============================================
000001     Soup        Starter      £4.50
-------    ------      --------     -------

=============================================

What I basically want is, on click event button to display on my listview only the the FoodName...
Here is the code on Starter click event button, but for some reason it gives me an error.

public partial class StockIn : Form
{
     private DataSet DtposMenuDS = new DataSet("DtposMenu");
     private DataTable starterTable = null;

     public StockIn()
     {
        InitializeComponent();
     }

     private void cmdExit_Click(object sender, EventArgs e)
     {
        this.Close();
     }

     private void cmdStarters_Click(object sender, EventArgs e)
     {
        OleDbConnectionStringBuilder connBuilder = new OleDbConnectionStringBuilder();
        connBuilder.DataSource = @"C:\Users\AP_AE\Desktop\DTPOS_APP\DataBase\DtposMenu.accdb";
        connBuilder.Provider = "Microsoft.ACE.OLEDB.12.0";
        connBuilder.Add("Jet OLEDB:Engine Type", "5");

        // Food SQL Query
        string foodTypeSql = @"SELECT FoodName, FoodType FROM Food WHERE FoodType = @foodType";

        using (OleDbConnection conn = new OleDbConnection(connBuilder.ConnectionString))
        {
            try
            {
                conn.Open();
                // TODO: Get Food here
               OleDbCommand foodsCommand = new OleDbCommand(foodTypeSql, conn);
               OleDbParameter foodType = foodsCommand.Parameters.Add("@foodType", OleDbType.VarChar, 15);
               OleDbDataAdapter foodsDa = new OleDbDataAdapter(foodsCommand);
               foodType.Value = "Starters";
               foodsDa.Fill(DtposMenuDS, "Starters");

               starterTable = DtposMenuDS.Tables["Starter"];
                    
                    
               ListViewItem foodItem = new ListViewItem();
               foodItem.SubItems.Add(((DataRowView)DtposMenuBS.Current)["FoodName"].ToString());
               this.listViewItemsInStock.Items.Add(foodItem);

            }
            catch (Exception ex)
            {
                MessageBox.Show("Error: " + ex);
            }
        }
    }

}

Any help it would be very very greatfull....

Thanks in advance


Roni