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.AddWithValu e("@Sigla" , txtSigla.Text.ToString)
cmd.Parameters.AddWithValu e("@Design acao", txtDesignacao.Text.ToStrin g)
**** cmd.Parameters.AddWithValu e("@DataIn icio", txtDataInicio.Text.ToStrin g)
**** cmd.Parameters.AddWithValu e("@DataFi m", txtDataFim.Text.ToString)
cmd.ExecuteNonQuery()
Me.CursosTableAdapter.Fill (Me.Gestao HorariosDa taSet.Curs os)
con.Close()
But I receive an error. Thefields on the database are defined as date- shortdate.
How an I do it?
Regards
con.Open()
Dim cmd As OleDbCommand = New OleDbCommand("INSERT INTO Cursos (Sigla, Designacao) " _
& "VALUES (?, ?)", con)
cmd.Parameters.AddWithValu
cmd.Parameters.AddWithValu
**** cmd.Parameters.AddWithValu
**** cmd.Parameters.AddWithValu
cmd.ExecuteNonQuery()
Me.CursosTableAdapter.Fill
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.