Click here to Skip to main content
14,934,527 members

Articles by Maciej Los (Tip/Tricks: 7)

Tip/Tricks: 7

RSS Feed

Average article rating:

No articles have been posted.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.39

Containers
Docker
Posted: 17 Feb 2019   Updated: 17 Feb 2019   Views: 4,811   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
Please Sign up or sign in to vote.
This tip is for those who have installed PostgreSQL server on QNAP NAT server in Container Station (docker) and want to enable remote connection to that server. Note: NAT server is over the router!
Database Development
SQL Server
Posted: 11 Feb 2013   Updated: 13 Feb 2013   Views: 50,814   Rating: 4.96/5    Votes: 9   Popularity: 4.74
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   Downloaded: 2,425
Please Sign up or sign in to vote.
This tip is desired for those who want to list all available SQl Server instances that are in a network.
Productivity Apps and Services
Microsoft Office
Posted: 27 Dec 2013   Updated: 3 Jan 2014   Views: 34,608   Rating: 4.65/5    Votes: 9   Popularity: 4.44
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   Downloaded: 1,524
Please Sign up or sign in to vote.
This tip shows how to get data from multiple workbooks using one OledbConnection.
Posted: 17 May 2017   Updated: 17 May 2017   Views: 22,733   Rating: 4.00/5    Votes: 5   Popularity: 2.80
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
Please Sign up or sign in to vote.
This is an alternative for "Copy Rows Within Excel Sheets via VBA"
Programming Languages
C#
Posted: 6 Feb 2019   Updated: 6 Feb 2019   Views: 4,734   Rating: 3.55/5    Votes: 3   Popularity: 1.69
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
Please Sign up or sign in to vote.
C# helper class to convert date into words
SQL
Posted: 6 Dec 2014   Updated: 9 Dec 2014   Views: 36,340   Rating: 4.15/5    Votes: 4   Popularity: 2.50
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
Please Sign up or sign in to vote.
This tip shows how to use CTE to find character repeated in a string few times.
Visual Basic
Posted: 19 Jun 2014   Updated: 19 Jun 2014   Views: 16,191   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 236
Please Sign up or sign in to vote.
If you want to know the way you can serialize and deserialize custom class collection, this tip is for you.

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

Maciej Los
Team Leader
Poland Poland
I'm a lawyer, teacher/trainer and author of VBA programming book (only polish version). Programming is my hobby and the source of extra earnings!
  1. C#
  2. SQL
  3. Linq
  4. VB/VBA/VB.NET
  5. XML & XSL


If you want to contact me... find me on LinkedIn.