Posted on: 6/11/2014 12:44:25 AM | Views : 436

Hi, 
I am trying to fill in a row in a ole db using this code.
DBInsert.CommandText = "INSERT INTO commission(Date,Detail,Debit,Credit) VALUES (" + TbDate.Text + ",'" + detail + "'," + debit + "," + credit + ")" This code only works if if remove Date from this command. As soon as I try to insert Date as well. it returns exception saying syntex error in INSET INTO command
Any words?

Go to the complete details ...