Click here to Skip to main content
14,028,696 members

Articles by Maciej Los (Tip/Tricks: 7)

Tip/Tricks: 7

RSS Feed
No articles have been posted.
No blogs have been submitted.

Average tips rating: 0.00

Database
OLE DB
Posted: 27 Dec 2013   Updated: 3 Jan 2014   Views: 28,550   Rating: 4.65/5    Votes: 9   Popularity: 4.44
Licence: The Code Project Open License (CPOL)      Bookmarked: 9   Downloaded: 1,417
This tip shows how to get data from multiple workbooks using one OledbConnection.
SQL
Posted: 6 Dec 2014   Updated: 9 Dec 2014   Views: 25,933   Rating: 4.15/5    Votes: 4   Popularity: 2.50
Licence: The Code Project Open License (CPOL)      Bookmarked: 7   Downloaded: 0
This tip shows how to use CTE to find character repeated in a string few times.
SQL Server
Posted: 11 Feb 2013   Updated: 13 Feb 2013   Views: 42,010   Rating: 4.96/5    Votes: 9   Popularity: 4.74
Licence: The Code Project Open License (CPOL)      Bookmarked: 13   Downloaded: 2,213
This tip is desired for those who want to list all available SQl Server instances that are in a network.
VB.NET
General
Posted: 19 Jun 2014   Updated: 19 Jun 2014   Views: 11,651   Rating: 5.00/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 6   Downloaded: 187
If you want to know the way you can serialize and deserialize custom class collection, this tip is for you.
VBScript
VBA
Posted: 17 May 2017   Updated: 17 May 2017   Views: 13,231   Rating: 4.00/5    Votes: 5   Popularity: 2.66
Licence: The Code Project Open License (CPOL)      Bookmarked: 3   Downloaded: 0
This is an alternative for "Copy Rows Within Excel Sheets via VBA"
Algorithms & Recipes
General
Posted: 6 Feb 2019   Updated: 6 Feb 2019   Views: 2,050   Rating: 3.40/5    Votes: 2   Popularity: 1.51
Licence: The Code Project Open License (CPOL)      Bookmarked: 4   Downloaded: 0
C# helper class to convert date into words
Third Party Products and Tools
General
Posted: 17 Feb 2019   Updated: 17 Feb 2019   Views: 1,180   Rating: 0.00/5    Votes: 0   Popularity: 0.00
Licence: The Code Project Open License (CPOL)      Bookmarked: 1   Downloaded: 0
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!
No reference articles have been posted.
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!
  1. VB/VBA/VB.NET
  2. C#
  3. C++
  4. SQL
  5. Linq
  6. XML & XSL


Advertise | Privacy | Cookies | Terms of Service
Web02 | 2.8.190419.4 | Last Updated 22 Apr 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid