View Single Post
 
Old July 24th, 2004, 10:18 AM
RPG SEARCH RPG SEARCH is offline
Friend of Wrox
 
Join Date: Apr 2004
Location: Preston, Lancashire, United Kingdom.
Posts: 105
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to RPG SEARCH
Default

Ok none of those worked. but it doesnt matter i decided just to hard code the database connection into it..... i suck at this databse reading and inserting.

I am now trying to insert something into the database. i used my own code to start with but that i really not working... so used the example on page 311 of the beginners guides. in debug mode it gives me...

Exception Details: System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.

Line 22: dbCommand.Parameters.Add(NameParam)
Line 23:
Line 24: dbCommand.ExecuteNonQuery() this is where the error is
Line 25:
Line 26: dbConnection.Close()

can anyone help me with this one