how to convert bigint of sqlserver into int?

Question

0.00/5 (No votes)

See more:

Hi Sir,
how to store the phone number into the database?
sir, I have taken phone number field of datatype bigint in sql and int in asp.net than when I am giving value from frontend it is giving exception .i.e; "Error in converting bigint to int".

Thank you...

Posted 20-Apr-11 20:02pm

Shristi Tyagi

Updated 20-Apr-11 20:04pm

RaviRanjanKr

v2

Add a Solution

Comments

Shristi Tyagi 21-Apr-11 2:10am

Sir, please tell me how to store a 10 digit phone number into database?
please give any example.

RaviRanjanKr 21-Apr-11 2:28am

Use varchar because standard phone no format start with country codes which are usually specified with +, for instance +12...
as +91 etc. :)

Shristi Tyagi 21-Apr-11 2:37am

sir i have taken but the error is remain same.

RaviRanjanKr 21-Apr-11 3:09am

see my solution :)

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

RaviRanjanKr · Answer 1 · 2011-04-20T20:20:00

The bigint data type follows the same rules and principles as the int data type except that its field can hold numbers from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807. It is somehow equivalent to the C++' long integer but more accurately equivalent to the .NET Framework's System.Int64 data type.
you can also apply this data type for a column that would hold (very) large numbers. The .NET Framework database equivalent to this data type is the SqlInt64 class which resides in System.Data.SqlTypes
The .NET equivalent of SqlDbType.BigInt is Int64 (long) so You can use Convert.ToInt64 and long type.

RaviRanjanKr · Answer 2 · 2011-04-20T21:00:00

In addition to my previous solution this solution based on Shristi Comments

Hey, Shristi I've created a table

create table address(name varchar(25),pno bigint)

you can see I've used pno[PhoneNo] as bigint datatype
and saved data by using below code it works better and saving data successfully

SqlConnection con = new SqlConnection("Database Connection String");
            con.Open();
            SqlCommand cmd = new SqlCommand("insert into address values(@name,@pno)", con);
            cmd.Parameters.Add(new SqlParameter("@name",SqlDbType.VarChar,25));
            cmd.Parameters["@name"].Value = textBox1.Text;
            cmd.Parameters.Add(new SqlParameter("@pno",SqlDbType.BigInt));
            cmd.Parameters["@pno"].Value = Convert.ToInt64(textBox2.Text);
            cmd.ExecuteNonQuery();

Ramalinga Koushik · Answer 3 · 2011-04-20T20:06:00

Solution 1

Hope this[^] might help you.

Posted 20-Apr-11 20:06pm

Ramalinga Koushik

how to convert bigint of sqlserver into int?

3 solutions

Solution 2

Solution 3

Solution 1

Add your solution here

Preview 0