insert into access database not working.

[Lizzard99]

if i add the sql query straight into access it adds the new row but if i run this function from visual studio it goes through without an error buyt its not adding the new row to the database. please help

private void addtodatabase()
{

OleDbConnection connect = new OleDbConnection (Connection.Con nect());

connect.Open();


for (int count = 0; count <= listView1.Items .Count - 1; count++)
{
int cid = int.Parse(listV iew1.Items[count].SubItems[0].Text);
int pid = int.Parse(listV iew1.Items[count].SubItems[3].Text);
DateTime sday = DateTime.Parse( listView1.Items[count].SubItems[2].Text);
int quantity = int.Parse(listV iew1.Items[count].SubItems[6].Text);
double price = double.Parse(li stView1.Items[count].SubItems[5].Text);
double total = double.Parse(li stView1.Items[count].SubItems[7].Text);

string query = "insert into tblInvoice(Cust omerIDFK,Produc tIDFK,Date,Quan tity,ItemPrice, Total) values("+cid+", "+pid+",#"+sday +"#,"+quantity+ ","+price+","+t otal+")";


OleDbCommand cmd = new OleDbCommand(qu ery, connect);


cmd.ExecuteNonQ uery();


}


connect.Close() ;



Thanks