Easy way to Format Strings with Capital Inital letters in VB.NET

I am developing a web application with ASP.NET and Oracle database. In the Oracle, there is a table with a “City” field whose data is in Upper Case. To make the data look good, I format the city name in the Stored Procedure with InitCap function from Oracle as the blow:

SELECT DISTINCT INITCAP(F_city) AS CITY FROM CITY_TAB
ORDER BY CITY ASC;

Now, I need to accomplish the same in my VB.NET code. Of course, based on my previous knowledge I was not aware of  such String Function in VB.net the similar as the INITCAP. And I used to write a function to loop all strings and put the first letter in Capital when we were coding in VB script (ASP).

This week, I found out a easy way to do so in ASP.NET. Now you can use StrConv to get the formatted string. For example:

Dim strCity as String = strConv(strCity, vbstrconv.vbproperCase)

Enjoy programming!

Related posts

• How to set the default value of a data binding DropDownList easily with ASP.NET page (2)