Hi im trying to insert date to my .mdb database, but when i check it, the date turned into random numbers, like 3.2938482
here's my code
Dim constring As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\dbperpus.mdb"
Dim query2 As String = "select * from fpinjam2"
connect = New OleDbConnection(constring)
connect.Open()
cmd = New OleDbCommand(query2, connect)
datar = cmd.ExecuteReader
datar.Read()
Dim insert As String = "insert into fpinjam2 values('" & nimtxt.Text & " ','" & namatxt.Text & "','" & kodetxt.Text & "','" & judultxt.Text & "','" & tanggalpinjam.Text & "'," & tanggalbaliktxt.Text & ")"
cmd = New OleDbCommand(insert, connect)
cmd.ExecuteNonQuery()
MessageBox.Show("insert successful")
connect.Close()
datas.Clear()
mainconnect()
End Sub
image: http://i.imgur.com/yfdyO.png
thanks :)