I am trying to populate a 3 column listView.

I am trying to populate a 3 column list box. It populates the first item only into many columns.

string connStr = Properties.Settings.Default.conn;

string sql = "SELECT Comment, [User Name], EventDate FROM Notes WHERE [Project ID] = " + value + " ORDER BY EventDate DESC;";

listView1.Columns.Add("Comment", listView1.Width / 2);

listView1.Columns.Add("User Name", listView1.Width / 4);

listView1.Columns.Add("Event Date", listView1.Width / 4);

using (OleDbConnection connection = new OleDbConnection(connStr))

{

OleDbCommand command = new OleDbCommand(sql, connection);

connection.Open();

OleDbDataReader reader = command.ExecuteReader();

if (reader.HasRows)

{

while (reader.Read())

{

ListViewItem lvi = new ListViewItem(reader[0].ToString());

for (int i = 0; i <= reader.FieldCount - 1; i++)

{

lvi.SubItems.Add(reader[i].ToString());

}

listView1.Items.Add(lvi);

}

reader.Close();

connection.Close();

}