How to Convert Numeric to data type varchar

Abdalla Elawad

10y1.1kVisual Basic .NET

I have field in sql tbl as numeric data type (numeric(18,0) but in c# code when i save data

display this message "

Arithmetic overflow error converting numeric to data type varchar.The statement has been terminated."

As follow code c#

SqlCommand cmd = new SqlCommand("CashPlan_Insert", Conn);

cmd.Parameters.Add("@CarNo", SqlDbType.VarChar).Value = (DropDownList1.SelectedValue);

cmd.CommandType = CommandType.StoredProcedure;

Conn.Open();

cmd.ExecuteNonQuery();

Conn.Close();

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tapan Patel10y ago
First thing to do is to understand mapping between sql data types and .net datatypes types. Take a look here.

http://www.c-sharpcorner.com/Resources/3093/sql-data-types-mapping-to-net-data-types.aspx
Midhun Tp10y ago
Hi,
Use bigint.
Abdalla Elawad10y ago
what is problem???
Arithmetic overflow error converting numeric to data type Varchar . the statement has been terminated.
this field in sql server
CarNo Numeric(18,2)
C# as below :
cmd.Parameters.Add("@CarNo", SqlDbType.Decimal).Value = Convert.ToDecimal((DropDownList1.SelectedValue));
cmd.Parameters.Add("@TeamNo", SqlDbType.Int).Value =(DropDownList9.SelectedValue);
cmd.Parameters.Add("@Customers", SqlDbType.NVarChar).Value = TextBox5.Text.Trim();
cmd.Parameters.Add("@DriverName", SqlDbType.NVarChar).Value = (DropDownList6.SelectedValue);
cmd.Parameters.Add("@First_Supervisor", SqlDbType.NVarChar).Value = (DropDownList7.SelectedValue);
cmd.Parameters.Add("@Second_Supervisor", SqlDbType.NVarChar).Value = (DropDownList8.SelectedValue);
cmd.Parameters.Add("@ServiceType", SqlDbType.NVarChar).Value = (DropDownList2.SelectedValue);
cmd.Parameters.Add("@BankName", SqlDbType.NVarChar).Value = (DropDownList3.SelectedValue);
Abdalla Elawad10y ago
Hi guys
Int is small than 14 digits
Bikesh Srivastava10y ago
SqlCommand cmd = new SqlCommand("CashPlan_Insert", Conn);
cmd.Parameters.Add("@CarNo", SqlDbType.int).Value = (DropDownList1.SelectedValue);
cmd.CommandType = CommandType.StoredProcedure;
Conn.Open();
cmd.ExecuteNonQuery();
Conn.Close();
Abdalla Elawad10y ago
i want to save no. contain to 14 digits what is good method using sql server and c# ?
Abdalla Elawad10y ago
try but not solve
Midhun Tp10y ago
Hi,
Try decimal instead of varchar in below code -
cmd.Parameters.Add("@CarNo", SqlDbType.Decimal).Value = Convert.ToDecimal((DropDownList1.SelectedValue));
Abdalla Elawad10y ago
how to convert to numeric here
Create proc Car_Insert
(@CarNo numeric(18, 0),
@DriverName nvarchar(50),
@First_Supervisor nvarchar(50),
@Second_Supervisor nvarchar(50),
@ServiceType nvarchar(50),
@BankName nvarchar(50),
@PlanStartDate date,
@Recycle_Date date,
@TeamNo Bigint,
@Customers Nvarchar(50),
@Region NVARCHAR(50),
@City NVARCHAR(50),
@OperationDate date,
@First_Phone Nvarchar(50),
@Second_Phone Nvarchar(50),
@DriverPhone Nvarchar(50))

AS

BEGIN

INSERT INTO OperationPlan
(CarNo
,DriverName
,First_Supervisor
,Second_Supervisor
,ServiceType
,BankName
,PlanStartDate,First_Phone,Second_Phone,DriverPhone
,Recycle_Date,TeamNo,Customers,City,Region,OperationDate)
VALUES
(@CarNo
,@DriverName
,@First_Supervisor
,@Second_Supervisor
,@ServiceType
,@BankName
,@PlanStartDate,@First_Phone,@Second_Phone,@DriverPhone,
@Recycle_Date,@TeamNo,@Customers,@City,@Region,@OperationDate)

INSERT INTO MplanTbl

(CarNo
,DriverName
,First_Supervisor
,Second_Supervisor
,ServiceType
,BankName
,PlanStartDate
,Recycle_Date,TeamNo,Customers,City,Region,OperationDate)
VALUES
(@CarNo
,@DriverName
,@First_Supervisor
,@Second_Supervisor
,@ServiceType
,@BankName
,@PlanStartDate,
@Recycle_Date,@TeamNo,@Customers,@City,@Region,@OperationDate)

END
Abdalla Elawad10y ago
hi Midhun T P
pls write convert here
cmd.Parameters.Add("@CarNo", SqlDbType.VarChar).Value = (DropDownList1.SelectedValue);
Midhun Tp10y ago
Hi,
In sql you can convert to varchar like below
Select convert(varchar(20),colname) from tablename
Vinay Singh10y ago
Use Convert.ToString(---);