error when executing query using sqlcommand in c#

Question

Here's my code:

string createString = "CREATE TABLE user (uid INT PRIMARY KEY IDENTITY(1,1), uname NVARCHAR(30), uemail NVARCHAR(30), upass NVARCHAR(20), ucontact INT(10))"; //YOUR SQL COMMAND TO CREATE A TABLE

SqlConnection connection = new SqlConnection("Data Source=DELL\\SQLEXPRESS;Integrated Security=True;Connect Timeout=1000000;Encrypt=False;TrustServerCertificate=False;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");

SqlCommand create = new SqlCommand(createString, connection);

connection.Open();
create.ExecuteNonQuery();
connection.Close();

I get the following error:

Incorrect syntax near the keyword 'user'

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near the keyword 'user'.

Soner Gönül · Accepted Answer · 2015-07-28 08:05:03Z

5

user is a reserved keyword in T-SQL. You need to use it with square brackets like [user]

As best practice, change it to non-reserved word.

Also use using statement to dispose your connection and commands automatically instead of calling Close method manually.

using(var connection = new SqlConnection(connectionString))
using(var create = connection.CreateCommand())
{
     create.CommandText = "...";
     connection.Open();
     create.ExecuteNonQuery();
}

edited Jul 28, 2015 at 8:05

answered Jul 28, 2015 at 8:01

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

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

Comments

too_cool · Accepted Answer · 2015-07-28 08:17:13Z

1

Table name user is predefined word, change table name or use [user] and also column ucontact has datatype int with size, int will not accept size. That should be ucontact INT Finaly your query will look like this

CREATE TABLE [user] (uid INT PRIMARY KEY IDENTITY(1,1), uname NVARCHAR(30), uemail NVARCHAR(30), upass NVARCHAR(20), ucontact INT)

edited Jul 28, 2015 at 8:17

too_cool

1,20410 silver badges24 bronze badges

answered Jul 28, 2015 at 8:04

Chandrashekar Jupalli

3573 silver badges15 bronze badges

Collectives™ on Stack Overflow

error when executing query using sqlcommand in c#

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related