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: 30,450 Rating: 4.99/5 Votes: 65 Popularity: 9.05

Licence: The Code Project Open License (CPOL) Bookmarked: 52 Downloaded: 125

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: 192,790 Rating: 4.85/5 Votes: 102 Popularity: 9.73

Licence: The Code Project Open License (CPOL) Bookmarked: 151 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: 72,550 Rating: 4.90/5 Votes: 46 Popularity: 8.15

Licence: The Code Project Open License (CPOL) Bookmarked: 89 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: 234,700 Rating: 4.80/5 Votes: 45 Popularity: 7.94

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

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: 91,340 Rating: 4.94/5 Votes: 76 Popularity: 9.30

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

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: 116,830 Rating: 4.91/5 Votes: 68 Popularity: 9.00

Licence: The Code Project Open License (CPOL) Bookmarked: 117 Downloaded: 2,530

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: 70,120 Rating: 4.82/5 Votes: 56 Popularity: 8.42

Licence: The Code Project Open License (CPOL) Bookmarked: 112 Downloaded: 991

An introduction to knowing what NOT to do.

Average blogs rating: 4.84

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: 22,400 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: 16,290 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: 11,530 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: 19,660 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: 23,150 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: 8,280 Rating: 4.63/5 Votes: 6 Popularity: 3.72

Licence: The Code Project Open License (CPOL) Bookmarked: 10 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: 4,180 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: 24,610 Rating: 4.72/5 Votes: 9 Popularity: 4.48

Licence: The Code Project Open License (CPOL) Bookmarked: 23 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: 34,390 Rating: 4.76/5 Votes: 22 Popularity: 6.37

Licence: The Code Project Open License (CPOL) Bookmarked: 41 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: 19,680 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: 13,950 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: 15,920 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: 24,550 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: 10,400 Rating: 5.00/5 Votes: 7 Popularity: 4.23

Licence: The Code Project Open License (CPOL) Bookmarked: 6 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: 20,660 Rating: 4.89/5 Votes: 15 Popularity: 5.82

Licence: The Code Project Open License (CPOL) Bookmarked: 28 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: 14,410 Rating: 5.00/5 Votes: 4 Popularity: 3.01

Licence: The Code Project Open License (CPOL) Bookmarked: 10 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: 7,720 Rating: 4.71/5 Votes: 5 Popularity: 3.30

Licence: The Code Project Open License (CPOL) Bookmarked: 9 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: 10,760 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: 8,810 Rating: 5.00/5 Votes: 4 Popularity: 3.01

Licence: The Code Project Open License (CPOL) Bookmarked: 10 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: 10,280 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: 8,790 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: 6,730 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,090 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: 245,120 Rating: 4.70/5 Votes: 38 Popularity: 7.42

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

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

NoSQL

General

A first look at NoSQL and MongoDB in particular [Technical Blog]

Posted: 4 Nov 2014 Updated: 16 Mar 2015 Views: 23,450 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: 15,970 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: 8,800 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: 6,180 Rating: 4.86/5 Votes: 6 Popularity: 3.89

Licence: The Code Project Open License (CPOL) Bookmarked: 7 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: 5,870 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: 5,940 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: 44,810 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: 13,380 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: 4,570 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: 21,110 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: 22,220 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
	Netherlands

Sander Rossel is a professional developer with a working experience in .NET (VB and C#, WinForms, MVC, Entity Framework), HTML, CSS, JavaScript, Oracle and SQL Server.

He has an interest in various technologies including, but not limited to, Functional Programming, NoSQL, Software Design, Continuous Integration and, more generally, Software Quality.

He wrote two ebooks which you can download for free: Object-Oriented Programming in C# Succinctly and SQL Server for C# Developers Succinctly

He seeks to educate others on his blog, Sander's bits - Writing the code you need, on his CodeProject profile and through his continuing book-writing.

Advertise | Privacy |
Web03 | 2.8.170924.2 | Last Updated 25 Sep 2017

Layout: fixed | fluid