Problems with INSERT statement sent to Access

[omi1800]

hi pls someone help me whit this i need to fill a table from visual basic but i try at least every code that have in the net pls someone pls help this is the last code that i imput

Dim sql As String
Dim mycon As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
    "Data Source = gigtoyo.mdb"
Dim dt As New DataTable
sql = "INSERT INTO invoice(invoice, fechatrans, descripcion, nombre, " _
    & modelo, pronto, casafina, fina, total)VALUES(" _
    & TextBox9.Text & ", #" & DateTimePicker1.Text & "#, '" _
    & TextBox3.Text & "', '" & TextBox1.Text & "', '" & TextBox2.Text _
    & "', '" & TextBox7.Text & "', " & TextBox6.Text & ", " _
    & TextBox8.Text & ", " & TextBox4.Text & ")"
Dim sqlexe As New OleDb.OleDbDataAdapter(sql, mycon)
sqlexe.Fill(dt)
sqlexe.Dispose()

[Dököll]

hi pls someone help me whit this i need to fill a table from visual basic but i try at least every code that have in the net pls someone pls help this is the last code that i imput

 
        Dim sql As String
        Dim mycon As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source = gigtoyo.mdb"
        Dim dt As New DataTable
        sql = "INSERT INTO invoice(invoice, fechatrans, descripcion, nombre, modelo, pronto, casafina, fina, total)VALUES(" & TextBox9.Text & ", #" & DateTimePicker1.Text & "#, '" & TextBox3.Text & "', '" & TextBox1.Text & "', '" & TextBox2.Text & "', '" & TextBox7.Text & "', " & TextBox6.Text & ", " & TextBox8.Text & ", " & TextBox4.Text & ")"
        Dim sqlexe As New OleDb.OleDbDataAdapter(sql, mycon)
        sqlexe.Fill(dt)
        sqlexe.Dispose()

Hello, omi1800!

You are missing single quotes in your VALUES command:

('" & TextBox9.Text & "', and others within the same command

You now have (" & TextBox9.Text & ",

Also, I do not think #" & DateTimePicker1.Text & "#, will work, try getting rid of the # sign there, add single quotes run it again.

Good luck with the project!

Dököll

[Killer42]

...
Also, I do not think #" & DateTimePicker1.Text & "#, will work, try getting rid of the # sign there, add single quotes run it again.

If the field type is Date/Time, then I'm fairly certain you do need the # delimiters. However, you should force the date into U.S. format (mm/dd/yyyy). Alternatively, I think you can probably get away with a format which can't be easily confused, such as one with the month in text (Eg. #7 May 2007#).

By the way omi1800, you didn't say what the problem is, or what version of VB you're using.

[Dököll]

Ahhh! I was reminded of a query in VB 6, please carry on...Thanks.