The idea is to find the common intersection of a sequence of sequences — or lists or arrays (in red in the image below).
Let’s say we have a bunch of CSV files and we want to find all the common columns between these files.
Continue reading…
The idea is to find the common intersection of a sequence of sequences — or lists or arrays (in red in the image below).
Let’s say we have a bunch of CSV files and we want to find all the common columns between these files.
Continue reading…
It is common to have a hierarchical or tree structure table in a SQL model data.
We would like to display the data as follow:
But when it comes to display the raw data it is hard to identify the hierarchical form.
When displaying a Form as a Dialog/Modal Box sometimes you may need to avoid the Dialog form to close.
Let’s say we have a main form that displays another form as a Modal dialog to finally display some information from that form.
I was working on an application when suddenly I stepped into a method that intrigued me.
public static string NameFormatter(string name)
{
if (!String.IsNullOrEmpty(name))
{
int index = 1;
char[] separator = new[] { ' ', '-', '_', '.', '\'' };
name = name.Substring(0, 1).ToUpper() + name.Substring(1);
while ((index = name.IndexOfAny(separator, index)) > 0)
{
index++;
if (name.Length > index + 1)
{
name = name.Replace(
name.Substring(index, 1),
name.Substring(index, 1).ToUpper());
}
}
}
return name;
}