Update query syntax for datagrid

[artteam]

we are having a sql query error when we are trying to update values from the datagridview to access database. The problem is because of date(because of its format), a runtime error pops up saying that "missing operator in query expression "to_date(2/2/2007 12:00:00 AM, "mm/dd/yy")"

we are only interested in date portion and not the time.
this our command string

cmd = "update Inventory Set itemDescription=" + this.dataGriedView1.CurrentRow.Cell[0].Value.ToString() + ", Date=" +
"to_date(" + this.dataGriedView1.CurrentRow.Cell[1].Value.ToString() + "," + "mm/dd/yy" + ")" +
" where ItemNumber=" +
int.parse(this.dataGriedView1.CurrentRow.Cell[2].Value.ToString());

there are many columns, I haven't showed here because I know the problem is with date only.

Thanks in advance.

[enreil]

A question very similar to yours was on this forum a few days ago - you can read it here. This question dealt with SQL dates, but you should be able to make the adjustment for Access. Hope that helps.

we are having a sql query error when we are trying to update values from the datagridview to access database. The problem is because of date(because of its format), a runtime error pops up saying that "missing operator in query expression "to_date(2/2/2007 12:00:00 AM, "mm/dd/yy")"

we are only interested in date portion and not the time.
this our command string

cmd = "update Inventory Set itemDescription=" + this.dataGriedView1.CurrentRow.Cell[0].Value.ToString() + ", Date=" +
"to_date(" + this.dataGriedView1.CurrentRow.Cell[1].Value.ToString() + "," + "mm/dd/yy" + ")" +
" where ItemNumber=" +
int.parse(this.dataGriedView1.CurrentRow.Cell[2].Value.ToString());

there are many columns, I haven't showed here because I know the problem is with date only.

Thanks in advance.