Link to home
Start Free TrialLog in
Avatar of RUIDEOLIVEIRA
RUIDEOLIVEIRA

asked on

VB 2008 - How to update DATE field on MS_Access Table

I have the following code in order to insert a record on a Access Table:

        con.Open()
        Dim cmd As OleDbCommand = New OleDbCommand("INSERT INTO Cursos (Sigla, Designacao) " _
        & "VALUES (?, ?)", con)
        cmd.Parameters.AddWithValue("@Sigla", txtSigla.Text.ToString)
        cmd.Parameters.AddWithValue("@Designacao", txtDesignacao.Text.ToString)
****        cmd.Parameters.AddWithValue("@DataInicio", txtDataInicio.Text.ToString)                
****        cmd.Parameters.AddWithValue("@DataFim", txtDataFim.Text.ToString)
        cmd.ExecuteNonQuery()
        Me.CursosTableAdapter.Fill(Me.GestaoHorariosDataSet.Cursos)
        con.Close()

But I receive an error. Thefields on the database are defined as date- shortdate.

How an I do it?

Regards
ASKER CERTIFIED SOLUTION
Avatar of RUIDEOLIVEIRA
RUIDEOLIVEIRA

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial