Code Resource

Simple Regex example

2011-03-21T15:32:00.001+02:00

So I had to do a quick search and replace on an xml file. The goal was to replace a pattern with another. Example: Replace /2/215.html with &id2=2&id3=215 So here is a function to look for this pattern and replace with this other pattern: static string ReplacePattern(Match m) { var x = m.ToString(); Console.WriteLine("Match is : " + x); var c = x.Count(f => f == '/'); // Or

Refactor routine to use LINQ

2011-03-17T15:23:00.001+02:00

Here is a function that does a bitwise XOR on a string public string doIt(string input) { var aChars = input.ToCharArray(); var aCharsRes = new char[aChars.Length]; for (int i = 0; i < aChars.Length; i++) { aCharsRes[i] = (char)(aChars[i] ^ 1); } return new string(aCharsRes); } Here is the re-factored one liner: public string doItOneLiner(string input)

Log4net

2010-07-09T12:43:00.002+03:00

This logging infrastructure can sometimes be frustrating to setup, especially with the RollingFileAppender who wouldn't create and write to that damn log file specified in the app.config So, one thing that helps, in the app.config of the app, put the log4net in debug like this: This way, errors in log4net will be sent to the Output (Ctrl+W, O) -> Show output from: Debug.

The Following Module was built either with optimizations enabled or without debug information

2010-05-31T14:00:00.000+03:00

So I am trying to debug this Win service (built with VS2008) that references a module (DLL containing Managed C++ that was built with VS2010) and I keep getting a message box (see title) when attaching to the service process with VS2010. Plowing through the web, found this solution that oddly enough worked: I unchecked the "Enable just my code(managed only)" in (VS2010) Debug -> Options ->

Static constructor of a derived class is called before the static constructor of the base class

2010-05-08T13:24:00.001+03:00

However, for non-static constructors, the order is the other way around. See examples below: Example 1. Static constructors public class Test { static Test() { Console.WriteLine("test constructor"); } } public class TestExtended : Test { static TestExtended() {

PATH environment variable

2010-01-22T11:36:00.001+02:00

Command prompt: set PATH=%PATH%;c:\newdir Appends a new path to the PATH variable. However this is scoped to the running CMD window. To make it a permanent change there is a utility called setx.exe (details here)

Microsoft Log Parser

2010-01-20T15:40:00.001+02:00

This is a tool that provides query access to text-based data such as log files, XML/CVS files, as well as Event Log, the Registry, the file system and Active Directory. Download here. Here is a sample query that returns the top bandwidth by URL SELECT top 50 DISTINCT SUBSTR(TO_LOWERCASE(cs-uri-stem), 0, 55) AS Url, Count(*) AS Hits, AVG(sc-bytes) AS AvgBytes, SUM(sc-bytes) as ServedBytes

Net command in CMD

2010-01-20T13:28:00.001+02:00

Useful when you want to find out where the SHARES are located on a computer: C:\net share Returns a list of Share Names <--> Resource (local paths) Notice that shares ending with $ are admin shares

SQL Server Email

2010-01-18T15:50:00.001+02:00

EXEC msdb.dbo.sp_send_dbmail @recipients= @Recipients, @body= @temp, @subject = 'Test', @profile_name = 'DBMailProfile' See this Example

C# BubbleSort routine

2010-01-15T10:52:00.000+02:00

So I wrote the first version (not optimized) in 5 minutes. For the optimization it took another 5 minutes. This algorithm is O(n2) and as Knuth puts it, "...bubble sort seems to have nothing to recommend it, except a catchy name".///

/// Optimized version of BubbleSort that parses one less item each iteration///

public static class BubbleSort{ public static int[] Sort(int[]

Assembly Binding Log Viewer FUSLOGVW.exe

2010-01-13T11:11:00.000+02:00

The Assembly Binding Log Viewer displays details for failed assembly binds.This is useful when for instance your ASP.NET app craps out on you because it can't find an assembly or it finds one with a different verision.The viewer is available with the Windows SDK.MSDN infoASSEMBLY PROBING, FUSION AND FUSLOGVW IN 5 MINUTES

Online IDE from coderun.com

2009-12-20T06:42:00.000+02:00

They have other tools too (worth checking them out)Here is the online ide.

Linkuri utile Normal Form

2009-07-10T06:44:00.000+03:00

SQL Server 2005 Virtual LabsSimple QueryTraining SpotSQL BookDatabase Normalization

T-SQL Split function of comma delimited input param

2009-07-09T06:22:00.000+03:00

Check this Split function found on Kris' BlogBasically, pass in the stored proc a comma delimited list and it will return a temp table holding the id's

T-SQL Full Outer Join Example

2009-07-08T11:56:00.000+03:00

DECLARE @Table1 TABLE ( id INT, name NVARCHAR(20) )DECLARE @Table2 TABLE ( id INT, name NVARCHAR(20) )INSERT INTO @Table1 VALUES (1, 'A')INSERT INTO @Table1 VALUES (2, 'B')INSERT INTO @Table1 VALUES (3, 'C')INSERT INTO @Table2 VALUES (2, 'B')INSERT INTO @Table2 VALUES (3, 'C')INSERT INTO @Table2 VALUES (4, 'D')SELECT a.id, a.name FROM @Table1 a LEFT OUTER JOIN @Table2 b ON a.name = b.nameWHERE

Lambda Example 1

2009-06-25T16:42:00.000+03:00

public class TestLambda{ delegate int AddOneDgt(int x); ///

/// Details at: http://blogs.msdn.com/ericwhite/pages/Lambda-Expressions.aspx ///

public static void DoWork() { int a = 3; // Pointer to a static function AddOneDgt addOneFctPtr = new AddOneDgt(A.AddOne); // Pointer to an instance function AddOneDgt addOneFctPtr1 =

How to avoid multiple instances of your .Net application

2009-06-19T16:10:00.000+03:00

A very good method is using a mutex:Global mutex

Auto-implemented properties in C# 3.0

2009-06-19T07:08:00.000+03:00

They are NOT the equivalent of a public field. (WHY?)private string Name { get; set }You can have a private setter so the prop becomes immutable (ie unchangable after the object is instantiated)private string Name { get; private set; }

C# yield example

2009-06-13T11:32:00.000+03:00

private void Form1_Load(object sender, EventArgs e){ int i = 0; string[] arr = new string[] { "bob1", "can", "bob2", "boB3", "everyday", "Bob4" }; foreach (string str in FindBobs(arr)) { Console.WriteLine(++i + ". " + str); }}static IEnumerable FindBobs(string[] arr){ foreach (string str in arr) { if (str.Equals("bob3",

C# short-circuit logical operators

2009-06-13T10:19:00.000+03:00

"&&" and "||" operators use short-circuit. Thus,if (false && expr1){ // Won't evaluate expr1}Orif (true || expr2){ // Won't evaluate expr2}If you want both sides to be evaluated use the "&" and "|" operators

Links

2009-06-12T07:20:00.000+03:00

Hidden Features of C#Yield Explained

Howto avoid having to use ToUpper() in string comparisons

2009-06-12T06:53:00.000+03:00

Instead of using: if (myString.ToUpper() == theirString.ToUpper) { ... }Use this: if( myString.Equals( theirString, StringComparison.OrdinalIgnoreCase ) { ... }Thanks to: Ralph

Howto get the TopMost Form in a WinForm App using Win32 API

2009-06-11T16:03:00.000+03:00

public class Win32{ public const int GW_HWNDNEXT = 2; // The next window is below the specified window public const int GW_HWNDPREV = 3; // The previous window is above public const int GW_HWNDFIRST = 0; // TopMost Windows private const int SW_HIDE = 0; [DllImport("user32", CharSet = CharSet.Auto, SetLastError = true, ExactSpelling = true)] public static extern IntPtr GetWindow(

How to avoid situations where Visual Studio Designer crashes because of code running in Design Mode

2009-06-10T17:00:00.001+03:00

The VS Designer will try to create your UI and will call the control constructor. If you have code that connects to a DB for instance in the constructor, the Designer will crash. To avoid that, a simple check [ if (!DesignMode) { ...get DB connection...} ] using the following property will do the trick: ///

/// Verificam daca

C# Events Tutorial

2009-06-06T17:41:00.000+03:00

In the class that throws the events:First declare a delegate: private delegate void AudioIsPlayingHandler(MediaElement elem);Then declare an event:private event AudioIsPlaingHandler OnAudioIsPlaying;Somewhere, the class throws the event:if (OnAudioIsPlaying != null) OnAudioIsPlaying(elem); // Raise the event and pass some dataNow, in a class that has an instance of the previous class:First,

Draw Rectangle Over UltraGrid

2009-06-05T16:40:00.000+03:00

This is some basic stuff about how to draw lines in C#:Drawing lines in C#This tries to help with the flickering problem. Didn't get it to work over an UltraGrid:Don't Flicker! Double Buffer!This works on a Windows Form but couldn't get it to work over a control containing an UltraGrid, and it uses Win32 API to draw:C# Rubber RectangleThis works fine in a Windows Form but gives artifacts over the