C#Oledb 0x80040E14插入错误 [英] C# Oledb 0x80040E14 INSERT INTO error

问题描述

我正在研究一个项目，您可以在其中使用INSERT INTO命令和Acces数据库(OleDB)将用户添加到数据库中.

I'm working on a project where you can add users to a database with the INSERT INTO command and an Acces database (OleDB).

我遇到了0x80040E14错误，但似乎无法解决. 下面的代码:

I'm having an 0x80040E14 error which I can't seem to get solved. Code below:

public void AddUser()
{
    OleDbConnection DATABASE_CONNECTION = new OleDbConnection(CONNECTION_STRING);

    try
    {
        DATABASE_CONNECTION.Open();
        String SQL_QUERY = "INSERT INTO Users(Username, Password, Voornaam, Tussenvoegsel, Achternaam, Email, VolledigeNaam) VALUES(?, ?, ?, ?, ?, ?, ?)";
        OleDbCommand COMMAND = new OleDbCommand(SQL_QUERY, DATABASE_CONNECTION);

        COMMAND.Parameters.AddWithValue("Username", OleDbType.Char).Value = Username;
        COMMAND.Parameters.AddWithValue("Password", OleDbType.Char).Value = Password;
        COMMAND.Parameters.AddWithValue("Voornaam", OleDbType.Char).Value = Voornaam;
        COMMAND.Parameters.AddWithValue("Tussenvoegsel", OleDbType.Char).Value = Tussenvoegsel;
        COMMAND.Parameters.AddWithValue("Achternaam", OleDbType.Char).Value = Achternaam;
        COMMAND.Parameters.AddWithValue("Email", OleDbType.Char).Value = Email;
        COMMAND.Parameters.AddWithValue("VolledigeNaam", OleDbType.Char).Value = VolledigeNaam;

        int rows = COMMAND.ExecuteNonQuery();
        DATABASE_CONNECTION.Close();

        if (rows > 0)
        {
            MessageBox.Show("User added");
        }
        else
        {
            MessageBox.Show("FAIL");
        }
    }
    catch (Exception e)
    {
        MessageBox.Show(e.ToString());
    }
}

推荐答案

密码是保留的关键字在MSAccess中.要使用它，您需要将其用方括号括起来

Password is a reserved keyword in MSAccess. To use it you need to enclose it in square brackets

   String SQL_QUERY = "INSERT INTO Users(Username, [Password], Voornaam, Tussenvoegsel, " + 
                      "Achternaam, Email, VolledigeNaam) VALUES(?, ?, ?, ?, ?, ?, ?)";

但是，如果仍然有可能，请更改列名称，因为此问题会很烦人.

However, if it is still possible, change the column name because this problem will be very annoying.

您的代码中还有另一个错误.

There is another error in your code.

方法

The method AddWithValue requires, as second parameter, the value for of the OleDbParameter, not the type.

  COMMAND.Parameters.AddWithValue("Username", Username);
  ....

这篇关于C#Oledb 0x80040E14插入错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！