How to show data in listview from database?

See more:

C#

Dear People

How can I display data in listview from database. What I have done so far is. Here is my code...

public partial class DtposMDIParentSystem : Form
    {
        List<object[]> result = new List<object[]>();
        
        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();

                int i = 0;
                while (reader.Read())
                {
                    result.Add(new Object[reader.FieldCount]);
                    reader.GetValues(result[i]);
                }
                reader.Close();
                aConnection.Close();
            }
            catch (InvalidOperationException ex)
            {
                MessageBox.Show("Invalid Masseage = " + ex.Message);
            }
            
        }

         private void cmdOlives_Click(object sender, EventArgs e)
        {
            if (result.Count > 0)
	            {
	                string temp = "";
                    
	                for (int i = 0; i < result[1].Length; i++)
	                {
	                    temp += result[1][i] + "     ";
	                }
	                TableOrderListView.Items.Add(temp);
	            }
        }
}

My question is when I click cmdOlives_Click event button I want to display in my listview such as:

-----------------------------
Num Name Price
-----------------------------
1 Olives 3.95


-----------------------------

Any help would be very very greatfull...

Thanks in advance


Kind regards

Agron