System.Data.SqlClient.SqlExcep...

Question

0.00/5 (No votes)

See more:

SQL-Server-2012

Hello,
I am trying to insert mobile number into a variable which is of type int (in sqlserver's database table) from Asp.Net's Textbox control and I am getting this exception

System.Data.SqlClient.SqlException: Error converting data type nvarchar to int.

my code is as follows....
in .aspx file

XML

<asp:TableRow>
                        <asp:TableCell>Mobile No</asp:TableCell><asp:TableCell>:</asp:TableCell><asp:TableCell>
                            <asp:TextBox ID="txtMob" runat="server" TextMode="Phone" /></asp:TableCell>
                    </asp:TableRow>

in .aspx.cs file
SqlParameter p13 = new SqlParameter("Mobile",txtMob.Text.Trim());
cmd.Parameters.Add(p14);
int rowAffected = cmd.ExecuteNonQuery();

when I am trying in the above way i am getting "Error converting data type nvarchar to int." Exception

and when I'm trying to convert data type to int i.e.,
SqlParameter p13 = new SqlParameter("Mobile",Convert.ToInt32(txtMob.Text.Trim()));

when i go for conversion i am getting "System.OverflowException: Value was either too large or too small for an Int32." exception

could anyone please provide solution for my problem???

Posted 8-Apr-15 22:08pm

Bhavani Ch

Add a Solution

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)

Abhinav S · Answer 1 · 2015-04-08T22:17:00

Solution 1

Your mobile number contains some special characters in between.
Could be
1) Spaces 1234 56 78
2) Hyphens 1234-56-78

Thus when you try and convert this string into an integer for storing, even after the trim(), you will get an error.

Posted 8-Apr-15 22:17pm

Abhinav S

Comments

Bhavani Ch 9-Apr-15 4:24am

No, the mobile number which i have entered does not contain any spaces, Hyphens and special characters.. its a 10- digit number

Abhinav S 9-Apr-15 4:44am

Ok. Try using Convert.ToIn64.

A phone number can be stored as a varchar and that will allow you to store special characters as well.

Bhavani Ch 9-Apr-15 7:39am

Also Tried using Convert.ToIn64, that is throwing exception saying that cannot convert from string to long

Sascha Lefèvre · Answer 2 · 2015-04-08T22:18:00

I would suggest you change the type of the column in the database to nvarchar with a sufficient length. A mobile number doesn't need to be treated as an integer - you don't need to use it in calculations. If you want to store it without formatting (like braces, dashes and spaces) you can still remove that from the string before storing it.