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()) 
             : "";

Thursday, 1 November 2018

Redux - Sample Store

import { createStore } from 'redux'

const
store = createStore((state = {count: 0}, action) => {
switch (action.type)
{
case 'SOME_ACTION':
return {
count: state.count + action.value
};
default:
return state;
}
});


store
.subscribe (() => console.log(store.getState())); // Watch for state changes
store
.dispatch({type: 'SOME_ACTION', value: 5}); // Dispatch action by value

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...