Tip Bank

You can easily execute a SQL Server 7.0 Data Transformation Services (DTS) package from VB remotely: Create a DTS package. It can be an import from Excel into SQL Server.

When creating a project or Web page, you sometimes need to use characters not included on your keyboardfor example,

You use quotation marks in VB to define strings, but how do you include them in your output? Use whichever of these methods works the best for you: Dim strUseChr

Users often complain that listboxes don’t have the same multiple keypress search capabilities as treeviews and other objects. But you can simulate this behavior by adding code to a form

You can move a transaction log using SQL Server stored procedures. Simply detach the database, move the log file, then reattach the database. For example, to move the pubs database

VB’s Add File dialog supports only a single selection of code modules or OCXs, so you must painstakingly select each individual file and control one at a time. One of

Converting an integer to a string is a very common programming task. The most popular method for doing this are to use either String.valueOf(int) or Integer.toString(). Which one is better

Say you want to store data for temporary use in a program. You will have to declare variables to input the data. Luckily, declaring variables in C++ is very easy.

Typically, you read and process a text file by using a loop and VB’s Line Input statement: Do While Not Eof(1) Line Input #1, myStringVar$ ‘ process the line hereLoop