c# - 使用 C# 和 MS Access SQL 创建表

Question

我试图在我的数据库中创建一个表，但我被告知我的 SQL 语法有错误。我真的不知道在哪里。

objOleDbCommand.CommandText = "CREATE TABLE PersonalData (" +
    "[DataID] AUTOINCREMENT NOT NULL PRIMARY KEY ," +
    "[Type] VARCHAR(40) NOT NULL ," +
    "[URL] VARCHAR(40) NOT NULL ," +
    "[SoftwareName] VARCHAR(40) NOT NULL ," +
    "[SerialCode] VARCHAR(40) NOT NULL ," +
    "[UserName] VARCHAR(40) NOT NULL ," +
    "[Password] VARCHAR(40) NOT NULL";

objOleDbCommand.ExecuteNonQuery();

Answer 1

您似乎缺少右括号。此外，为了使代码更具可读性，请考虑使用 @"" 构造，它允许多行字符串文字:

objOleDbCommand.CommandText = @"CREATE TABLE PersonalData (
    [DataID] AUTOINCREMENT NOT NULL PRIMARY KEY,
    [Type] VARCHAR(40) NOT NULL,
    [URL] VARCHAR(40) NOT NULL,
    [SoftwareName] VARCHAR(40) NOT NULL,
    [SerialCode] VARCHAR(40) NOT NULL,
    [UserName] VARCHAR(40) NOT NULL,
    [Password] VARCHAR(40) NOT NULL
)";