what is wrong with this insert into code?
vb 2008 say that there is a syntax error but i believe there is nothing..

cmd.CommandText = " INSERT INTO account1(username, password, lname, fname, mi) VALUES('" & Me.TextBox4.Text & "','" & Me.TextBox5.Text & "','" & Me.TextBox1.Text & "','" & Me.TextBox2.Text & "','" & Me.TextBox3.Text & "')"
cmd.ExecuteNonQuery()

Answer Posted / kk

" INSERT INTO account1(username, password, lname, fname, mi) VALUES('" + Me.TextBox4.Text + "','"+ Me.TextBox5.Text + "','" + Me.TextBox1.Text + "','" + Me.TextBox2.Text + "','" + Me.TextBox3.Text + "')"

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In .net how many error will occur?

2420


Program ended with error or warning, return code: 4

13691