Loading

Convert negative value to positive value in a row of Gridvie

shahnid k

9y2.7k.NET

Hi,

Am calling some datas from database and binding it in gridview. I need one of my row not to display its negative values. I have tried many ways but dint see any proper result to overcome.

I have tried something like this,

string formattedValue = string.Format("{0:$#.##;$-#.##}", sales);

sales is the row which are giving both negative and positive values. I need to display all the values in positive values only. Dont want to update the database table to positive.

1 Reply

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

ali tuncer9y ago
You can consider absolute value functions, they return positive value
in sql server you can use ABS function
https://msdn.microsoft.com/en-us/library/ms189800.aspx

in c#, you can use Math.Abs(value)

https://msdn.microsoft.com/en-us/library/system.math.abs(v=vs.110).aspx
0