Is there a way to capitalize first letters of each word in a parameter string?

Question

Is there a way to capitalize first letters of each word in a parameter string?

Donald Symmons 3,066

I tried to set letters case to store textbox values in the database table, and store the beginning of each word in capital letter, but so far, I have been able to set only capital letters into the database, with this lines.

These are two different parameters from two pages. It accepts only “ToUpper”. I know that in trying to store words and make the first letters of word to be in capital is by calling “capitalize” in stylesheet for client-side.

How can I do this in the server side?

The below code only set all the words in capital letters. I tried to replace ".ToUpper()", but capitalize did not work

cmd.Parameters.AddWithValue("@Name", Textbox1.Text.ToUpper());

objCMD.Parameters.Add("@Name", SqlDbType.NVarChar, 100).Value = Textbox1.Text.ToUpper().Trim();

Michael Taylor 60,326 Reputation points

2023-03-14T14:27:31.4766667+00:00
Do you want title cased (every word is capitalized)? If so then there is a method for that but it requires a little bit of typing. Personally I use an extension method wrapper for this.

public static string ToTitleCase ( this string source ) => ToTitleCase(source, null); public static string ToTitleCase ( this string source, CultureInfo culture ) { culture = culture ?? CultureInfo.CurrentUICulture; return culture.TextInfo.ToTitleCase(source.ToLower()); } //Usage Textbox1.Text.ToTitleCase();

But this would capitalize on word boundary. If you want only the first word then you'd lowercase the string and then uppercase the first letter.

public static string UppercaseFirstWord ( this string value ) { if (String.IsNullOrEmpty(value)) return ""; value = value.ToLower(); return Char.ToUpper(value[0]) + value.Substring(1); }

Of course this isn't efficient. If you're using a newer version of C# then using a span to break up the string, capitalize and put it back might be better.

Accepted answer

1 additional answer

Your answer

Michael Taylor 60,326 Reputation points

2023-03-14T14:27:31.4766667+00:00

Do you want title cased (every word is capitalized)? If so then there is a method for that but it requires a little bit of typing. Personally I use an extension method wrapper for this.

public static string ToTitleCase ( this string source ) => ToTitleCase(source, null); public static string ToTitleCase ( this string source, CultureInfo culture ) { culture = culture ?? CultureInfo.CurrentUICulture; return culture.TextInfo.ToTitleCase(source.ToLower()); } //Usage Textbox1.Text.ToTitleCase();

But this would capitalize on word boundary. If you want only the first word then you'd lowercase the string and then uppercase the first letter.

public static string UppercaseFirstWord ( this string value ) { if (String.IsNullOrEmpty(value)) return ""; value = value.ToLower(); return Char.ToUpper(value[0]) + value.Substring(1); }

Of course this isn't efficient. If you're using a newer version of C# then using a span to break up the string, capitalize and put it back might be better.

Answer 1

Lan Huang-MSFT 30,191 Microsoft External Staff

Hi @Donald Symmons,

You can do it with regular expressions.

For example:

string Eventtxt = eventtxt.Text.ToString();

Eventtxt = Regex.Replace(Eventtxt, @"\b([a-z])", m => m.Value.ToUpper());

cmd.Parameters.AddWithValue("@ticketname", Eventtxt);

Best regards,
Lan Huang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Donald Symmons 3,066 Reputation points

2023-03-15T08:49:31.85+00:00

It seems I cannot accept an answer posted by me on this platform

Answer 2

Donald Symmons 3,066

I finally got help.

Using the TextInfo class ToTitleCase method, like this:

This is my namespace

using System.Globalization;

Then added this to my cmd parameter

objCMD.Parameters.Add("@Name", SqlDbType.NVarChar, 100).Value = CultureInfo.InvariantCulture.TextInfo.ToTitleCase(txtname.Text.Trim());

....and it works.

Share via

Is there a way to capitalize first letters of each word in a parameter string?

1 additional answer

Your answer