Member Avatar for helen eyob

i'm trying to INSERT simple data to database access 2007 using vb.net 2008 but when i click the button insert

it say's Syntax error in INSERT INTO statement

  • 3 Contributors
  • 3 Replies
  • 248 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by obeng.adomakobismark
Member Avatar for helen eyob

please could u help me

Member Avatar for Reverend Jim

It would help if you showed us the code that you are using. Please provide the exact query.

qry = "INSERT INTO mytable (fld1,fld2) " &
      "       VALUES(" & TextBox1.Text   &
      "             ," & TextBox2.Text   & 
      ")"

probably won't help because the actual query depends on the values from the textbox controls. What we need is

qry = "INSERT INTO mytable (fld1,fld2) " &
      "       VALUES(" & TextBox1.Text   &
      "             ," & TextBox2.Text   & 
      ")"
Debug.WriteLine(qry)

the string that is displayed by Debug.WriteLine. That will show us the actual query text.

Member Avatar for obeng.adomakobismark

please am a begginer in vb.net and i want to use it to create user interface for my library mangement system any help as to hw to start.thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.