Articles by Wendelius (Articles: 29, Technical Blogs: 2, Tip/Tricks: 36, Reference: 1)

Articles: 29, Technical Blogs: 2, Tip/Tricks: 36, Reference: 1

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating: 4.89

Database
Oracle	Custom Aggregates in Oracle Posted: 19 Mar 2011 Updated: 19 Mar 2011 Views: 32,462 Rating: 4.91/5 Votes: 8 Popularity: 4.43 Licence: The Code Project Open License (CPOL) Bookmarked: 10 Downloaded: 146 Please Sign up or sign in to vote. How to create custom aggregates in Oracle using PL/SQL
	Installing Oracle 11g XE (Express Edition) Posted: 14 Sep 2011 Updated: 14 Sep 2011 Views: 180,369 Rating: 4.72/5 Votes: 11 Popularity: 4.92 Licence: The Code Project Open License (CPOL) Bookmarked: 23 Downloaded: 0 Please Sign up or sign in to vote. This article briefly describes basic information about installing the Oracle 11g XE database on Windows and few Developer tools such as SQL Developer
	Mimicking SQL Server identity column in Oracle Posted: 8 Jan 2012 Updated: 8 Jan 2012 Views: 42,072 Rating: 4.94/5 Votes: 5 Popularity: 3.45 Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 307 Please Sign up or sign in to vote. This article describes how to use a sequence to mimic the SQL Server identity column in Oracle.
	Examples for Creating Oracle Functions Posted: 13 Mar 2011 Updated: 1 Apr 2012 Views: 156,704 Rating: 4.75/5 Votes: 11 Popularity: 4.75 Licence: The Code Project Open License (CPOL) Bookmarked: 13 Downloaded: 991 Please Sign up or sign in to vote. The article starts with building a simple toolkit package using basic PL/SQL but also covers some more advanced techniques, such as pipeline.
	Logging information in Oracle Posted: 30 Apr 2012 Updated: 1 May 2012 Views: 31,157 Rating: 5.00/5 Votes: 5 Popularity: 3.49 Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 262 Please Sign up or sign in to vote. This article describes techniques such as autonomous transactions and action information that can be used when logging information about operations in Oracle database.
SQL	SQL Server: Query to find upcoming birthdays for the current week Posted: 13 Sep 2012 Updated: 13 Sep 2012 Views: 58,208 Rating: 5.00/5 Votes: 8 Popularity: 4.52 Licence: The Code Project Open License (CPOL) Bookmarked: 10 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "SQL Server: Query to find upcoming birthdays for the current week"
SQL Server	How to pass multiple records to a Stored Procedure Posted: 2 Dec 2008 Updated: 2 Dec 2008 Views: 123,515 Rating: 4.92/5 Votes: 31 Popularity: 7.11 Licence: The Code Project Open License (CPOL) Bookmarked: 89 Downloaded: 1,133 Please Sign up or sign in to vote. How to pass multiple records to a Stored Procedure in a single roundtrip.
	Physical location of a row in SQL Server Posted: 20 Feb 2011 Updated: 25 Feb 2011 Views: 78,256 Rating: 4.85/5 Votes: 18 Popularity: 6.08 Licence: The Code Project Open License (CPOL) Bookmarked: 32 Downloaded: 220 Please Sign up or sign in to vote. This article describes the pseudo column to identify the unique physical location of a single row.
	Custom Aggregates in SQL Server Posted: 17 Mar 2011 Updated: 26 Mar 2011 Views: 72,423 Rating: 4.95/5 Votes: 24 Popularity: 6.84 Licence: The Code Project Open License (CPOL) Bookmarked: 41 Downloaded: 545 Please Sign up or sign in to vote. SQL Server not having the aggregates you need? Why not build your own.
	Using Table-Valued Functions in SQL Server Posted: 10 Mar 2011 Updated: 6 Aug 2011 Views: 553,223 Rating: 4.92/5 Votes: 51 Popularity: 8.27 Licence: The Code Project Open License (CPOL) Bookmarked: 65 Downloaded: 1,204 Please Sign up or sign in to vote. This article shows few examples for using Table-Valued Functions.
	Mimicking null-safe equal to operator in SQL Server Posted: 19 Sep 2011 Updated: 20 Sep 2011 Views: 29,842 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 87 Please Sign up or sign in to vote. This article describes how to mimic the null-safe equal to operator using an UDF in SQL Server.
	Executing multiple SQL statements as one against SQL Server Posted: 27 Dec 2011 Updated: 27 Dec 2011 Views: 247,854 Rating: 4.91/5 Votes: 16 Popularity: 5.78 Licence: The Code Project Open License (CPOL) Bookmarked: 26 Downloaded: 1,305 Please Sign up or sign in to vote. This article describes a few techniques for how multiple SQL statements can be executed with one SqlCommand.
	Control trigger logic based on user Posted: 20 May 2012 Updated: 20 May 2012 Views: 16,700 Rating: 4.90/5 Votes: 7 Popularity: 4.14 Licence: The Code Project Open License (CPOL) Bookmarked: 10 Downloaded: 111 Please Sign up or sign in to vote. This article describes a mechanism how trigger actions bypassed based on database user information
	About transaction log and its truncation in SQL Server Posted: 7 May 2012 Updated: 9 Aug 2012 Views: 68,110 Rating: 4.55/5 Votes: 8 Popularity: 4.11 Licence: The Code Project Open License (CPOL) Bookmarked: 25 Downloaded: 0 Please Sign up or sign in to vote. Article describes basic information about transaction log behavior and truncation of the log.
	Calculating simple running totals in SQL Server Posted: 15 Dec 2011 Updated: 12 Dec 2014 Views: 375,352 Rating: 4.90/5 Votes: 40 Popularity: 7.86 Licence: The Code Project Open License (CPOL) Bookmarked: 49 Downloaded: 974 Please Sign up or sign in to vote. Some simple scenarios to calculate running totals in SQL Server.
	Logging from inside a transaction Posted: 19 Jan 2015 Updated: 21 Feb 2015 Views: 39,890 Rating: 4.94/5 Votes: 30 Popularity: 7.23 Licence: The Code Project Open License (CPOL) Bookmarked: 38 Downloaded: 242 Please Sign up or sign in to vote. How to log information into a table from inside a transaction, even if the transaction is rolled back.
	What should be considered when NOLOCK hint is used Posted: 11 Feb 2011 Updated: 12 Jul 2016 Views: 44,012 Rating: 4.97/5 Votes: 17 Popularity: 6.11 Licence: The Code Project Open License (CPOL) Bookmarked: 16 Downloaded: 57 Please Sign up or sign in to vote. When considering to use NOLOCK hint, there are a few things that should be kept in mind.
	Restricting logon to SQL Server Posted: 13 Oct 2016 Updated: 18 Oct 2016 Views: 13,223 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: The Code Project Open License (CPOL) Bookmarked: 12 Downloaded: 360 Please Sign up or sign in to vote. Discussion and a few approaches how to restrict logging into SQL Server using a logon trigger or into a database by using a specific procedure.
	Writing into a file from database Posted: 2 Oct 2016 Updated: 4 Nov 2016 Views: 17,132 Rating: 5.00/5 Votes: 9 Popularity: 4.77 Licence: The Code Project Open License (CPOL) Bookmarked: 19 Downloaded: 489 Please Sign up or sign in to vote. Few CLR procedure concepts to write into a file from SQL Server database
	How to store and fetch binary data into a file stream column Posted: 3 Jan 2009 Updated: 11 Dec 2016 Views: 195,456 Rating: 4.87/5 Votes: 44 Popularity: 7.95 Licence: The Code Project Open License (CPOL) Bookmarked: 89 Downloaded: 4,914 Please Sign up or sign in to vote. Desribes how to store and fetch binary data to a filestream column compared to a varbinary column.
	What You See Is What You Update Posted: 2 Apr 2017 Updated: 2 Apr 2017 Views: 7,331 Rating: 4.95/5 Votes: 4 Popularity: 2.98 Licence: The Code Project Open License (CPOL) Bookmarked: 0 Downloaded: 77 Please Sign up or sign in to vote. This is an alternative for "What You See Is What You Update"
	How to Prevent When a Transaction Accidentally Overwrites Modified Data Posted: 23 Mar 2017 Updated: 30 Apr 2017 Views: 17,531 Rating: 4.91/5 Votes: 15 Popularity: 5.62 Licence: The Code Project Open License (CPOL) Bookmarked: 15 Downloaded: 492 Please Sign up or sign in to vote. This article explains the problem, when another transaction (concurrent or not) accidentally overwrites previously modified data and how to prevent this from happening.
	Properly executing database operations Posted: 19 Aug 2015 Updated: 10 Jul 2017 Views: 39,557 Rating: 4.91/5 Votes: 40 Popularity: 7.70 Licence: The Code Project Open License (CPOL) Bookmarked: 58 Downloaded: 810 Please Sign up or sign in to vote. This article discusses some basic requirements for successful database operations such as error handling, use of parameters and transactions.
	Data versioning in SQL Server using snapshot a.k.a. row versions Posted: 11 Oct 2008 Updated: 7 Feb 2018 Views: 60,493 Rating: 4.34/5 Votes: 23 Popularity: 5.91 Licence: The Code Project Open License (CPOL) Bookmarked: 35 Downloaded: 196 Please Sign up or sign in to vote. This article describes how to enable SQL Server internal row versioning to achieve greater concurrency in OLTP systems. This is done by enabling snapshot isolation.
	Custom String Split Function with Few Enhancements Posted: 26 Dec 2018 Updated: 26 Dec 2018 Views: 4,652 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 100 Please Sign up or sign in to vote. This article shows a custom SQL Server function to split a string delimited by a character or a set of characters. The function also contains a few handy enhancements.
C#
Utilities	Directory size browser Posted: 10 Feb 2015 Updated: 17 Feb 2015 Views: 49,873 Rating: 4.92/5 Votes: 47 Popularity: 8.13 Licence: The Code Project Open License (CPOL) Bookmarked: 92 Downloaded: 3,065 Please Sign up or sign in to vote. This article shows how to build a responsive directory size browser application utilizing threading. The source code includes both C# and VB.Net
Libraries
Code Libraries	Creating basic Excel workbook with Open XML Posted: 22 Apr 2012 Updated: 5 May 2012 Views: 258,810 Rating: 4.93/5 Votes: 48 Popularity: 8.24 Licence: The Code Project Open License (CPOL) Bookmarked: 109 Downloaded: 19,616 Please Sign up or sign in to vote. This article describes how to create a basic Excel workbook using Open XML.
Algorithms & Recipes
Math	Simple trend calculation Posted: 22 May 2016 Updated: 15 Aug 2017 Views: 40,949 Rating: 4.96/5 Votes: 14 Popularity: 5.53 Licence: The Code Project Open License (CPOL) Bookmarked: 29 Downloaded: 1,637 Please Sign up or sign in to vote. Simple linear trend calculation with different types for X values implemented in C#, VB, and F#
Cryptography & Security
Encryption	Encrypting a dataset using AES, including compression Posted: 9 Sep 2012 Updated: 21 Aug 2015 Views: 99,585 Rating: 4.98/5 Votes: 49 Popularity: 8.37 Licence: The Code Project Open License (CPOL) Bookmarked: 127 Downloaded: 4,680 Please Sign up or sign in to vote. Article describes how to encrypt a dataset using AES. Optionally the dataset is compressed before the encryption.

Average blogs rating: 4.72

Database
General	Let’s SELECT Errors... [Technical Blog] Posted: 23 Aug 2015 Updated: 25 Aug 2015 Views: 15,840 Rating: 4.72/5 Votes: 6 Popularity: 3.68 Licence: The Code Project Open License (CPOL) Bookmarked: 10 Downloaded: 0 Please Sign up or sign in to vote. This post discusses about how to add checks into a SQL statement in order to prevent wrong results in case of possible future changes.
SQL Server	Struggling with System.IO.Packaging when Creating a CLR Procedure [Technical Blog] Posted: 7 Oct 2012 Updated: 19 Oct 2012 Views: 12,980 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 0 Please Sign up or sign in to vote. System.IO.Packaging namespace in WindowsBase may cause problems when trying to create a CLR procedure.

Average tips rating: 4.88

Miscellaneous
General	Small Utility to Swap Mouse Buttons [Tip/Trick] Posted: 29 Feb 2020 Updated: 29 Feb 2020 Views: 11,370 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: The Code Project Open License (CPOL) Bookmarked: 0 Downloaded: 44 Please Sign up or sign in to vote. Toggle mouse button swapping between on and off
Database
General	How to Change Password in Oracle [Tip/Trick] Posted: 21 Feb 2011 Updated: 26 Jul 2015 Views: 17,000 Rating: 4.86/5 Votes: 4 Popularity: 2.92 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. This alternative is created to correct few mistakes in the original tip. Most importantly: Never update system tables.
Oracle	How to Guarantee a Fixed Amount of Rows in a Table in Oracle [Tip/Trick] Posted: 19 May 2012 Updated: 19 May 2012 Views: 9,930 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 22 Please Sign up or sign in to vote. This tip describes how to guarantee a fixed amount of rows in a table by using triggers in Oracle.
	Generating desired amount of rows in Oracle using single statement [Tip/Trick] Posted: 31 Aug 2014 Updated: 31 Aug 2014 Views: 12,812 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 33 Please Sign up or sign in to vote. Two ways of generating desired amount of rows in Oracle by using a single SQL statement.
	Fibonacci sequence in Oracle using sinqle SQL statement [Tip/Trick] Posted: 5 Sep 2014 Updated: 5 Sep 2014 Views: 21,083 Rating: 4.20/5 Votes: 2 Popularity: 1.26 Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 55 Please Sign up or sign in to vote. This tip shows two ways of generating Fibonacci numbers in a single SQL statement
	How to Fetch Data from the Previous or Next Rows in the Resultset [Tip/Trick] Posted: 22 Feb 2011 Updated: 26 Jul 2015 Views: 22,210 Rating: 4.82/5 Votes: 6 Popularity: 3.75 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. This tip demonstrates the use of LAG and LEAD functions in Oracle.
	What’s the Difference between a Full Index Scan and a Fast Full Index Scan in Oracle? [Tip/Trick] Posted: 13 Jul 2017 Updated: 13 Jul 2017 Views: 161,253 Rating: 5.00/5 Votes: 3 Popularity: 2.39 Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 48 Please Sign up or sign in to vote. This is an alternative for "What’s the Difference between a Full Index Scan and a Fast Full Index Scan in Oracle?"
SQL Server	How to remove duplicate rows in SQL Server 2008 when no key is present [Tip/Trick] Posted: 20 Feb 2011 Updated: 20 Feb 2011 Views: 98,077 Rating: 4.95/5 Votes: 12 Popularity: 5.34 Licence: The Code Project Open License (CPOL) Bookmarked: 22 Downloaded: 0 Please Sign up or sign in to vote. This tip describes how to delete duplicate rows from a table that doesn't have a key.
	List SQL Server Table Column Name as Rows [Tip/Trick] Posted: 5 May 2012 Updated: 6 May 2012 Views: 22,421 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "List SQL Server table column name as rows".
	Applying Running Total to a Result set [Tip/Trick] Posted: 14 May 2012 Updated: 14 May 2012 Views: 8,260 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 32 Please Sign up or sign in to vote. This is an alternative for "Applying Running Total to a Result set"
	How to Guarantee a Fixed Amount of Rows in a Table [Tip/Trick] Posted: 19 May 2012 Updated: 19 May 2012 Views: 6,380 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 24 Please Sign up or sign in to vote. This tip describes how to guarantee a fixed amount of rows in a table by using triggers
	How to remove duplicate rows in SQL Server 2005 when no key is present [Tip/Trick] Posted: 20 Feb 2011 Updated: 20 Dec 2012 Views: 30,120 Rating: 5.00/5 Votes: 6 Popularity: 3.89 Licence: The Code Project Open License (CPOL) Bookmarked: 16 Downloaded: 0 Please Sign up or sign in to vote. This tip describes how to delete duplicate rows from a table that doesn't have a key.
	Calculate aggregates for dynamic columns using UNPIVOT [Tip/Trick] Posted: 27 Dec 2012 Updated: 17 Jan 2013 Views: 25,316 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 47 Please Sign up or sign in to vote. This tip describes how to calculate an aggregate for dynamically defined columns using UNPIVOT clause.
	Check if a number is a power of 2 with Sql Server 2012 [Tip/Trick] Posted: 18 Dec 2012 Updated: 19 Jan 2013 Views: 30,983 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 38 Please Sign up or sign in to vote. This tip shows how to get rows from a table where a field contains a number that is a power of 2 using LOG function.
	Generating a set of random numbers in SQL Server [Tip/Trick] Posted: 26 Aug 2014 Updated: 26 Aug 2014 Views: 45,727 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 189 Please Sign up or sign in to vote. Generate a set of random numbers by using CTE
	Fibonacci sequence using SQL Server CTE [Tip/Trick] Posted: 26 Aug 2014 Updated: 28 Aug 2014 Views: 33,489 Rating: 4.83/5 Votes: 10 Popularity: 4.83 Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 101 Please Sign up or sign in to vote. Generate Fibonacci numbers using CTE
	How to fetch data from the previous or next rows in the resultset [Tip/Trick] Posted: 27 Jul 2011 Updated: 31 Aug 2014 Views: 24,762 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: The Code Project Open License (CPOL) Bookmarked: 11 Downloaded: 70 Please Sign up or sign in to vote. This tip demonstrates the use of LAG and LEAD functions in SQL Server.
	To cause an error when updating a row with non-existing lookup reference [Tip/Trick] Posted: 10 Sep 2014 Updated: 10 Sep 2014 Views: 7,550 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 24 Please Sign up or sign in to vote. The tip shows how to intentionally cause an error in a situation where a non-existing reference would be updated.
	First and Last Occurrence of Day of Week Within a Month using SQL [Tip/Trick] Posted: 13 Sep 2014 Updated: 13 Sep 2014 Views: 10,872 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 58 Please Sign up or sign in to vote. This tip describes how to fetch the first or the last occurrence of given day of week within a month by using a single SQL statement.
	Generating Desired Amount of Rows in SQL using CTE [Tip/Trick] Posted: 26 Aug 2014 Updated: 16 Sep 2014 Views: 47,353 Rating: 4.64/5 Votes: 5 Popularity: 3.24 Licence: The Code Project Open License (CPOL) Bookmarked: 10 Downloaded: 93 Please Sign up or sign in to vote. How to generate desired amount of rows in SQL Server using CTE
	Difference Between Two datetime Values in Hours, Minutes, etc. [Tip/Trick] Posted: 18 Sep 2015 Updated: 18 Sep 2015 Views: 69,109 Rating: 5.00/5 Votes: 7 Popularity: 4.23 Licence: The Code Project Open License (CPOL) Bookmarked: 6 Downloaded: 181 Please Sign up or sign in to vote. This tip shows how to calculate a difference between two datetime values and to express the difference in years, days, hours, minutes and so on.
	TrimChar to Remove Desired Character [Tip/Trick] Posted: 26 Sep 2016 Updated: 30 Sep 2016 Views: 9,050 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. TrimChar function which removes occurences of the desired character from both ends of a string.
	How to Establish Dedicated Admin Connection (DAC) to SQL Server [Tip/Trick] Posted: 4 Oct 2016 Updated: 4 Oct 2016 Views: 20,741 Rating: 4.50/5 Votes: 5 Popularity: 3.15 Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 0 Please Sign up or sign in to vote. Few tips for connecting to an SQL Server instance using DAC
	How to Format Repeating Values in SQL Result Set [Tip/Trick] Posted: 13 Oct 2016 Updated: 13 Oct 2016 Views: 10,704 Rating: 5.00/5 Votes: 8 Popularity: 4.52 Licence: The Code Project Open License (CPOL) Bookmarked: 6 Downloaded: 36 Please Sign up or sign in to vote. A little tip on how to format repeating values in SQL output using LAG function
	Selecting Valid Records [Tip/Trick] Posted: 7 Dec 2016 Updated: 7 Dec 2016 Views: 9,370 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: The Code Project Open License (CPOL) Bookmarked: 2 Downloaded: 28 Please Sign up or sign in to vote. This tip demonstrates how to select valid records from a table that contains validity date limits.
	Types Don't Match between the Anchor and the Recursive Part in Column... [Tip/Trick] Posted: 29 Dec 2019 Updated: 29 Dec 2019 Views: 4,642 Rating: 5.00/5 Votes: 4 Popularity: 3.01 Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 14 Please Sign up or sign in to vote. How to overcome the error message "Types don't match between the anchor and the recursive part in column..." for varchar columns in a recursive CTE query
C#
General	Multiple partial definitions for a class [Tip/Trick] Posted: 17 Nov 2012 Updated: 17 Nov 2012 Views: 8,140 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 7 Downloaded: 51 Please Sign up or sign in to vote. The tip shows an example for using multiple partial classes to define a single class.
Samples	Cumulating values with LINQ [Tip/Trick] Posted: 26 Jul 2012 Updated: 26 Jul 2012 Views: 21,550 Rating: 4.72/5 Votes: 4 Popularity: 2.84 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 94 Please Sign up or sign in to vote. This tip describes few examples how ro cumulate values using an extension method with LINQ
	Cumulating values with LINQ [Tip/Trick] Posted: 28 Jul 2012 Updated: 27 Jul 2012 Views: 9,790 Rating: 0.00/5 Votes: 0 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 1 Downloaded: 18 Please Sign up or sign in to vote. This is an alternative for "Cumulating values with LINQ"
LINQ
General	Query Hierarchical DataTable [Tip/Trick] Posted: 5 Oct 2015 Updated: 5 Oct 2015 Views: 16,891 Rating: 4.93/5 Votes: 11 Popularity: 5.13 Licence: The Code Project Open License (CPOL) Bookmarked: 19 Downloaded: 506 Please Sign up or sign in to vote. This tip shows one way to query hierarchical data from a DataTable by using an AsTree() method.
Programming Tips
Design and Strategy	Using enum to define a new enum [Tip/Trick] Posted: 20 Jul 2012 Updated: 10 Aug 2012 Views: 52,116 Rating: 4.64/5 Votes: 10 Popularity: 4.64 Licence: The Code Project Open License (CPOL) Bookmarked: 16 Downloaded: 107 Please Sign up or sign in to vote. This tip describes how to use an existing enum to define a new, for example a context specific enum.
General	All the jobs in SQL Server [Tip/Trick] Posted: 10 Aug 2011 Updated: 10 Aug 2011 Views: 7,130 Rating: 4.60/5 Votes: 3 Popularity: 2.19 Licence: The Code Project Open License (CPOL) Bookmarked: 0 Downloaded: 0 Please Sign up or sign in to vote. Or simply:exec msdb..sp_help_jobsp_help_job (Transact-SQL)[^]
	How to connect with different types of DataBase? [Tip/Trick] Posted: 25 Nov 2011 Updated: 24 Dec 2011 Views: 20,330 Rating: 4.73/5 Votes: 6 Popularity: 3.68 Licence: The Code Project Open License (CPOL) Bookmarked: 3 Downloaded: 0 Please Sign up or sign in to vote. As a general rule of thumb, I'd suggest browsing http://www.connectionstrings.com/[^] for connection strings against popular data sources.
	Resolve DesignMode for a User Control [Tip/Trick] Posted: 26 Aug 2012 Updated: 26 Aug 2012 Views: 42,452 Rating: 5.00/5 Votes: 10 Popularity: 4.77 Licence: The Code Project Open License (CPOL) Bookmarked: 8 Downloaded: 644 Please Sign up or sign in to vote. The tip shows one way to resolve if a user control is in design mode.
	How To Extract Images From An Office Document [Tip/Trick] Posted: 26 Jul 2015 Updated: 26 Jul 2015 Views: 6,941 Rating: 4.50/5 Votes: 2 Popularity: 1.35 Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 141 Please Sign up or sign in to vote. This tip shows how to extract images from an Office document saved in Office Open XML format.
String handling
Strings	Manipulating a string array using a Lambda Expression [Tip/Trick] Posted: 7 Nov 2012 Updated: 7 Nov 2012 Views: 23,923 Rating: 5.00/5 Votes: 1 Popularity: 0.00 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "Manipulating a string array using a Lambda Expression"
Installation
General	Getting publishing information for a ClickOnce deployment [Tip/Trick] Posted: 27 Mar 2012 Updated: 27 Mar 2012 Views: 16,991 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: The Code Project Open License (CPOL) Bookmarked: 5 Downloaded: 0 Please Sign up or sign in to vote. This tip describes a way to get publishing information for a ClickOnce deployed application
	Getting publishing information for a ClickOnce deployment [Tip/Trick] Posted: 1 Apr 2012 Updated: 1 Apr 2012 Views: 14,100 Rating: 5.00/5 Votes: 2 Popularity: 1.51 Licence: The Code Project Open License (CPOL) Bookmarked: 4 Downloaded: 0 Please Sign up or sign in to vote. This is an alternative for "Getting publishing information for a ClickOnce deployment"

Average reference rating: 4.92

Tools and IDE
General	Your Development Tools [Reference] Posted: 5 Nov 2013 Updated: 4 Aug 2017 Views: 170,101 Rating: 4.92/5 Votes: 50 Popularity: 8.27 Licence: The Code Project Open License (CPOL) Bookmarked: 212 Downloaded: 0 Please Sign up or sign in to vote. A list of useful development tools edited by members of CodeProject

No projects have been posted.

Wendelius

	Architect
	Europe

Biography provided

Articles by Wendelius (Articles: 29, Technical Blogs: 2, Tip/Tricks: 36, Reference: 1)

Articles: 29, Technical Blogs: 2, Tip/Tricks: 36, Reference: 1

Average article rating: 4.89

Database

C#

Libraries

Algorithms & Recipes

Cryptography & Security

Average blogs rating: 4.72

Database

Average tips rating: 4.88

Miscellaneous

Database

C#

LINQ

Programming Tips

String handling

Installation

Average reference rating: 4.92

Tools and IDE