Error converting data type nvarchar to numeric.

Question

1.00/5 (1 vote)

See more:

C#

SqlConnection sc = new SqlConnection(System.Web.Configuration.WebConfigurationManager.ConnectionStrings["hospitalmanagementdb"].ToString());
            SqlCommand cmd = new SqlCommand("insert into ward values((select (patient_id) from patient),'" + "','1'" + System.DateTime.Today.Date.ToString()+ "','admit'"+ "','paid')", sc);
           
            cmd.Connection = sc;
            sc.Open();
            cmd.ExecuteNonQuery();
            sc.Close();

error: Error converting data type nvarchar to numeric.

help me to solve this error

Posted 2-Apr-14 6:40am

Member 10694442

Updated 2-Apr-14 18:54pm

Er. Puneet Goel

v2

Add a Solution

Comments

[no name] 2-Apr-14 12:46pm

show your ward table column names with data type

5 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)

OriginalGriff · Answer 1 · 2014-04-02T07:03:00

Solution 1

Probably, you have an ID column, that is identity and you are not specifying it -and you can't- but because you don't specify which columns you want to load data into SQL tries to set them in internal column order.
Name your columns!

SQL

INSERT INTO MyTable (col1, col2) VALUES (1, 2)

and your problem will probably go away...

Posted 2-Apr-14 7:03am

OriginalGriff

Comments

Maciej Los 2-Apr-14 13:10pm

Sure!
+5!

Maciej Los · Answer 2 · 2014-04-02T07:17:00

Solution 2

You should know that using queries in code behind is a bad practice, especially when you're ASP.NET programmer.

How many times we have warned members about SQL injection[^]? I don't know. Please, follow the link and learn best practices.

Posted 2-Apr-14 7:17am

Maciej Los

Comments

Member 10694442 2-Apr-14 13:59pm

excuse me mr.Maciej Los. i m beginner of asp.net
thats why i have such problems

Maciej Los 2-Apr-14 14:02pm

Do not excuse. We are here to help you ;)

Maciej Los 2-Apr-14 14:03pm

By The Way: If my answer was helpful, please mark it as a solution (green button).

PJ003 3-Apr-14 2:15am

+5

Maciej Los 3-Apr-14 3:21am

Thank you ;)

Aarti Meswania · Answer 3 · 2014-04-02T20:07:00

Solution 3

Hi,
This exception occures when try to insert characters in a column having numeric datatype
Happy Coding!
:)

Posted 2-Apr-14 20:07pm

Aarti Meswania

Ajay_Babu · Answer 4 · 2014-04-02T20:13:00

refer below link you will get an idea about insert.
http://www.w3schools.com/sql/sql_insert.asp[^]

You need mention column name if you want to insert some columns into a table like

if a table has 3 cols like col1,col2.col3.inorder to insert col2, col3 values use below query

insert into tablename(col1,col2) values ('val2;,'val3');

Kan07 · Answer 5 · 2014-04-02T20:46:00

Solution 5

i think there a mistake in insert into- select syntax

insert into ward(//specify columns) values(select patient_id ,'" + "','1'" + System.DateTime.Today.Date.ToString()+ "','admit'"+ "','paid')" from patient)

Posted 2-Apr-14 20:46pm

Kan07

Error converting data type nvarchar to numeric.

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us