Why this code isnt working

Question

1.00/5 (1 vote)

See more:

I've this code to create a table if it doesnt exists:

CSS

MessageBox.Show("create table");
                    conn.Open();
                    SqlCommand command = new SqlCommand("IF OBJECT_ID('UXMenu', 'U') IS NULL CREATE TABLE UXMenu(ID int PRIMARY KEY AUTOINCREMENT, TransDocument char(5), TransSerial char(5), TransDocNumber float, PartyName char(60), PartyLocalityID char(5), TotalAmount char (25), ShipToPostalCode char(35), Estado int);", conn); command.ExecuteNonQuery();
                    MessageBox.Show("tabela criada");
conn.close();

But this code isnt working, I get the first messagebox but then it just ignores the rest of the code and doesnt create anything.

What I have tried:

CSS

MessageBox.Show("create table");
                    conn.Open();
                    SqlCommand command = new SqlCommand("IF OBJECT_ID('UXMenu', 'U') IS NULL CREATE TABLE UXMenu(ID int PRIMARY KEY AUTOINCREMENT, TransDocument char(5), TransSerial char(5), TransDocNumber float, PartyName char(60), PartyLocalityID char(5), TotalAmount char (25), ShipToPostalCode char(35), Estado int);", conn);
                    command.ExecuteNonQuery();
                    MessageBox.Show("tabela criada");
conn.close();

Posted 25-Aug-17 5:00am

Member 13356973

Updated 25-Aug-17 5:56am

v3

Add a Solution

Comments

Richard Deeming 25-Aug-17 11:04am

Three options:

1) The code is executing;
2) The code is throwing an exception;
3) The code you're running isn't the code you're looking at;

If it's #2, then you need to show us the full details of the exception.

Debug your code and step through it line by line to see where it's going wrong.

Richard Deeming 25-Aug-17 11:07am

NB: If you're using Microsoft SQL Server, you're most likely getting a SQL syntax exception relating to AUTOINCREMENT. That's a Microsoft Access keyword; in SQL, you use the IDENTITY property instead.

Member 13356973 25-Aug-17 11:09am

1: The code isnt executing;
2: I dont get any exception;
3: The code I'm looking is the code that is running.

Jochen Arndt 25-Aug-17 11:14am

If that is the code you are running:
Why do you execute

command.ExecuteNonQuery();

twice?

Member 13356973 25-Aug-17 11:14am

It was the IDENTITY problem now its solved thanks

Member 13356973 25-Aug-17 11:16am

twice? I only do it once

Jochen Arndt 25-Aug-17 11:19am

The first time in the same line as the SqlCommand creation and then again in the next line.

Member 13356973 25-Aug-17 11:20am

Sorry I cant understand you

Jochen Arndt 25-Aug-17 11:27am

Why do you have edited your question then and removed the first call from the "What I have tried" section?

But you forgot the first code snippet.

Member 13356973 25-Aug-17 11:34am

code snippet?

Jochen Arndt 25-Aug-17 11:52am

First block of code (snippet = fragmento).

ZurdoDev 25-Aug-17 11:51am

Post something as solution so that this no longer shows unanswered.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 13356973 · Accepted Answer · 2017-08-25T05:56:00

SqlCommand command = new SqlCommand("IF OBJECT_ID('UXMenu', 'U') IS NULL CREATE TABLE UXMenu(ID int PRIMARY KEY IDENTITY(1,1), TransDocument char(5), TransSerial char(5), TransDocNumber float, PartyName char(60), PartyLocalityID char(5), TotalAmount char (25), ShipToPostalCode char(35), Estado int);", conn);