i want vb.net 2008 code using ms access 2007

[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

[helen eyob]

please could u help me

[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.

[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