A good majority of my work is for mobile applications using the Compact Framework. Something really annoying I came across today was that if I used a variable for the pattern in my Regex then the IsMatch did not work, but if I used a constant then it did. So, for example, if I used: string val = "YELLOW"; string pattern = "(YELLOW)$"; The following statement does not give the correct result (true): bool flg1 = Regex.IsMatch("YELLOW", pattern); But the following does: bool flg2 = Regex.IsMatch(val, ......
I found something really cool with SQL yesterday that I did not think it would do; give me the distinct count of a field.
For example, to calculate the number of payment terms being used for our customers in the UK I can use the following statement:
SELECT COUNT(DISTINCT [Payment Terms Code])
WHERE [Country_Region Code]='GB'
Create a project template for your Windows Service applications to save loads of time.
Make developing, testing and debugging your Windows Service application easy.