Private Sub cmdspei_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdspei.Click
'Dim con As New OleDb.OleDbConnection
Dim cmd As New OleDb.OleDbCommand
'Dim anzahl As Integer
Try
cmd.CommandText = _
"INSERT INTO tab_spot(Kundenname, Spotname, Sprecher1, Sprecher2, Sprecher3, Branche, Musik, Spottext, Spotbeschreibung, Spotlaenge)" & _
"VALUES (" + txtkname.Text + "," + txtspname.Text + "," + txtsp1.Text + "," + txtsp2.Text + "," + txtsp3.Text + "," + cmdbra.Text + "," + txtmus.Text + "," + txtsptex.Text + "," + txtkbez.Text + "," + txtspl.Text + ")"
MsgBox(cmd.CommandText)
Catch ex As Exception
MsgBox(ex.Message)
End Try
End Sub
das ist der Quellcode.
und ich sehe einfach nicht wo da was falsch sein soll.