How to remove trailing zeros in a decimal in C#

I using the code for price column

C# code:

sku.SKUPrice = ValidationHelper.GetDecimal(txtActualPrice.Text, default(decimal));

The value is binding the textbox is "0.000000000"

I need the output is "0.00" only.

The database column datatype is "decimal(18.9)"

If I run the "

alter table COM_SKU alter Column SKUPrice decimal(18,2) not null" query I am getting below error message.

Msg 5074, Level 16, State 1, Line 5

The index 'IX_COM_SKU_SKUPrice' is dependent on column 'SKUPrice'.

Msg 4922, Level 16, State 9, Line 5

ALTER TABLE ALTER COLUMN SKUPrice failed because one or more objects access this column.

ControlToValidate="txtActualPrice" ValidationExpression="((\d+)((\.\d{1,100})?))$">

2 Replies

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

Ashutosh Gupta6y ago
Accepted answer
did you try this to get only two decimal values?
sku.SKUPrice = string.Format("{0:0.##}", txtActualPrice.Text);
+1
Krishnan Suba6y ago
Yes, I am trying to get 2 decimal values only.
0