convertion

chennakrishnareddy bijivemula

if database have one table in this table 'ADVANCE' is one column and datatype is MONEY .if you enter in front end 1000 it will store like that 1000.00

then after i want retrive the ADVANCE from sql data base to print in one text box it is print llike that is 1000.0000 but

i want to print only two zeros after decimal points like 1000.00 plz any one tell me

6 Replies

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

Ranjit Powar10y ago
Accepted answer
Try this

textBox1.Text=string.Format("{0:F2}", Convert.toDouble(databaseValue));

If it helps you select it as correct answer.
Ranjit Powar10y ago
https://msdn.microsoft.com/en-us/library/system.string.format(v=vs.110).aspx
chennakrishnareddy bijivemula10y ago
thank u Ranjit power .

if you have any clear description about string.format send to me link

Vipan Sharma10y ago

Try this

First:

String.Format("{0:0.00}", 1000.0000); 


Second:

float value = 1000.0000;

value = System.Math.round(value,2);



It's working for me. Hope it will help you .

chennakrishnareddy bijivemula10y ago
still it is print 1000.000 only
Ranjit Powar10y ago
Try this

textBox1.Text=string.Format("{0:F2}", databaseValue);

If it helps you select it as correct answer.