how to insert date to OleDb DataBase(VB.Net windows Application)

[sandhya.o.k]

i am trying to insert a date to OleDb data base. its Field Type is DateTime.
what is wrong with my insert query? by avoiding the date field using this query
ssql = "INSERT INTO mytable (Address,Name) VALUES (@address,@name)"
i can insert Address and name to database.

something is wrong in the syntax for Date Field. pls help me.This is my code.it shows Syntax error in INSERT INTO Statement

Dim insertOk As Boolean = True
Dim sqlcon As OleDbConnection = New OleDbConnection("Data Source=C:\Debug\Data.mdb; Provider=Microsoft.Jet.OLEDB.4.0; User ID=Admin")
Try
sqlcon.Open()
ssql = "INSERT INTO mytable (Address,Name,Date) VALUES (@address,@name,@dt)"
sqlcmd = New OleDbCommand(ssql, sqlcon)

sqlcmd.Parameters.Add("@address", TextBox2.Text)
sqlcmd.Parameters.Add("@name", TextBox1.Text)
sqlcmd.Parameters.Add("@dt", Convert.ToDateTime(DateTimePicker1.Value.ToString) )

sqlcmd.ExecuteNonQuery()
Catch ex As OleDbException
MsgBox(ex.Message.ToString)

insertOk = False
Finally
sqlcon.Close()
End Try
If insertOk Then
MsgBox("Details Submitted Successfully!")
Else : MsgBox("There was an error saving your data!")
End If

[kmoorman]

sandhya.o.k,

Since you are getting a syntax error in the Insert statement, perhaps Date is a reserved keyword.

In that case you will need to enclose it in square brackets:

ssql = "INSERT INTO mytable (Address,Name,[Date]) VALUES (@address,@name,@dt)"

Kerry Moorman

[Kamikazi]

sqlcmd.Parameters.Add("@dt", Convert.ToDateTime(DateTimePicker1.Value.ToString()) )

I'm pretty sure that .ToString needs () at the end.

[pclement]

As Kerry mentioned, DATE is an ODBC reserved word. You should rename that column.

[sandhya.o.k]

Thank u for all..... my problem got solved. syntax error was due to Date Field. [ ] solved my problem.
working query is
ssql = "INSERT INTO mytable (Address,Name,[Date]) VALUES (@address,@name,@dt)"


okey.... thank u sooo much.