Date Field

[sn15164]

Hi I am new to VB 2010. I have the following code which saves the data from 4 text boxes. The last one is a date field (txtdate) in the database and it gives me error on it. Can you please let me know what is the syntax to specify a date value? I tried with and without quotes. But didn't work.

Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
        Dim cn As New OleDb.OleDbConnection
        cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Test\db1.mdb;Persist Security Info=True"
        cn.Open()
        Dim Command As OleDb.OleDbCommand

        Command = New OleDb.OleDbCommand("INSERT INTO Projects1(ProjectID, ProjectName, ProjectDesc, ProjectDate)" & _
        " VALUES (" & txtid.Text & ",'" & txtname.Text & "', '" & txtdesc.Text & "', '" & txtdate.Text & "')", cn)
        Command.ExecuteNonQuery()
        cn.Close()
        MsgBox("New Records Added to the database")
    End Sub

[jmcilhinney]

Don't use string concatenation to build SQL statements. Use parameters and this and various other issues just go away. Follow the Blog link in my signature and check out my post on Parameters In ADO.NET to learn how.

[sn15164]

Thank You. will do that.