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

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

When you install a new version of the VS.NET IDE, you lose the settings you used in the older version, such as project’s and solution’s defaults, debugging options, fonts and

‘ Return a reference to the control that caused the last postback,’ even from the Page_Load event!’ It requires in input a reference to the posted-back page’ (this is necessary