Can't store big amount in Decimal(18,2) in DB.

Question

Dear Friends, I want to store big Amount (52,890.56) with comma in decimal datatype of SQL Server database, but can't .......... have any suggestion?

Rafnas T P · Answer

hi, in numeric you can not have coma, either you can save it in nvarchar datatype or save it in numeric(18,2) without coma, and from front end you can convert this into currency format and show it

Rafnas T P · Answer

use numeric(18,2) data type. but it wont save coma you have to remove coma if you wanted to save with coma then use nvarchar data type

Rafnas T P · Answer

add .ToString() at end of value as below string num = dataGridView1.Rows[i].Cells[10].Value .ToString() ; string num1 = num.Replace( "," , "" ); cmd.Parameters.Add( "@purCost" , num1);

Zeb Muhammad · Answer

please check this code , i gor error. string num = dataGridView1.Rows[i].Cells[10].Value; string num1 = num.Replace( "," , "" ); cmd.Parameters.Add( "@purCost" , num1);

Rafnas T P · Answer

to remove coma from string in c# you can use yourstringName .Replace(",","");

Zeb Muhammad · Answer

thanks dear Rafnas ............. But i am using as a currency porpose. can i store currency in Number(18,2) ? and please tell me string.Remove function how to use to remove commas in values?

Can't store big amount in Decimal(18,2) in DB.

Answers (6)