Syntax Error in INSERT INTO,UPDATE statement

[abhijmenbumca07]

I am facing problem while inserting new rows into a access database.

The code i've written for doing so into button_click event is:-

dim con as OledbConnection
dim s as String
dim cmd as OledbCommand
 
con=New OledbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=D:\nazarath.mdb")
 
s="Insert into majorhead (mjhd, desc) Values ( '" & Me.TextBox1.Text & "','" & Me.TextBox2.Text & "')"
 
cmd=New OledbCommand(s, con)
 
con.Open()
 
cmd.ExecuteNonQuery()
 
con.Close

I'm developing in asp.NET application.


I' ve done so rightly yesterday. But today I'm facing problem.

[vijaydiwakar]

I am facing problem while inserting new rows into a access database.

The code i've written for doing so into button_click event is:-

dim con as OledbConnection
dim s as String
dim cmd as OledbCommand

con=New OledbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0; DATA Source=D:\nazarath.mdb")

s="Insert into majorhead (mjhd, desc) Values ( '" & Me.TextBox1.Text & "','" & Me.TextBox2.Text & "')"

cmd=New OledbCommand(s, con)

con.Open()

cmd.ExecuteNonQuery()

con.Close

I'm developing in asp.NET application.


I' ve done so rightly yesterday. But today I'm facing problem.

Dear first of all just rename the field name form desc to mydescription or any other name b'coz desc is reserved word in mdb and then tell me the problem