devxlogo

Tip Bank

Select Areas Within a Graphics Window

Graphics applications sometimes require users to select a rectangular region of a picture or drawing visually. You need to provide a resizing box manipulated by the pointer at run time

Creating custom help filters

If you open the VS.NET documentation (either from within the IDE or by clicking the respective icon under the Start | Programs| Microsoft Visual Studio 2003 folder) you can use

Get the Drive Serial Number

You can get the serial number of your hard drive, floppy disk, or CD-ROM easily without any additional ActiveX component. First, start a VB project, add a standard module, and

Changing the Column Name Through StoredProcedure Dynamically

Here’s the syntax for the stored procedure: CREATE PROCEDURE [dbo].[RenameColumn] @tblname as varchar(50), @oldcolnameas varchar(50), @newcolname as varchar(50)ASdeclare @tblColname varchar(100)set @tblColname = @tblname +’.’ + @oldcolnameBEGIN TRANSACTIONSET QUOTED_IDENTIFIER ONSET TRANSACTION