How to convert decimal ?

[King Shez]

HI guys i am facing problem, in my application i am using data type decimal, when i get the value from data base and show in text box if the value is e.g. 99 it shows 99.00000 as i have specified 5 after precision in sql server, how can i convert the 99.00000 to 99 can any one let me know about it thankx in advance.

[Herman T Instance]

Convert.ToInt32(DecimalValue) or lblValue.Text = decimalValue.ToString("#,#0"); or txtValueBox.Text = decimalValue.ToString("#,#0");

[King Shez]

thansk for your answer but in case if there is 99.45 in database it converts it back to 99 in this case i want to show 99.4, kindly reply ASAP.

[King Shez]

thanks for your answer but in case if there is 99.45 in database it converts it back to 99 in this case i want to show 99.45, kindly reply ASAP.

[Herman T Instance]

"#,#0.##"

[King Shez]

thanks i have did it, thanks for ur help.