Formatting textboxes

Question

How can I format a textbox to SHOW a number like 1.234.567,89 (if the number is big enough !) else just 1,23 og 0,00 if the number is zero.

The textbox is Drag&Dropped from a datasource to the form and then I think bound to the field in the SQL-DB !



 

Answer 1

String.Format("{0:n}", textbox.text). make sure to validate your textbox input is a number

---

carol

Answer 2

You could always handle the format event for the textbox's binding.

http://msdn.microsoft.com/en-us/library/system.windows.forms.binding.format.aspx

---

Orlando Code Camp March 22, 2008 Call for Speakers is now open. http://www.orlandocodecamp.com

Answer 3

Hi PSAKSor,

Based on my standing, you'd like to read a number from DB. And then display it in the textbox.
If I am right, I advise you to take steps as below:
First, get it out from your DB into a string.
Then transfer it into the format you want to display.
At last display it in the textBox.
Wish this could help you.

If I misunderstood you, please feel free to let me know.

Best regards,
Steven Yu

Answer 4

I think Ken Tucker had the solution

Answer 5

To all of you:

There is NO need to do any code here !!!!

You can do the job in the advanced databinding properties of each field !!!!

I like to do it simple and easy - Occams razor !

;-))