Friday, 2 November 2018

C# Change Dataset Data to Proper Case/Title Case

ds.Tables[0].Select().ToList<DataRow>().ForEach(r => r["name"= ProperCase (r["name"].ToString()));
Func<string, object> ProperCase = obj =>
    !string.IsNullOrEmpty(obj.ToString()) ? 
             System.Threading.Thread.CurrentThread
             .CurrentCulture
             .TextInfo.ToTitleCase(obj.ToString()
             .Trim()
             .ToLower()) 
             : "";

No comments:

SQL: Generate a range of numbers

SELECT ones.n + 10*tens.n + 100*hundreds.n + 1000*thousands.n FROM       (VALUES(0),(1),(2),(3),(4),(5),(6),(7),(8),(9)) ones(n),      (VALU...