Click here to Skip to main content
14,971,742 members

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

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

RSS Feed

Average article rating: 4.89

Database Development
SQL Server
Posted: 2 Dec 2008   Updated: 2 Dec 2008   Views: 126,446   Rating: 4.92/5    Votes: 31   Popularity: 7.11
Licence: The Code Project Open License (CPOL)      Bookmarked: 89   Downloaded: 1,140
Please Sign up or sign in to vote.
How to pass multiple records to a Stored Procedure in a single roundtrip.
Posted: 20 Feb 2011   Updated: 25 Feb 2011   Views: 81,376   Rating: 4.85/5    Votes: 18   Popularity: 6.08
Licence: The Code Project Open License (CPOL)      Bookmarked: 32   Downloaded: 222
Please Sign up or sign in to vote.
This article describes the pseudo column to identify the unique physical location of a single row.
Posted: 17 Mar 2011   Updated: 26 Mar 2011   Views: 76,073   Rating: 4.95/5    Votes: 24   Popularity: 6.84
Licence: The Code Project Open License (CPOL)      Bookmarked: 41   Downloaded: 547
Please Sign up or sign in to vote.
SQL Server not having the aggregates you need? Why not build your own.
Posted: 10 Mar 2011   Updated: 6 Aug 2011   Views: 561,963   Rating: 4.92/5    Votes: 51   Popularity: 8.27
Licence: The Code Project Open License (CPOL)      Bookmarked: 65   Downloaded: 1,209
Please Sign up or sign in to vote.
This article shows few examples for using Table-Valued Functions.
Posted: 19 Sep 2011   Updated: 20 Sep 2011   Views: 31,072   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 88
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.
Posted: 27 Dec 2011   Updated: 27 Dec 2011   Views: 253,774   Rating: 4.91/5    Votes: 16   Popularity: 5.78
Licence: The Code Project Open License (CPOL)      Bookmarked: 26   Downloaded: 1,318
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.
Posted: 20 May 2012   Updated: 20 May 2012   Views: 17,050   Rating: 4.90/5    Votes: 7   Popularity: 4.14
Licence: The Code Project Open License (CPOL)      Bookmarked: 10   Downloaded: 114
Please Sign up or sign in to vote.
This article describes a mechanism how trigger actions bypassed based on database user information
Posted: 7 May 2012   Updated: 9 Aug 2012   Views: 68,831   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.
Posted: 15 Dec 2011   Updated: 12 Dec 2014   Views: 382,055   Rating: 4.90/5    Votes: 40   Popularity: 7.86
Licence: The Code Project Open License (CPOL)      Bookmarked: 50   Downloaded: 981
Please Sign up or sign in to vote.
Some simple scenarios to calculate running totals in SQL Server.
Posted: 19 Jan 2015   Updated: 21 Feb 2015   Views: 42,150   Rating: 4.94/5    Votes: 30   Popularity: 7.23
Licence: The Code Project Open License (CPOL)      Bookmarked: 38   Downloaded: 251
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.
Posted: 11 Feb 2011   Updated: 12 Jul 2016   Views: 45,442   Rating: 4.97/5    Votes: 17   Popularity: 6.11
Licence: The Code Project Open License (CPOL)      Bookmarked: 16   Downloaded: 59
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.
Posted: 3 Jan 2009   Updated: 11 Dec 2016   Views: 200,407   Rating: 4.87/5    Votes: 44   Popularity: 7.95
Licence: The Code Project Open License (CPOL)      Bookmarked: 91   Downloaded: 5,030
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.
Posted: 2 Apr 2017   Updated: 2 Apr 2017   Views: 7,771   Rating: 4.95/5    Votes: 4   Popularity: 2.98
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 85
Please Sign up or sign in to vote.
This is an alternative for "What You See Is What You Update"
Posted: 23 Mar 2017   Updated: 30 Apr 2017   Views: 18,571   Rating: 4.91/5    Votes: 15   Popularity: 5.62
Licence: The Code Project Open License (CPOL)      Bookmarked: 15   Downloaded: 504
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.
Posted: 19 Aug 2015   Updated: 10 Jul 2017   Views: 41,987   Rating: 4.91/5    Votes: 40   Popularity: 7.70
Licence: The Code Project Open License (CPOL)      Bookmarked: 59   Downloaded: 833
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.
Posted: 26 Dec 2018   Updated: 26 Dec 2018   Views: 5,232   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.
Posted: 13 Oct 2016   Updated: 18 Oct 2016   Views: 14,063   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 12   Downloaded: 369
Please Sign up or sign in to vote.
Discussion and a few approaches to restrict logging into SQL Server using a logon trigger or into a database by using a specific procedure
Posted: 2 Oct 2016   Updated: 4 Nov 2016   Views: 18,362   Rating: 5.00/5    Votes: 9   Popularity: 4.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 19   Downloaded: 503
Please Sign up or sign in to vote.
Few CLR procedure concepts to write into a file from SQL Server database
Posted: 11 Oct 2008   Updated: 7 Feb 2018   Views: 61,373   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.
Enable SQL Server internal row versioning to achieve greater concurrency in OLTP systems using Snapshots
Desktop Programming
ATL
Posted: 13 Sep 2012   Updated: 13 Sep 2012   Views: 61,468   Rating: 5.00/5    Votes: 9   Popularity: 4.77
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"
WPF
Posted: 10 Feb 2015   Updated: 17 Feb 2015   Views: 52,813   Rating: 4.92/5    Votes: 47   Popularity: 8.13
Licence: The Code Project Open License (CPOL)      Bookmarked: 92   Downloaded: 3,159
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
Programming Languages
F#
Posted: 22 May 2016   Updated: 15 Aug 2017   Views: 43,699   Rating: 4.97/5    Votes: 14   Popularity: 5.53
Licence: The Code Project Open License (CPOL)      Bookmarked: 31   Downloaded: 1,716
Please Sign up or sign in to vote.
Simple linear trend calculation with different types for X values implemented in C#, VB, and F#
SQL
Posted: 19 Mar 2011   Updated: 19 Mar 2011   Views: 33,163   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
Posted: 14 Sep 2011   Updated: 14 Sep 2011   Views: 182,999   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
Posted: 8 Jan 2012   Updated: 8 Jan 2012   Views: 43,582   Rating: 4.94/5    Votes: 5   Popularity: 3.45
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 309
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.
Posted: 13 Mar 2011   Updated: 1 Apr 2012   Views: 158,144   Rating: 4.75/5    Votes: 11   Popularity: 4.75
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   Downloaded: 998
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.
Posted: 30 Apr 2012   Updated: 30 Apr 2012   Views: 32,297   Rating: 5.00/5    Votes: 5   Popularity: 3.49
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 267
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.
Visual Basic
Posted: 22 Apr 2012   Updated: 5 May 2012   Views: 264,824   Rating: 4.93/5    Votes: 48   Popularity: 8.24
Licence: The Code Project Open License (CPOL)      Bookmarked: 109   Downloaded: 19,838
Please Sign up or sign in to vote.
This article describes how to create a basic Excel workbook using Open XML.
Posted: 9 Sep 2012   Updated: 21 Aug 2015   Views: 102,997   Rating: 4.98/5    Votes: 49   Popularity: 8.37
Licence: The Code Project Open License (CPOL)      Bookmarked: 127   Downloaded: 4,715
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 Development
SQL Server
Posted: 7 Oct 2012   Updated: 19 Oct 2012   Views: 13,230   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.
Programming Languages
SQL
Posted: 23 Aug 2015   Updated: 25 Aug 2015   Views: 16,150   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.

Average tips rating: 4.83

Database Development
SQL Server
Posted: 20 Feb 2011   Updated: 20 Feb 2011   Views: 99,277   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.
Posted: 5 May 2012   Updated: 6 May 2012   Views: 22,801   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".
Posted: 14 May 2012   Updated: 14 May 2012   Views: 8,450   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"
Posted: 19 May 2012   Updated: 19 May 2012   Views: 6,470   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
Posted: 20 Feb 2011   Updated: 20 Dec 2012   Views: 30,590   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.
Posted: 27 Dec 2012   Updated: 17 Jan 2013   Views: 26,357   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 48
Please Sign up or sign in to vote.
This tip describes how to calculate an aggregate for dynamically defined columns using UNPIVOT clause.
Posted: 18 Dec 2012   Updated: 19 Jan 2013   Views: 32,183   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.
Posted: 26 Aug 2014   Updated: 26 Aug 2014   Views: 47,367   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 190
Please Sign up or sign in to vote.
Generate a set of random numbers by using CTE
Posted: 26 Aug 2014   Updated: 28 Aug 2014   Views: 35,009   Rating: 4.83/5    Votes: 10   Popularity: 4.83
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 103
Please Sign up or sign in to vote.
Generate Fibonacci numbers using CTE
Posted: 27 Jul 2011   Updated: 31 Aug 2014   Views: 25,222   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.
Posted: 10 Sep 2014   Updated: 10 Sep 2014   Views: 7,720   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.
Posted: 13 Sep 2014   Updated: 13 Sep 2014   Views: 11,272   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.
Posted: 26 Aug 2014   Updated: 16 Sep 2014   Views: 50,023   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
Posted: 18 Sep 2015   Updated: 18 Sep 2015   Views: 79,602   Rating: 5.00/5    Votes: 7   Popularity: 4.23
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 189
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.
Posted: 26 Sep 2016   Updated: 30 Sep 2016   Views: 9,370   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.
Posted: 4 Oct 2016   Updated: 4 Oct 2016   Views: 21,621   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
Posted: 13 Oct 2016   Updated: 13 Oct 2016   Views: 11,384   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
Posted: 7 Dec 2016   Updated: 7 Dec 2016   Views: 9,470   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 29
Please Sign up or sign in to vote.
This tip demonstrates how to select valid records from a table that contains validity date limits.
Posted: 28 Dec 2019   Updated: 28 Dec 2019   Views: 6,574   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 19
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
Posted: 10 Aug 2011   Updated: 10 Aug 2011   Views: 7,220   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)[^]
Desktop Programming
Windows Forms
Posted: 26 Aug 2012   Updated: 26 Aug 2012   Views: 44,003   Rating: 5.00/5    Votes: 10   Popularity: 4.77
Licence: The Code Project Open License (CPOL)      Bookmarked: 8   Downloaded: 660
Please Sign up or sign in to vote.
The tip shows one way to resolve if a user control is in design mode.
WPF
Posted: 5 Apr 2021   Updated: 5 Apr 2021   Views: 3,482   Rating: 4.53/5    Votes: 6   Popularity: 3.52
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 62
Please Sign up or sign in to vote.
When a string longer that 65536 is shown using a message box, the result might be unexpected.
Oracle
Posted: 21 Feb 2011   Updated: 26 Jul 2015   Views: 17,260   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.
Programming Languages
C#
Posted: 29 Feb 2020   Updated: 29 Feb 2020   Views: 12,010   Rating: 5.00/5    Votes: 4   Popularity: 3.01
Licence: The Code Project Open License (CPOL)      Bookmarked: 0   Downloaded: 49
Please Sign up or sign in to vote.
Toggle mouse button swapping between on and off
Posted: 17 Nov 2012   Updated: 17 Nov 2012   Views: 8,240   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.
Posted: 26 Jul 2012   Updated: 26 Jul 2012   Views: 22,751   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
Posted: 20 Jul 2012   Updated: 10 Aug 2012   Views: 54,436   Rating: 4.64/5    Votes: 10   Popularity: 4.64
Licence: The Code Project Open License (CPOL)      Bookmarked: 16   Downloaded: 109
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.
Posted: 26 Jul 2015   Updated: 26 Jul 2015   Views: 7,241   Rating: 4.50/5    Votes: 2   Popularity: 1.35
Licence: The Code Project Open License (CPOL)      Bookmarked: 5   Downloaded: 143
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.
Posted: 7 Nov 2012   Updated: 7 Nov 2012   Views: 24,363   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"
Posted: 27 Mar 2012   Updated: 27 Mar 2012   Views: 17,531   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
SQL
Posted: 19 May 2012   Updated: 19 May 2012   Views: 10,150   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.
Posted: 31 Aug 2014   Updated: 31 Aug 2014   Views: 13,402   Rating: 5.00/5    Votes: 1   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 35
Please Sign up or sign in to vote.
Two ways of generating desired amount of rows in Oracle by using a single SQL statement.
Posted: 5 Sep 2014   Updated: 5 Sep 2014   Views: 21,743   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
Posted: 22 Feb 2011   Updated: 26 Jul 2015   Views: 22,530   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.
Posted: 13 Jul 2017   Updated: 13 Jul 2017   Views: 164,363   Rating: 5.00/5    Votes: 3   Popularity: 2.39
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 49
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?"
Posted: 16 May 2021   Updated: 1 Jun 2021   Views: 3,340   Rating: 3.43/5    Votes: 3   Popularity: 1.64
Licence: The Code Project Open License (CPOL)      Bookmarked: 2   Downloaded: 50
Please Sign up or sign in to vote.
How to prevent insert for record when maximum number of rows has been reached
Visual Basic
Posted: 28 Jul 2012   Updated: 27 Jul 2012   Views: 9,980   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 19
Please Sign up or sign in to vote.
This is an alternative for "Cumulating values with LINQ"
Posted: 5 Oct 2015   Updated: 5 Oct 2015   Views: 17,722   Rating: 4.93/5    Votes: 11   Popularity: 5.13
Licence: The Code Project Open License (CPOL)      Bookmarked: 19   Downloaded: 524
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.
Posted: 25 Nov 2011   Updated: 24 Dec 2011   Views: 20,850   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.
Posted: 1 Apr 2012   Updated: 1 Apr 2012   Views: 14,200   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

Posted: 5 Nov 2013   Updated: 4 Aug 2017   Views: 192,841   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

Average project rating:

No projects have been posted.

Wendelius
Architect
Europe Europe
Biography provided