Thank you guys for your assistance, i managed to resolve the problem.
In the listViewQuick_ItemSelectionChanged event, i managed to copy data from the list view like this:
int countRows = 0;
private void listViewQuick_ItemSelectionChanged(object sender, ListViewItemSelectionChangedEventArgs e)
{
listViewQuick.FullRowSelect = true;
int[] count = new int[10];;
con = new SqlConnection(cs.DBConn);
con.Open();
string cb = "insert into AuditTrail (Date,Time,Location,MessageDescription) VALUES (@d1,@d2,@d3,@d4)";
cmd = new SqlCommand(cb);
cmd.Connection = con;
cmd.Parameters.Add("@d1", System.Data.SqlDbType.VarChar);
cmd.Parameters.Add("@d2", System.Data.SqlDbType.VarChar);
cmd.Parameters.Add("@d3", System.Data.SqlDbType.VarChar);
cmd.Parameters.Add("@d4", System.Data.SqlDbType.VarChar);
cmd.Parameters["@d1"].Value = (string)listViewQuick.SelectedItems[countRows].SubItems[0].Text;
cmd.Parameters["@d2"].Value = (string)listViewQuick.SelectedItems[countRows].SubItems[1].Text;
cmd.Parameters["@d3"].Value = (string)listViewQuick.SelectedItems[countRows].SubItems[2].Text;
cmd.Parameters["@d4"].Value = (string)listViewQuick.SelectedItems[countRows].SubItems[3].Text;
countRows++;
cmd.ExecuteReader();
con.Close();
}