cmd.executenonquery()

[preedhu]

To insert a data into the data base, to the best of my knowledge the code i have written is correct.. but i frequently get this error.. hope I will receive a proper solution for my query.

The code is:

imports system.data.oledb
 
dim cn as new oledbconnection
dim cmd as new oledbcommand
 
under the insert button:
cn.open()
cmd.connection=cn
cmd.connectionstring=""
cmd.commandtype=data.commandtype.text
cmd.commandtext="insert into tablename values("")"
msgbox("inserted")
cn.close()

thanks,
Preethy

[MrMancunian]

but i frequently get this error

What error?

cmd.connectionstring=""

Why is there no connectionstring?

Take a look at Insight: Creating database connections without using wizards, How To Use A Database In Your Program Part I and How To Use A Database In Your Program Part II. That should help you.

Steven

[semomaniz]

Please show us the entire code. Best way is to replace the actual table names and connection string with bogus values. And also use try catch block its really handy

[Frinavale]

Line 11 has a problem with it.
You cannot have:

cmd.commandtext="insert into tablename values("")"

Do you see why?
Your string is messed up.....

You should probably review the articles that MrMancunian linked you to.

-Frinny