SqlException Incorrect syntax near '16210535'.

Question

0.00/5 (No votes)

See more:

Hi, can you please help me here. I am having this error, when I try to insert data. I have two tables with a foreign key relationship. I tried to debug the exception happens when it reaches cmd.ExecuteNonQuery();. Please help me.

SQL

CREATE TABLE TB_User
(
	UserId varchar(128) PRIMARY KEY NOT NULL,
	FirstName varchar(50) NOT NULL,
	LastName varchar (50) NOT NULL,
	Email varchar (128) NOT NULL,
	PhoneNumber varchar(15) NOT NULL,
	UserType varchar(50) NOT NULL,
	Password varchar (128) NOT NULL,
)

SQL

CREATE TABLE TB_Property
(
	PropertyId varchar(128) PRIMARY KEY NOT NULL,
	PropertyType varchar (128) NOT NULL,
	Area varchar(50) NOT NULL,
	Price decimal (18,0) NOT NULL,
	UserId varchar(128) FOREIGN KEY REFERENCES TB_User(UserId) NOT NULL
	
)

I got the current user id from query string, then after that, I tried to store the Id in property table. while debugging, I tried to check the query string, the Id exists already in the user table.

C#

if (Request.QueryString["UserId"].ToString() != null)
                {
                    currentUserId = Request.QueryString["UserId"].ToString();
}

This is the insertion query.

SQL

SqlCommand cmd = new SqlCommand("INSERT INTO TB_Property(PropertyId, PropertyType, Area, Price,UserId) VALUES(NEWID(), @PropertyType, @Area,@Price, '"+ currentUserId +"')", conn);

Posted 23-Dec-13 18:09pm

Member 10215709

Add a Solution

Comments

Karthik_Mahalingam 24-Dec-13 1:19am

post your full ADO code...

Member 10215709 24-Dec-13 3:45am

Here is the remaining code.

cmd.Parameters.AddWithValue("@PropertyType", propertyType);
cmd.Parameters.AddWithValue("@Area", area);
cmd.Parameters.AddWithValue("@Price", price);
cmd.Parameters.AddWithValue("@UserId", currentUserId);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

the exception is when it reaches cmd.ExecuteNonQuery();

2 solutions

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)

sameer549 · Answer 1 · 2013-12-23T18:16:00

Solution 1

Hi if NEWID() is a method that return any value, then try this,

SQL

SqlCommand cmd = new SqlCommand("INSERT INTO TB_Property(PropertyId, PropertyType, Area, Price,UserId) VALUES('"+NEWID()+"', @PropertyType, @Area,@Price, '"+ currentUserId +"')", conn);

hope it helps,

Regards
Sameer

Posted 23-Dec-13 18:16pm

sameer549

ravikhoda · Answer 2 · 2013-12-24T19:21:00

Solution 2

try and keep property id autogenerated from databse only using increment by 1. then you dont need to pass property id from the code. otherwise your code looks good.

Posted 24-Dec-13 19:21pm

ravikhoda