Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: AccessVB.NETMS-Access, +
I'm always getting this error since i added a couple of column in the tblapplicants table. NOTE: I'm using ms access and the data type i'm using is short text (for testing only)
 
Here is my code:
 
Private Sub addtodb()
        Dim querytodb As String
        querytodb = String.Format("INSERT INTO tblapplicants (program, fname, mname, lname, sex, civilstatus, address, highschoolatt, highschooladd, colunivatt, colunivadd, course, companyname, workexpyrs, degree, birthday, birthplace, nationality, religion, language, mobno, telno, emailadd, yrgraduatedhs, yrgraduatedcoluniv) Values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}')", _
                                  programcb.Text, fnametb.Text, mnametb.Text, lnametb.Text, sexcb.Text, cscb.Text, addresstb.Text, hstb.Text, hsatb.Text, cutb.Text, cuatb.Text, coursetb.Text, noctb.Text, yearswecb.Text, degreefcb.Text, bdtp.ToString, birthplacetb.Text, nationalitytb.Text, religiontb.Text, languagetb.Text, mobilenotb.Text, telnotb.Text, eaddtb.Text, graduatedhstb.Text, graduatedcoltb.Text)
        Try
            conn.Open()
            Dim cmd As OleDbCommand = New OleDbCommand(querytodb, conn)
            cmd.ExecuteNonQuery()
        Catch ex As OleDbException
            MsgBox("Database Insertion Error!" + vbNewLine + ex.ToString & vbCrLf, MsgBoxStyle.Critical, Title:="Database Error!")
            'error logging
            My.Computer.FileSystem.WriteAllText(Application.StartupPath + "_error_log.txt", ex.ToString, True)
            'MsgBox("Database Insertion Error!", MsgBoxStyle.Critical, Title:="Database Error!")
        Finally
            conn.Close()
            'MsgBox("Student Successfully Added!")
        End Try
    End Sub
 
Here is the error:
 
System.Data.OleDb.OleDbException (0x80040E14): Syntax error in INSERT INTO statement.
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
   at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
   at eteeap.AddApplicant.addtodb() in C:\Users\anonsec\Documents\Visual Studio 2010\Projects\eteeap\eteeap\AddApplicant.vb:line 15
 
The line 15 in my code is the cmd.ExecuteNonQuery()
 
Thanks for the help. I hope you'll help me. Thanks Guys.
Posted 7-Dec-12 15:31pm
Edited 7-Dec-12 16:17pm
Tadit Dash85.5K
v3
Comments
@AmitGajjar at 7-Dec-12 22:04pm
   
you do not need single quotation when passing parameter.
joenel of ph at 7-Dec-12 23:58pm
   
What do you mean sir. But it works while ago. Is there another method of inserting into the database programmatically?
@AmitGajjar at 8-Dec-12 3:23am
   
use stored procedure. it will be easier to maintain
Krunal Rohit at 8-Dec-12 0:08am
   
For inserting values, you've defined 2 closing braces and only one opening brace... Please make it correct..
joenel of ph at 8-Dec-12 0:40am
   
I cant get it. what line number is it. Thanks for the help :(
Krunal Rohit at 8-Dec-12 0:41am
   
Values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}','{21}','{22}','{23}','{24}')", _ programcb.Text, fnametb.Text, mnametb.Text, lnametb.Text, sexcb.Text, cscb.Text, addresstb.Text, hstb.Text, hsatb.Text, cutb.Text, cuatb.Text, coursetb.Text, noctb.Text, yearswecb.Text, degreefcb.Text, bdtp.ToString, birthplacetb.Text, nationalitytb.Text, religiontb.Text, languagetb.Text, mobilenotb.Text, telnotb.Text, eaddtb.Text, graduatedhstb.Text, graduatedcoltb.Text)
joenel of ph at 8-Dec-12 0:48am
   
Is it already correct? i can't insert this always shows INSERT INTO error even i change it :(
Krunal Rohit at 8-Dec-12 0:41am
   
here..

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

Can you verify whether any of the field values are exceeding the maximum allowed size in database? Please double check table structure and the value passed for insert.
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 686
1 OriginalGriff 498
2 Tadit Dash 420
3 sanket saxena 337
4 Zoltán Zörgő 230
0 Sergey Alexandrovich Kryukov 11,800
1 OriginalGriff 7,225
2 Peter Leow 5,009
3 Abhinav S 3,893
4 Maciej Los 3,575


Advertise | Privacy | Mobile
Web01 | 2.8.140421.2 | Last Updated 9 Dec 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid