Creating a table by using C# and MS Access SQL

Question

I am trying to create a table in my database by I am being told that there is an error in syntax of my SQL. And I can't really tell where.

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();

Jørn Schou-Rode · Accepted Answer · 2011-11-25 09:04:38Z

6

You seem to be missing a closing parenthesis. Also, to make the code slightly more readable, consider using the @"" construct, which allows multi line string literals:

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
)";

answered Nov 25, 2011 at 9:04

Jørn Schou-Rode

38.5k16 gold badges91 silver badges123 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

HelpNeeder Over a year ago

Duh! Yes I did... I need a break, I'm tired.

Coding Flow · Accepted Answer · 2011-11-25 09:09:15Z

1

You are missing a closing bracket at the end. IE:

  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();

answered Nov 25, 2011 at 9:09

Coding Flow

21.9k6 gold badges68 silver badges84 bronze badges

Collectives™ on Stack Overflow

Creating a table by using C# and MS Access SQL

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related