Syntax error in INSERT INTO statement. in VB.net 2005

Question

I have been this problem for a week and searching every existing forum for an answer maybe this time that i post my own problem.

My problem was in saving a data in a database. I want to save data into access database about picture and data of customer.

It appears that my problem was in INSERT INTO statement, because there was a msgbox appears that every time i try to save a data from textbox. and lastly, I'm new to vb.net. Please help me,please. my coding as below.

    Dim ms As New IO.MemoryStream
    Me.PictureBox1.Image.Save(ms, Me.PictureBox1.Image.RawFormat)
    Dim arrayImage() As Byte = ms.GetBuffer
    ms.Close()
    fdCon.ConnectionString = strConnectionString

    sql = "INSERT INTO TBL_CUSTOMER([id_card],[cus_fname],[cus_lname],[age],[bd_date],[address],[phone],[e_mail],[date_reg],[MATE],[PIC])VALUES (@txtID,@txtFname,@txtLname,@txtAge,@bdDate,@txtAdd,@txtPhone,@txtEmail,@dmDateIN,@txtMate,@Picture"

    'Set SQL OBJECT 
    objSql = New OleDbCommand(sql, fdCon)
    Try
        fdCon.Open()
        With objSql
            .Parameters.Add(New OleDbParameter("@Picture", SqlDbType.Image)).Value = arrayImage

            .Parameters.AddWithValue("@txtID", txtID.Text)
            .Parameters.AddWithValue("@txtFname", txtFname.Text)
            .Parameters.AddWithValue("@txtLname", txtLname.Text)
            .Parameters.AddWithValue("@txtAge", txtAge.Text)
            .Parameters.AddWithValue("@bdDate", bdDate.Text)
            .Parameters.AddWithValue("@txtAdd", txtAdd.Text)
            .Parameters.AddWithValue("@txtPhone", txtPhone.Text)
            .Parameters.AddWithValue("@txtEmail", txtEmail.Text)
            .Parameters.AddWithValue("@dmDateIN", dmDateIN)
            .Parameters.AddWithValue("@txtMate", txtMate.Text)


        End With


        'Execute DataReader 
        MyDataReader = objSql.ExecuteNonQuery

        'Store Values in String Variables 

        'Close Connection 

    Catch ex As Exception
        'TODO HANDLE EX 
        MessageBox.Show(ex.Message)
    End Try
    'DataGridView1.DataSource = 
    fdCon.Close()

OneFineDay · Accepted Answer · 2014-03-14 02:57:12Z

1

You don't have the end ) for the values section.

Dim arrayImage() As Byte
Using ms As New IO.MemoryStream
  Me.PictureBox1.Image.Save(ms, Me.PictureBox1.Image.RawFormat)
  arrayImage = ms.ToArray()
End Using

sql = "INSERT INTO TBL_CUSTOMER([id_card],[cus_fname],[cus_lname],[age],[bd_date],[address],[phone],[e_mail],[date_reg],[MATE],[PIC]) VALUES
      (@txtID,@txtFname,@txtLname,@txtAge,@bdDate,@txtAdd,@txtPhone,@txtEmail,@dmDateIN,@txtMate,@Picture)"

Check out this article.

edited Mar 14, 2014 at 2:57

answered Mar 14, 2014 at 1:36

OneFineDay

9,0344 gold badges28 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

user3418046 Over a year ago

When I fill the end ) for the values section. I have error "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." how to fix it.

OneFineDay Over a year ago

Did you try hovering over the variable to see what it has?

user3418046 Over a year ago

I try to find parameter but not have abnormal. every parameter have to show string.

OneFineDay Over a year ago

If the values are adding are the number of fields in that table you can write it Insert Into TBL_CUSTOMERS Values(...). Otherwise make sure your field names are correct.

Ahmed Salman Tahir Over a year ago

@user3418046 - it is clear from your first comment that the new error says that there is at least one column that has declared to be of lesser capacity than the data you are trying to insert. So your job is to find that column and either reduce the size of data or increase the column capacity.

|

Collectives™ on Stack Overflow

Syntax error in INSERT INTO statement. in VB.net 2005

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related