Database fields to title case ?

Question

Hi I am trying to convert some strings fetched from database into 'Title case' however it is not working for records like 'JAMES Smith'. The output is all the same. Any clue fellows ?

TextInfo companyName = new CultureInfo("en-US", false).TextInfo;

        if(!myRecord.IsDBNull(myRecord.GetOrdinal("GENCLIENTNAME")))
        {
            myCompany.GenClientName =companyName.ToTitleCase(myRecord.GetString(myRecord.GetOrdinal("GENCLIENTNAME")));
        }

Answer 1

This is not supported; see the documentation:

However, this method does not currently provide proper casing to convert a word that is entirely uppercase, such as an acronym

I suggest you create your own method to convert the text in the way that you wish.

Answer 2

ToTitleCase doesn't convert all uppercase words. To fix this convert to lower case first.

companyName.ToTitleCase(myRecord.GetString(myRecord.GetOrdinal("GENCLIENTNAME")).ToLower())