Question

提示INSERT INTO 语句的语法错误。 报错语句 int i = cmd.ExecuteNonQuery();

报错语句 int i = cmd.ExecuteNonQuery();
添加代码： OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();
string insert_sql = "insert into login_admin values(@username,@password)";
OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = insert_sql;
cmd.Connection = objConnection;
cmd.Parameters.Add("@username", OleDbType.VarChar).Value = txtusername.Text;
cmd.Parameters.Add("@password", OleDbType.VarChar).Value = txtpassword.Text;
int i = cmd.ExecuteNonQuery();
if (i > 0) { MessageBox.Show("注册信息成功！"); }
else {MessageBox.Show("注册信息失败！"); }
objConnection.Close();
添加语句改了还是报错string insert_sql = "insert into login_user (username,password) values(@username,@password)";提示INSERT INTO 语句的语法错误。 报错语句 int i = cmd.ExecuteNonQuery();

Answer 1

public static User AddUser(User user)
{
string sql =
"INSERT Users (LoginId, LoginPwd, Name, Address, Phone, Mail, UserRoleId, UserStateId)" +
"VALUES (@LoginId, @LoginPwd, @Name, @Address, @Phone, @Mail, @UserRoleId, @UserStateId)";
sql += " ; SELECT @@IDENTITY";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@UserStateId", user.UserState.Id), //FK
new SqlParameter("@UserRoleId", user.UserRole.Id), //FK
new SqlParameter("@LoginId", user.LoginId),
new SqlParameter("@LoginPwd", user.LoginPwd),
new SqlParameter("@Name", user.Name),
new SqlParameter("@Address", user.Address),
new SqlParameter("@Phone", user.Phone),
new SqlParameter("@Mail", user.Mail)
};
int newId = DBHelper.GetScalar(sql, para);
return GetUserById(newId);
}

Answer 2

insert into login_admin(user_nm,pwd) values(@username,@password)";

追问

INSERT INTO 语句包含下列未知的字段名： 'user_nm'。确定键入的名称是正确的， 然后重试。

追答

替换成你的列名即可。