I am facing two problems, pertaining to formatting the textboxes in my VB.NET project with SQL Server.

First, I have a TextBox bound to 'Smallmoney' column, which displays the number upto 4 digits after decimal. I want to make it display just to 2 places after decimal.

Second, another TextBox bound to 'Smalldatetime' column, does not let input date in "dd-mm-yy" format. I want to get it done programatically, without manual modifications in the "Regional Options".

I think, the second problem can be solved using the Culture object, but I don't know how to do it.

Is there anybody who can help a novice, please!

These can both be solved in SQL Server:

Money Field:
convert(varchar,[fieldName],0) as [fieldName] (returns 0.00 format)

Date Field:
Convert(varchar(10), [fieldName], 105) as [fieldName] (returns dd-mm-yy format)


"The one language all programmers understand is profanity."