How to save digit contains 14 digits use c# + sql server

Question

How to save digit contains 14 digits c# use sql server

Bikesh Srivastava · Answer

Int is not support more than 10 digit. so use bigint instead of int

ketan borsdiya · Answer

Can you provide error details

Midhun Tp · Answer

Hi, You can use float datatype in sql and pass data as double from c#

Abdalla Elawad · Answer

hi this is code c# : t ry { S qlCommand cmd = new SqlCommand("InBound_Insert", Conn); cmd.Parameters.Add("@CarNo", SqlDbType.BigInt).Value = Convert.ToInt64((DropDownList1.SelectedValue)); cmd.Parameters.Add("@TeamNo", SqlDbType.BigInt).Value = Convert.ToInt64( (DropDownList2.SelectedValue));

Nitin Sontakke · Answer

You have shared the code which has absolutely no issues. If you have problem on C# side, may sharing that code could have been helpful. If you are reading data from SqlDataReader, use GetInt64 method.

Midhun Tp · Answer

Hi, What's your issue with select statement? Why do you need to convert data in select statement?

Abdalla Elawad · Answer

hi guys oki i create stored procedures , and insert data as bigint are inserted but I have problem in Select statement when we return bigint i need to convert bigint in Proc or C# code as follow Proc Insert : USE CASH_PLAN GO CREATE PROC InBound_Insert (@VehcileKey bigint ,@FleetNo bigint ,@RegisterNo bigint ,@RegisterAlpha nvarchar(10) ,@Customer nvarchar(50) ,@ServiceType nvarchar(10) ,@TripTeam nvarchar(30) ,@EmpCustd2 nvarchar(50) ,@EmpCustd1 nvarchar(50) ,@EmpDriver nvarchar(50) ,@ID_Driver bigint ,@ID_Cusdt2 bigint ,@ID_Cusdt1 bigint ,@PostionDriver nvarchar(20) ,@PositionCusd2 nvarchar(20) ,@PositionCusd1 nvarchar(20) ,@MobileCustd2 nvarchar(20) ,@MobileCustd1 nvarchar(20) ,@MobileDriver nvarchar(20) ,@Weapon bigint ,@WeaponBullets bigint ,@HandheldTerm bigint ,@CustomerKey bigint ,@Mileage bigint) AS BEGIN INSERT INTO InBound (VehcileKey ,FleetNo ,RegisterNo ,RegisterAlpha ,Customer ,ServiceType ,TripTeam ,EmpCustd2 ,EmpCustd1 ,EmpDriver ,ID_Driver ,ID_Cusdt2 ,ID_Cusdt1 ,PostionDriver ,PositionCusd2 ,PositionCusd1 ,MobileCustd2 ,MobileCustd1 ,MobileDriver ,Weapon ,WeaponBullets ,HandheldTerm ,CustomerKey ,Mileage) VALUES (@VehcileKey ,@FleetNo ,@RegisterNo ,@RegisterAlpha ,@Customer ,@ServiceType ,@TripTeam ,@EmpCustd2 ,@EmpCustd1 ,@EmpDriver ,@ID_Driver ,@ID_Cusdt2 ,@ID_Cusdt1 ,@PostionDriver ,@PositionCusd2 ,@PositionCusd1 ,@MobileCustd2 ,@MobileCustd1 ,@MobileDriver ,@Weapon ,@WeaponBullets ,@HandheldTerm ,@CustomerKey ,@Mileage) END

ketan borsdiya · Answer

Hi Abdalla, Set your column data type as bigint and add record on that column. you may check below example, CREATE TABLE [dbo].[Table_1]( [Id] [bigint] NULL ) ON [PRIMARY] GO insert into Table_1 select 1234567890123456

Midhun Tp · Answer

Hi, What exactly is the requrement. If you want data to be saved in sql, you can use bigint as datatype in sql. Please tell if you require any other details.

How to save digit contains 14 digits use c# + sql server

Answers (9)