Articles by Sander Rossel (Articles: 7, Technical Blogs: 29, Tip/Tricks: 6)

Articles: 7, Technical Blogs: 29, Tip/Tricks: 6

Articles
Technical Blogs
Tips and Tricks
Reference Articles

Average article rating: 4.89

Client side scripting

Beginners

Arrgh.js - Bringing LINQ to JavaScript

Posted: 28 Nov 2016 Updated: 14 May 2017 Views: 35,630 Rating: 4.99/5 Votes: 67 Popularity: 9.12

Licence: The Code Project Open License (CPOL) Bookmarked: 53 Downloaded: 141

Creating a lightweight JavaScript library that brings proper .NET-like collections and LINQ to JavaScript.

Database

SQL Server

Querying SQL Server 2012: Part I

Posted: 13 Dec 2013 Updated: 3 Jan 2014 Views: 210,920 Rating: 4.85/5 Votes: 103 Popularity: 9.75

Licence: The Code Project Open License (CPOL) Bookmarked: 155 Downloaded: 0

The first of two, everything you need to create the most amazing queries!

Querying SQL Server 2012: Part II

Posted: 3 Jan 2014 Updated: 24 Jan 2014 Views: 78,490 Rating: 4.90/5 Votes: 47 Popularity: 8.20

Licence: The Code Project Open License (CPOL) Bookmarked: 93 Downloaded: 0

The second of two; everything you need to create the most amazing queries!

.NET Framework

General

Using Try... Catch..., Finally!

Posted: 5 Feb 2011 Updated: 5 Feb 2011 Views: 254,650 Rating: 4.80/5 Votes: 45 Popularity: 7.94

Licence: The Code Project Open License (CPOL) Bookmarked: 100 Downloaded: 2,195

This article describes multiple implementations of proper Try... Catch... Finally and Using... End Using blocks in your code.

A Look under the hood of the .NET Framework

Posted: 8 Jul 2012 Updated: 11 Feb 2013 Views: 104,580 Rating: 4.94/5 Votes: 76 Popularity: 9.30

Licence: The Code Project Open License (CPOL) Bookmarked: 167 Downloaded: 1,348

Journey to the center of the .NET Framework with a chance of IL along the way!

Collections

General

Having fun with custom collections!

Posted: 11 Oct 2011 Updated: 14 Oct 2011 Views: 126,290 Rating: 4.91/5 Votes: 68 Popularity: 9.00

Licence: The Code Project Open License (CPOL) Bookmarked: 118 Downloaded: 2,584

Creating custom collections from IEnumerable(T) to IDictionary(T) and everything in between!

Design and Architecture

Design Patterns

What not to do: Anti-Patterns and the Solutions

Posted: 26 Apr 2011 Updated: 30 Apr 2011 Views: 75,580 Rating: 4.83/5 Votes: 57 Popularity: 8.47

Licence: The Code Project Open License (CPOL) Bookmarked: 112 Downloaded: 1,001

An introduction to knowing what NOT to do.

Average blogs rating: 4.83

Grid & Data Controls

DataSets, DataGrids etc

Using DataSets to work with (relational) in-memory data [Technical Blog]

Posted: 6 Nov 2014 Updated: 16 Mar 2015 Views: 25,040 Rating: 4.44/5 Votes: 6 Popularity: 3.48

Licence: The Code Project Open License (CPOL) Bookmarked: 20 Downloaded: 0

Need some flexible in-memory data cache? DataSets might be what you're looking for...

Ajax

General

Web development #7: Dynamic page updates with AJAX [Technical Blog]

Posted: 8 Mar 2015 Updated: 16 Mar 2015 Views: 17,590 Rating: 4.29/5 Votes: 6 Popularity: 3.34

Licence: The Code Project Open License (CPOL) Bookmarked: 19 Downloaded: 0

The seventh in a series on web development.

Applications & Tools

General

Web development #8: Where to go from here [Technical Blog]

Posted: 14 Mar 2015 Updated: 16 Mar 2015 Views: 12,860 Rating: 4.73/5 Votes: 6 Popularity: 3.72

Licence: The Code Project Open License (CPOL) Bookmarked: 13 Downloaded: 0

The last in a series on web development.

Client side scripting

Beginners

Web development #6: Getting interactive with JavaScript [Technical Blog]

Posted: 2 Mar 2015 Updated: 16 Mar 2015 Views: 20,940 Rating: 5.00/5 Votes: 5 Popularity: 3.49

Licence: The Code Project Open License (CPOL) Bookmarked: 14 Downloaded: 0

The sixth in a series on web development.

JavaScript

Knockout.js for data binding in HTML and JavaScript [Technical Blog]

Posted: 29 Mar 2015 Updated: 29 Mar 2015 Views: 27,900 Rating: 5.00/5 Votes: 4 Popularity: 3.01

Licence: The Code Project Open License (CPOL) Bookmarked: 11 Downloaded: 0

Knock, knock. Who's there? Knockout. Knockout who? Knockout.js!

Prototype in JavaScript [Technical Blog]

Posted: 18 Oct 2015 Updated: 19 Oct 2015 Views: 9,280 Rating: 4.63/5 Votes: 6 Popularity: 3.72

Licence: The Code Project Open License (CPOL) Bookmarked: 9 Downloaded: 0

Always wondered about that prototype thing in JavaScript? It's not as hard as you'd think...

Apply, Call and Bind on JavaScript functions [Technical Blog]

Posted: 25 Oct 2015 Updated: 27 Oct 2015 Views: 5,260 Rating: 4.60/5 Votes: 4 Popularity: 2.74

Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0

Did you know about Apply and Call in JavaScript? Or Bind? They might come in handy!

HTML / CSS

CSS

Web development #3: Styling our page with CSS 3 [Technical Blog]

Posted: 18 Nov 2014 Updated: 16 Mar 2015 Views: 25,970 Rating: 4.72/5 Votes: 9 Popularity: 4.48

Licence: The Code Project Open License (CPOL) Bookmarked: 22 Downloaded: 0

The third in a series on web development.

General

Web development #1: Internet and the World Wide Web [Technical Blog]

Posted: 10 Nov 2014 Updated: 16 Mar 2015 Views: 35,650 Rating: 4.76/5 Votes: 22 Popularity: 6.37

Licence: The Code Project Open License (CPOL) Bookmarked: 40 Downloaded: 0

The first in a series on web development.

Twitter Bootstrap for Responsive, Mobile First Web Apps [Technical Blog]

Posted: 23 Mar 2015 Updated: 24 Mar 2015 Views: 21,070 Rating: 5.00/5 Votes: 6 Popularity: 3.89

Licence: The Code Project Open License (CPOL) Bookmarked: 22 Downloaded: 0

Using Twitter Bootstrap to create pages that'll look good on all devices

Polymer for reusable web components [Technical Blog]

Posted: 17 May 2015 Updated: 18 May 2015 Views: 15,730 Rating: 4.90/5 Votes: 9 Popularity: 4.67

Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0

Using Polymer to create custom HTML elements for reusability and fun.

HTML

Web development #5: User input with HTML Forms [Technical Blog]

Posted: 26 Feb 2015 Updated: 16 Mar 2015 Views: 17,750 Rating: 4.64/5 Votes: 7 Popularity: 4.05

Licence: The Code Project Open License (CPOL) Bookmarked: 10 Downloaded: 0

The fifth in a series on web development.

Web development #2: Our first website using HTML [Technical Blog]

Posted: 11 Nov 2014 Updated: 16 Mar 2015 Views: 25,630 Rating: 4.74/5 Votes: 11 Popularity: 4.91

Licence: The Code Project Open License (CPOL) Bookmarked: 18 Downloaded: 0

The second in a series on web development.

Node.js

General

MEAN web development #4: All aboard the Node.js Express! [Technical Blog]

Posted: 24 May 2015 Updated: 26 May 2015 Views: 11,740 Rating: 4.80/5 Votes: 8 Popularity: 4.52

Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0

The fourth in a series on MEAN web development.

MEAN web development #1: MEAN, the what and why [Technical Blog]

Posted: 20 Apr 2015 Updated: 27 May 2015 Views: 22,290 Rating: 4.89/5 Votes: 15 Popularity: 5.82

Licence: The Code Project Open License (CPOL) Bookmarked: 29 Downloaded: 0

The first in a series on MEAN web development.

MEAN web development #2: Node.js in the back [Technical Blog]

Posted: 28 Apr 2015 Updated: 27 May 2015 Views: 15,470 Rating: 5.00/5 Votes: 4 Popularity: 3.01

Licence: The Code Project Open License (CPOL) Bookmarked: 12 Downloaded: 0

The second in a series on MEAN web development.

MEAN web development #3: More Node.js [Technical Blog]

Posted: 10 May 2015 Updated: 27 May 2015 Views: 8,180 Rating: 4.71/5 Votes: 5 Popularity: 3.30

Licence: The Code Project Open License (CPOL) Bookmarked: 10 Downloaded: 0

The third in a series on MEAN web development.

MEAN web development #5: Jade and Express [Technical Blog]

Posted: 15 Jun 2015 Updated: 16 Jun 2015 Views: 12,220 Rating: 5.00/5 Votes: 3 Popularity: 2.39

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

The fifth in a series on MEAN web development.

MEAN web development #7: MongoDB and Mongoose [Technical Blog]

Posted: 6 Sep 2015 Updated: 7 Sep 2015 Views: 9,940 Rating: 5.00/5 Votes: 4 Popularity: 3.01

Licence: The Code Project Open License (CPOL) Bookmarked: 12 Downloaded: 0

The seventh in a series on MEAN web development.

MEAN web development #6: AngularJS in the front [Technical Blog]

Posted: 30 Aug 2015 Updated: 13 Sep 2015 Views: 11,360 Rating: 4.88/5 Votes: 7 Popularity: 4.09

Licence: The Code Project Open License (CPOL) Bookmarked: 10 Downloaded: 0

The sixth in a series on MEAN web development.

MEAN web development #8: Sockets will rock your socks! [Technical Blog]

Posted: 13 Sep 2015 Updated: 14 Sep 2015 Views: 9,300 Rating: 4.95/5 Votes: 5 Popularity: 3.44

Licence: The Code Project Open License (CPOL) Bookmarked: 16 Downloaded: 0

The eighth in a series on MEAN web development.

MEAN web development #9: Some last remarks [Technical Blog]

Posted: 20 Sep 2015 Updated: 21 Sep 2015 Views: 7,460 Rating: 5.00/5 Votes: 3 Popularity: 2.39

Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0

The last in a series on MEAN web development.

PHP

General

Web development #4: PHP in the back [Technical Blog]

Posted: 14 Feb 2015 Updated: 16 Mar 2015 Views: 17,800 Rating: 5.00/5 Votes: 4 Popularity: 3.01

Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0

The (long awaited) fourth in a series on web development.

Database

SQL Server

Using C# to Connect to and Query from a SQL Database [Technical Blog]

Posted: 3 Nov 2014 Updated: 16 Mar 2015 Views: 288,020 Rating: 4.70/5 Votes: 38 Popularity: 7.42

Licence: The Code Project Open License (CPOL) Bookmarked: 61 Downloaded: 0

Using C# to get data in- and out of your (relational) database

NoSQL

MongoDB

A First Look at NoSQL and MongoDB in Particular [Technical Blog]

Posted: 4 Nov 2014 Updated: 16 Mar 2015 Views: 24,830 Rating: 4.91/5 Votes: 19 Popularity: 6.28

Licence: The Code Project Open License (CPOL) Bookmarked: 35 Downloaded: 0

Getting your feet wet in NoSQL with MongoDB!

Collections

General

Maths in IT #1: Basic set theory [Technical Blog]

Posted: 3 Nov 2015 Updated: 4 Nov 2015 Views: 18,710 Rating: 4.95/5 Votes: 25 Popularity: 6.92

Licence: The Code Project Open License (CPOL) Bookmarked: 19 Downloaded: 0

A simple introduction to set theory.

Maths in IT #2: Venn diagrams [Technical Blog]

Posted: 7 Nov 2015 Updated: 9 Nov 2015 Views: 10,520 Rating: 5.00/5 Votes: 15 Popularity: 5.88

Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0

Using Venn diagrams to visualize sets.

Maths in IT #3: Algebra of sets [Technical Blog]

Posted: 13 Nov 2015 Updated: 16 Nov 2015 Views: 7,740 Rating: 4.86/5 Votes: 6 Popularity: 3.89

Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 0

An introduction to algebra and algebra of sets.

Programming Tips

General

How to Learn and Polyglot vs. Specialist [Technical Blog]

Posted: 4 Apr 2015 Updated: 4 Apr 2015 Views: 6,400 Rating: 5.00/5 Votes: 4 Popularity: 3.01

Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0

Why you should learn new languages and why you should know a lot about a bit and a bit about a lot.

Average tips rating: 4.72

Database

General

The Evil That is "Select *" [Tip/Trick]

Posted: 25 Jul 2011 Updated: 25 Jul 2011 Views: 6,640 Rating: 4.43/5 Votes: 6 Popularity: 3.89

Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 0

Another 'weird feature' of select * is that in Views select * does not select all columns from a table. It selects all columns from a table that were in the table at the time that the View was created. I found that out when I added some columns to a table and wanted to map those columns in a...

Programming Tips

General

Text box to accept only number [Tip/Trick]

Posted: 24 Apr 2011 Updated: 24 Apr 2011 Views: 49,460 Rating: 4.33/5 Votes: 12 Popularity: 4.62

Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0

The following Class is a TextBox for WinForms that only accepts 0, 1, 2, 3, 4, 5, 6, 7, 8, 9 (numerics) or backspace as input. Not using regular expressions.using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Windows.Forms;namespace...

Getting the one and only Type of an Object [Tip/Trick]

Posted: 6 Oct 2011 Updated: 7 Oct 2011 Views: 14,330 Rating: 4.85/5 Votes: 6 Popularity: 3.77

Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 0

How to check an Objects Type, ignoring all subtypes, in C# and VB.

Preventing stubbed methods from being released [Tip/Trick]

Posted: 14 Oct 2011 Updated: 15 Oct 2011 Views: 5,290 Rating: 4.90/5 Votes: 3 Popularity: 2.34

Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 0

Very nice tips indeed!A somewhat different approach to this might be to use the Debugger.IsAttached[^] static property.Though this works somewhat different.if (System.Diagnostics.Debugger.IsAttached){ // This code executes when starting from VS either in release or debug...

One guideline every VB.NET project should follow! [Tip/Trick]

Posted: 23 Feb 2012 Updated: 25 Feb 2012 Views: 22,720 Rating: 5.00/5 Votes: 11 Popularity: 5.21

Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 0

On the importance of Option Strict...

Write comments that matter [Tip/Trick]

Posted: 28 Sep 2012 Updated: 2 May 2015 Views: 23,480 Rating: 4.84/5 Votes: 21 Popularity: 6.35

Licence: The Code Project Open License (CPOL) Bookmarked: 13 Downloaded: 0

If you have nothing smart to comment, don't comment anything at all...

No reference articles have been posted.

Sander Rossel

	Software Developer (Senior)
	Netherlands

Sander Rossel is a professional developer since 2010 with working experience in .NET (VB and C#, WinForms, MVC, Web API, and Entity Framework), SQL Server, VSTS, JavaScript, Git, Jenkins, Oracle, and other technologies.
He has an interest in various technologies including, but not limited to, functional programming, NoSQL, software design, Continuous Integration, and software quality in general.

You can't miss his must read book Continuous Integration, Delivery, and Deployment!

He also wrote the +/- 100 page eBooks Object-Oriented Programming in C# Succinctly and SQL Server for C# Developers Succinctly.

And he wrote a JavaScript LINQ library, arrgh.js (works in IE8+, Edge, Firefox, Chrome, and probably everything else).

Check out his prize-winning articles here on CodeProject as well!

Advertise | Privacy |
Web03 | 2.8.180417.1 | Last Updated 21 Apr 2018

Layout: fixed | fluid