May 2012 – James Software Development Corner

Microsoft Visual Studio / Active Reports 6 – How to sort your collections using IComparer

Put this class in your solution. Change ‘[object name of your collection]’ to be the name of your object that defines your collection.

Public Class SimpleComparer
Implements IComparer(Of [object name of your collection])

    Private _propertyToSort As String
    Private _sortOrder As

…

SQL Server – Select column data from multiple rows, and string together in one row and in one column

Let’s say you have 5 rows in a table. Column1 is populated for 4 out of the 5 rows with the following data:

599
abc
xyz
456

The following SQL will provide the results as such:

599, abc, xyz, 456…