Display Integer without decimal

[pargat.singh]

Hi Everyone:

I have a grid view which is bound to dataset from oracle store
proceduer. I have a number filed but it is showing in decimal like
0.0000 or 24.0000 etc. Can someone please tell me how can show o or 24
only without decimal. I tried dataformatstring prorerty of bound field
but no luck.

Thanks in advance.

Pargat

 

[Jon Paal [MSMD]]

Returns the integer portion of a number.

Int(5.3333) returns 5.

 

[Mark Rae]

I tried dataformatstring prorerty of bound field but no luck.

You probably forgot to include:

HtmlEncode="false"

in the bound column tag

 

[pargat.singh]

You probably forgot to include:

HtmlEncode="false"

in the bound column tag

Thanks. I am getting an error when i set DataFormatString="{0}"
HtmlEncode="false".

 

[pargat.singh]

Returns the integer portion of a number.

Int(5.3333) returns 5.








- Show quoted text -

Thanks. I have replace the SP with to_number.

 

[Mark Rae]

Thanks. I am getting an error when i set DataFormatString="{0}"
HtmlEncode="false".

DataFormatString="{0:0}" HtmlEncode="false"