Converting Times Between Time Zones

It is becoming increasingly important for any application that works with dates and times to handle differences between time zones. An application can no longer assume that all times can be expressed in the local time, which is the time available from the DateTime structure. For example, a Web page that displays the current time in the eastern part of the United States will lack credibility to a customer in eastern Asia. This topic...

Read More...

A Visual Explanation of SQL Joins

A Visual Explanation of SQL Joins An SQL JOIN clause is used to combine rows from two or more tables, based on a common field between them. The most common type of join is SQL INNER JOIN (simple join). An SQL INNER JOIN return all rows from multiple tables where the join condition is met. Assume we have the following two tables. Table A is on the left, and Table B is on the right. We'll populate them with four records each. id...

Read More...

How to create a directory or folder (Microsoft Windows XP, Vista, 7 and 8 )

Microsoft XP,7 and 8 users can create a folder several different ways, below is a listing of the different methods to create a folder. My Computer Open My Computer or Windows Explorer Open the drive or folder you wish to create a folder on, for example, the C: drive. If you do not wish to create a folder in the root directory, browse to the location you wish to create a folder, and then click File, then Folder; or right-click...

Read More...