在INSERT INTO语句的语法错误 [英] Syntax error in INSERT INTO statement

问题描述

我有一个问题，当我米，Access数据库，然后我M在INSERT INTO语句得到一个错误语法错误连接。我的code是：

I have a problem when i m connection with access database then i m getting a error Syntax error in INSERT INTO statement. and my code is :

 string str = ("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:/Users/Geeta/Desktop/Database2.accdb;Persist Security Info=False;");
        OleDbConnection conn = new OleDbConnection(str);
        conn.Open();
        string query = "insert into data (FirstName,Email,Password,Address) values ('" + 
            txt_fstname.Text + "','" + txt_email.Text + "', '" + 
            txt_pass.Text + "', '" + txt_add.Text + "')";
        OleDbCommand cmd = new OleDbCommand(query,conn);
        cmd.ExecuteNonQuery();
        conn.Close();
        Response.Redirect("Default.aspx");

PLZ给我建议。

plz suggest me.

谢谢。

推荐答案

密码是一个保留字在喷气/ ACE SQL，所以你必须将它在方括号：

Password is a reserved word in Jet/ACE SQL so you must enclose it in square brackets:

string query = "insert into data (FirstName,Email,[Password],Address) values ('" + 

这篇关于在INSERT INTO语句的语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！