Date field in Access and datetimepicker in C#

[Leiloon]

SALAM = Hello
I can't move the value of a DateTimePicker in my C# application, to a field in a Access table which is Date format.
Actually when I inser the record it gives me this error message:
"Syntax error in INSERT INTO statement."

and I'v found problem is on date fields.

what's ur idea?

thx

[Shashi Sadasivan]

SALAM = Hello
I can't move the value of a DateTimePicker in my C# application, to a field in a Access table which is Date format.
Actually when I inser the record it gives me this error message:
"Syntax error in INSERT INTO statement."

and I'v found problem is on date fields.

what's ur idea?

thx

check the syntax on how u insert the datetime field. usually for access i think it shoud be sourrounded by #

[Leiloon]

Actually I'm doubted about something. the value of dateTimepicker include date and time. but a DATE format in Access is pure date.
Mabe i should somehow filter the value of dateTimePicker to extract date part of that.
here is related parts of my code:

queryString = "INSERT INTO ProductSubjects (PSCode, PSName, PSDescription, CustomerID, , PSBeginDate, PSEndDate) " +
"VALUES (? , ? , ? , ? , ? , ?)";

OleDbParameter p1 = new OleDbParameter();
command.Parameters.Add(p1);
p1.Value = ps + code.ToString();
.
.
.
OleDbParameter p5 = new OleDbParameter();
command.Parameters.Add(p5);
p5.Value = dateTimePicker1.Value;

OleDbParameter p6 = new OleDbParameter();
command.Parameters.Add(p6);
p6.Value = dateTimePicker2.Value;

command.CommandText = queryString;
Int32 records = command.ExecuteNonQuery();

[Leiloon]

Dear Shashi,
your idea didn't work.

thx

[talhaekram]

Normally INSERTING DATE in Databases sometimes creates problem
try follow the Default format ("mm/dd/yyyy") in insertion.

Try debuging the SQL by writing SQL Insert script in Access with values that you get from Application.