How can I uppercase the first letter of all words in my string?

Question

First, all my cities were returned as UPPERCASE, so I switched them to lowercase. How can I get the first letter as uppercase now? Thanks for any help!

List<string> cities = new List<string>();

foreach (DataRow row in dt.Rows)
{
    cities.Add(row[0].ToString().ToLower());

    **ADDED THIS BUT NOTHING HAPPENED**
     CultureInfo.CurrentCulture.TextInfo.ToTitleCase(row[0] as string);
}

return cities;

Answer 1

Use the TextInfo.ToTitleCase method:

System.Globalization.TextInfo.ToTitleCase();

A bit from the MSDN example, modified to work with OP's code:

// Defines the string with mixed casing.
string myString = row[0] as String;

// Creates a TextInfo based on the "en-US" culture.
TextInfo myTI = new CultureInfo("en-US", false).TextInfo;

// Retrieve a titlecase'd version of the string.
string myCity = myTI.ToTitleCase(myString);

All in one line:

string myCity = new CultureInfo("en-US", false).TextInfo.ToTitleCase(row[0] as String);