asked on

Formatting a negative number in datagrid in asp.net

Is it possible to format a negative integer in a column in datagrid to show (1) instead of -1.

Ex:
Column Column(This is what I want)
-1 (1)
-20 (20)

Thanks in advance.

ASKER CERTIFIED SOLUTION

tusharashah

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

tusharashah

You just need to replace 2 here with your Column Number

e.Item.Cells[2].Text;

SOLUTION

jnhorst

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jnhorst

You can also do this:

e.Item.Cells(x).ForeColor = Color.Red

to show the negative values in red.

John

raterus

There is a more elegant way to do this, than the way tusharashah suggests. I can't say it's any easier though :-)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemglobalizationnumberformatinfoclassnumbernegativepatterntopic.asp

wilkersons

ASKER

Thanks a lot everyone for ur suggestions.
I tried
Case ListItemType.Item Or ListItemType.AlternatingItem
Dim strNumber As String
strNumber = e.Item.Cells(6).Text
If (strNumber.IndexOf("-") > -1) Then

strNumber = strNumber.Replace("-", "")
strNumber = "(" & strNumber & ")"
e.Item.Cells(6).Text = strNumber
End If

AND I ALSO TRIED
Case ListItemType.Item Or ListItemType.AlternatingItem
e.Item.Cells(6).Text = System.Int32.Parse(e.Item.Cells(6).Text).ToString("#,##;(#,##)")

BOTH OF THEM WORKED.

Thanks a lot

tusharashah

Nice to have you going!