Source Code

the Source of your life is my code

[SQL] SQL Server instances installed on a machine

Two brief solution for the goal. Inside the search field from your taskbar, enter cmd. Then, click on the Command Prompt result. In the windows console enter sqlcmd -L like this: this is my result: Another way for the goal:... Continue Reading →


[SQL] How to get cumulative sum

Do you want to get the cumulative sum but do not know how to do it? I know and use one of these three ways The fist one: The second one: and as last: Result: ID quantity CumulativeSumValue 1 2... Continue Reading →

[SQL] Select,Update and Delete Duplicate rows

In this post we will show you, how to Select, Update or delete the duplicate rows you replace YourTab with Your Table Name and after “PARTITION BY” FirstColumn,SecondColumn My example Table ID FirstColumn SecondColumn ThirdColumn 1 aaa 2 a 2... Continue Reading →

ExecuteStoreQuery how to use it

ExecuteStoreQuery, executes a query directly against the data source and returns a sequence of typed results. Calling the ExecuteStoreQuery method is equivalent to calling the ExecuteReader method of the DbCommand class, only ExecuteStoreQuery returns entities and the ExecuteReader returns property... Continue Reading →

Telegram Send a Smile

The smile consists of hexadecimal digit code, in this post, I show you how to use this hexadecimal digit and how to make to Smile your bot 😀 , but before reading this post, you must reading, this post and... Continue Reading →

[VB.NET] Moving some files with the same extension

In this Brief code I show you how to move all file with a desiderate extension.

How to format XML data in Notepad++

In this Post I show you how to install XML plugin and how to use it Open Notepad++ and show Plugin Manager Select XML Tools and click Install Open your desiderate xml file: and click CTRL+SHIFT+ALT+B or select Pretty Print(XML... Continue Reading →

Get UNC path of a network drive

UNC, it is acronym of the Universal Naming Convention is the naming system used in Windows for accessing shared network folders on a local area network I use this code to obtain UNC path from local Name drive path: Create... Continue Reading →

How to fix Error 481: Invalid Picture

If your Application shows you Error 481, close it and click Windows+R to show the "RUN" box and type %Temp% like the following Picture: and click ok, it will open Temp Directory, now find the oldest files and delete them.... Continue Reading →

Blog at

Up ↑