HelpMe: System.Data.OleDb.OleDbException: SyntaxError in INSERT INTO statement error"

[RameshKumar]

Emailid = TBEmailName.Text & “” & CBDomain.Text
Con = New OleDbConnection(“Provider=Microsoft.ACE.OleDb.12.0; Data Source=DataBase\Dashbard.accdb; Presist Info Security = False”)
               Con.Open()
               Cmd = New OleDbCommand(“INSERT INTO EmpDatas(EmpID,Name,EmailID,Password) VALUES(‘” & TBEmpID.Text & ”’,’” & TBEmpName.Text & ”’ ,’” & Emailid & ”’ ,’” & TBPass.Text & ”’)”, Con)
               Cmd.ExecuteNonQuery()
       MsgBox(“Data Saved Successfully”, MessageBox.Style= Information)
       Con.Close()
 

[code green]

There is something wrong in this line

Cmd = New OleDbCommand(“INSERT INTO EmpDatas(EmpID,Name,EmailID,Password) VALUES(‘” & TBEmpID.Text & ”’,’” & TBEmpName.Text & ”’ ,’” & Emailid & ”’ ,’” & TBPass.Text & ”’)”, Con)

It is better to display the SQL query as a string to spot the problem

[RameshKumar]

Hi Code green,
I have one more project i have use the same coding. In that is working. Please check once again ya.
I have poste my full code in the below link
http://bytes.com/topic/net/answers/9...ry#post3665154

[code green]

I'd don't need to look at your code.
The problem is the SQL query itself.
Your code has no way of determining whether the data entered in the testboxes is valid.
The data in the texboxes then forms part of the query.
If the textboxes are empty or contain invalid characters the query will fail