Many developers mistakenly believe that any error inside a transaction will make the transaction fail and automatically rollback. However, this is true only for fatal errors, such as most errors

‘ this should be a module-level or global variable, so that’ Word is instantiated only onceDim MSWord As New Word.Application’ check the spelling of a word” returns True if the

You may retrieve a few important information about a connection to SQL Server by querying the server through appropriate @@ global variables. For example, the following routine takes an ADO

SQL Server’s views are updateable, but it is possible that when you insert a new record or update an existing record, the record added or modified doesn’t logical belog to

‘ Getting the HTML code of any page on the web’ NOTE: requires the Microsoft XML library’ Example:’ Text1.Text = GetHtmlPageSource(“http://www.vb2themax.com/Default.asp”)Function GetHtmlPageSource(ByVal URL As String) Dim objHTTP As New XMLHTTP

Private Declare Sub CopyMemory Lib “kernel32” Alias “RtlMoveMemory” (dest As _ Any, source As Any, ByVal Bytes As Long)’ Uncompress a block of data compressed with RLECompress” Returns TRUE if

At times you may need to swap the values of two columns of the same SQL Server table. For example, suppose that you realized that the fname column of the

The SQL language includes the SUM() aggregate function, that evaluates the sum of all the values in a given column, but it doesn’t include a PROD() function that evaluates the

Private Declare Function SystemParametersInfo Lib “user32” Alias _ “SystemParametersInfoA” (ByVal uAction As Long, ByVal uParam As Long, _ ByRef lpvParam As Any, ByVal fuWinIni As Long) As LongConst SPI_SETDESKWALLPAPER =

At times you may need to verify that the VB IDE is the current process. This is necessary, for example, when you are notified that the user has presses a

‘Check if the specified OLEDB Provider is installed and registered correctly”Example: check the Jet 4.0 OLEDB Provider’MsgBox “The specified OLEDB provider ” & ‘ IIf(CheckOLEDBProvider’ (“Microsoft.Jet.OLEDB.4.0”), “does”, “does not”) &

Printing is one of the things that you can’t do directly from withing ASP: to have a printout of your data from ASP you must instantiate a COM component –

When you use a COM or COM+ from a .NET application and then you set the object reference to Nothing (or let it go out of scope), the object isn’t

‘ get the IE installation path, or a null string if it isn’t installed” NOTE: requires the GetRegistryValue routineFunction InternetExplorerPath() As String Const HKEY_LOCAL_MACHINE = &H80000002 ‘ get the path

The Slider control has a capability that you might ignore: you can assign its SelectRange property to True to enter Select Range mode, during which the user can use the

One of the most effective optimization techniques consists of caching data inside Application or Session variables. However, you should pay attention to how you reference to the elements in those

‘ Concatenate the input strings, and return the resulting string. The first ‘ input string is used as a separator.” Example:’ Dim i As Integer = 4′ Dim d As

In VB6 there was no easy way to create multiline tooltips for form controls, you necessarily had to resort to API tricks. And it was probably just not worth the

To add an image as an embedded resource in a Windows Forms application, add the image file to the project with Project | Add Existing Item. Then select the file

When you start developing an application, the first thing you do in VS.NET is creating a new project and selecting its type: Windows Forms application, Class Library etc. However, it

If you have a string variable that should specify a date (asked in input to the user, for example), you can parse the string and get a Date variable by

You can know the state of the Shift, Alt and Control keys at any time, not just from inside a Keyxxx event. The shared property Control.ModifierKeys returns a bit coded