Databases
StackOverflow2013
Postsdbo
POVisual Studio 10.0 cannot insert values into a table with an identity field (syntax error)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POVisual Studio 10.0 cannot insert values into a table with an identity field (syntax error)
    primarykey
    data
    text
    <p>My issue is that I have created a table for a local db in Visual Studio 10.0 using C# and I want to have an auto-incrementing field which I have setup. The table is created and the identity field seems to be setup correctly and everything seems fine, but I always get a syntax error on the insert when I use an identity field -- so I imagine I have a stupid little typo, but perhaps this is just not supported using VS?</p> <p>This is the create table string and execution:</p> <pre><code>-connection string omitted- string createTableString = @"CREATE TABLE [Test]( [Test_ID] [int] IDENTITY (1,1) PRIMARY KEY NOT NULL, [OtherField] [varchar] (50))"; SqlCommand command = new SqlCommand(createTableString, con); command.ExecuteNonQuery(); </code></pre> <p>And this is what I'm using to insert into the table:</p> <pre><code>string insertString = @"INSERT INTO Test VALUES ('sometext')"; SqlCommand command1 = new SqlCommand(insertString, con); command1.ExecuteNonQuery(); </code></pre> <p>Note that I've tried this as well and get the same syntax error:</p> <pre><code>string insertString = @"INSERT INTO Test (OtherField) VALUES ('sometext')"; SqlCommand command1 = new SqlCommand(insertString, con); command1.ExecuteNonQuery(); </code></pre> <p>Also note that for this project I must do this via these scripting commands in Visual Studio. Is this possible? Thanks very much ahead of time.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USBob Ryder
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POVisual Studio 10.0 cannot insert values into a table with an identity field (syntax error)
      1. This table or related slice is empty.
      1. VTDownMod
    2. VO
      singulars
      1. POVisual Studio 10.0 cannot insert values into a table with an identity field (syntax error)
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. POVisual Studio 10.0 cannot insert values into a table with an identity field (syntax error)
      1. This table or related slice is empty.
      1. VTDownMod
    1. COWhat exactly is the syntax error? Are you able to edit the table in SQL Management Studio?
      singulars
      1. POVisual Studio 10.0 cannot insert values into a table with an identity field (syntax error)
      1. USJon Skeet
    2. COwhat is the error/exception message when you command run, also after your table created, can you add 1 from sql?
      singulars
      1. POVisual Studio 10.0 cannot insert values into a table with an identity field (syntax error)
      1. USuowzd01
    3. COYes, I am able to edit the table in SQL Management studio. In the show data mode, I can tab right through the first column, enter a value in the second column, and it will populate the first column with the auto-incremented correct number. So the table itself seems to be working and setup correctly, but the insert command is somehow not addressing the identity field (for the increment). The error is 'incorrect syntax near Test' (referring to the second instance, the error is on the line command1.ExecuteNonQuery()) 'SqlException was unhandled by user code'
      singulars
      1. POVisual Studio 10.0 cannot insert values into a table with an identity field (syntax error)
      1. USBob Ryder
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload