VB 2005: Quick introduction to the world of .NET

Before .NET came, COM (Component Object Model) was the norm.  You build COM objects to make your code reusable and so that you can fit them in a 3-tier or n-tier architecture.  This architecture was called or marketed by Microsoft as DNA (Distributed interNet Architecture).  It is just a way to architect or build distributed …

Continue reading VB 2005: Quick introduction to the world of .NET

Advertisements

Access 2003: A journey towards mastering Access 2003

  Access is the first database that I worked on, not SQL Server.  I started with version 97.  Now with version 2007 available, you ask why master 2003 when there is already 2007.  For one it's still relatively new and companies especially small to mid-size ones where I cater to most, don't jump hastily to …

Continue reading Access 2003: A journey towards mastering Access 2003

VB 2005: A journey towards mastering Visual Basic 2005

My last project involved using Visual Basic 2005.  This is the latest version of VB.NET.  I have used Visual Basic before starting with version 4.0.  In fact I got certified a long time ago, November 2001 to be exact, as a Microsoft Certified Professional (MCP) by passing the exam Designing and Implementing Desktop Applications with …

Continue reading VB 2005: A journey towards mastering Visual Basic 2005

SLQ Server 2005: Operators you can use in the WHERE clause

Besides the standard comparison operators (=, >, <, etc.), the boolean operators (AND, OR, NOT) and the BETWEEN operator, you can also use LIKE, IN, ALL, ANY, SOME, and EXISTS. LIKE Use this when you want to match the value of a column to a string with wildcard characters specified after this keyword.  You use …

Continue reading SLQ Server 2005: Operators you can use in the WHERE clause