SQL Server does not natively support a “LIKE IN” clause. For instance the following example is not valid: Luckily there is a way to achieve this effect. First imagine that you have a stored procedure or function that searches for a specified word that appears anywhere within a Description column. If you had to...
Read more →Your DD-WRT enabled router can be configured to block ads as described in the Ad Blocking article. For non-Micro DD-WRT versions the ad blocking hosts file on the router can be updated automatically by a custom shell script that you then execute as a cron job, all on the router itself. However, the Micro...
Read more →In order to merge split vmdk files into one, you need to use the vmware-vdiskmanager command. However, this is only available if you have VMware Fusion or VMware Workstation installed. VMware Player doesn’t have this. Luckily this little utility can be downloaded separately from the VMware site. It is the 1023856-vdiskmanager-windows-7.0.1.exe.zip attachment that you...
Read more →The following example shows one way how you can remove leading zeroes from a varchar column in SQL Server: Returns:
Read more →The following C# code shows how to make a Progress Bar in a dialog window that can be shown for tasks that run for an undetermined amount of time. Instead of a regular progress bar that progresses from 0 to 100%, this one shows a little indicator that scrolls back and forth, while in...
Read more →The reason why sometimes a grid control shows a big red X and stops working properly is because an unhandled exception has occurred during the control’s OnPaint event. One way to handle this is by extending from the grid control and overriding the OnPaint event so that any exceptions can be handled. Of course,...
Read more →Through Windows’ WMI Service you can find out who the owner is of a file. This is somewhat similar to the user/group owner of a file in UNIX or Linux, as shown in the example below, where the file myfile.txt is owned by user root and group root. With the following AutoIt code, you...
Read more →If you plan on learning a new programming language, one good way to get to know the language better is by using it to solve the computational problems found on the Project Euler site. Currently there are about 385 problems to be solved, however more are added regularly. They start out relatively easy but...
Read more →The standard ProgressBar class provided by the .NET Framework does not have a way to write custom text over the progress bar. However, it can still be achieved by extending from the standard ProgressBar and by implementing your own OnPaint event handler. The other thing to keep in mind is the color of the...
Read more →The following article was originally written back in 2006. The code example below shows you how you can include better mouse control over your web pages, even the right-click mouse event. The example below basically shows you a page with 2 boxes on it. These boxes are called ‘Drag Me 1′ and ‘Drag Me...
Read more →Normally, private methods in a class are not visible to other classes and cannot be executed. However, through reflection, which enables dynamic retrieval of classes and data structures by name, you can still access and execute private methods in another class. Consider the following class, which defines a public method called getValue1 and a...
Read more →Normally when you want a RichTextBox to automatically scroll to the bottom, whenever you add new lines to it, all you need to do is append the new lines with the AppendText() method. However, it seems that the RichTextBox does not always scroll down immediately after calling this method. For instance you’re using a...
Read more →