Tip Bank

When transforming XML to HTML you often have to create links on your page. Use this syntax to simply this task. Long way: Short way:

CREATE TABLE tblSales (MonthNumber int,MonthName varchar(10) PRIMARY KEY,ProductA INT,ProductB INT,ProductC INT) INSERT INTO tblSales Select 1,’Jan’,5800,5900,5400 union allSelect 2,’Feb’,5750,5950,5500 union allSelect 3,’Mar’,6200,5700,7100 union allSelect 4,’Apr’,6300,5900,5400 union allSelect 5,’May’,5350,5650,5500 SELECT A.*,X.AvgSales

Oracle and SQL Server databases use different date/time resolutions, which poses a problem when you compare times from the two databases: The times will rarely be equal. Solve this problem

Windows applications generally use the registry for storing configuration information. Sometimes, it can be essential to allow users to change the registry key/value and the same needs to be reflected

Here’s an easy way to get OS information using the Windows Management Instrument (WMI): Private Sub getWindowsInfo() On Error Resume Next Dim strComputername As String Dim objWMIService As Object Dim

If you sort a table from a field which has null values, Null values are typically displayed first. Here is a way to display the NULL values at last. Use

‘/// ‘/// Provides static (Shared) methods to find the’/// ImageFormat for a filename or MIME type.’/// Public NotInheritable Class ImageFormatUtils Private Shared codecs() As ImageCodecInfo Private Shared formats As Hashtable

‘ Join a variable number of binary files into a single file” Params:’ – resultFile: the complete path of the result file you want to create’ – sourceFiles: the sequence

If you do presentations/trainings and have to use VS.NET, and actually want your students to see the text on the IDE’s windows and dialog, you’d be better off changing the