When connecting to a database, you should check for errors and return a descriptive user-friendly error message. This code calls an error handler routine after connecting to the database. If

Regular Expressions provide a very powerful and easy method of client side validation. They are also both supported by IE and Netscape. It takes a lot less code, and works

In XSL: ‘define parameter name and set default value In ASP: ‘set xsl objectDim xslFile, xslDocxslFile = “MyXsl.xsl”Set xslDoc = Server.CreateObject(“Msxml2.DOMDocument”)xslDoc.async = falsexslDoc.load(Server.MapPath(xslFile))’pass parameterset param=xslDoc.selectSingleNode(“//xsl:param[@name=’loginName’]”)param.setAttribute “select”,”‘Bill'”

.NET strings are objects, so what you store in a String variable is actually a reference to a String object allocated in the managed heap. Even though the VB.NET compiler

You can compare strings in many ways under VB.NET: by using the = operator (or another comparison operator), with the Equals method (which the String class inherits from System.Object), or

The .NET Framework enforces secuity at several levels. For example, assemblies downloaded from the Internet have very limited permissions (especially after installing the Service Pack 1 of the Framework). This

VB6 developers can use the App.PrevInstance property to check whether there is another instance of the same process already running on the current machine. This property isn’t available any longer

While you can access individual pixels of a bitmap by means of the GetPixel and SetPixel methods of the Bitmap object, in practice you seldom want to use these methods,

It is a common feature in an application to require the current date time to be displayed in a text field or something similar.This can be done easily in PalmOS

‘****************************************************’Written By KNR’Excel Sheet Reading’Read Excel File Using ADO’You can use Microsoft EXCEL Driver’****************************************************Public Function Read_Excel(ByVal sFile As String) As ADODB.Recordset On Error GoTo fix_err Dim rs As ADODB.Recordset Set

Shrinking a transaction log in SQL Server can be tricky, especially if you need it shrunk ASAP. You could use DBCC SHRINKFILE() to shrink it, but it will not shrink

You can easily connect to a MS Access database by using JDBC. First, you need to set up the data source for your MS Access database using the ODBCAdministrator. You

This example code extracts the content of a zip file (the name of the zip file is supplied in args[0]). First, open the zip file using ZipFile class, then loop

Applications that allow editing of large, structured documents such as code listings might often benefit from the ability to track positions in the document as it is edited. Typically, recording

Sometimes the provided Swing cursor types just don’t meet the needs of your application. In those cases, you may want to consider creating your own, completely customized cursor. To add

Sometimes you want to make sure that you will have only one object of a specific class in your application. There is a simple technique for doing this. This example

Sometimes come across a situation where you need to swap two variables. Below is the code that will let you swap two pointers. Say that p and q point to

We can execute any member function or any other execution before main() function by using: “#pragma startup”.Syntax: #pragma startup [priority]//without semicolon Example: #includeclass CL{public: //A constructor CL(){ cout ” The

The multiplication operation for integer numbers is implemented in the processor as repeated additions. The number of additions can be reduced by considering the representation in base 2 of the

Binding a DataGrid – or any other data-aware control – to a DataSet or a DataTable at runtime isn’t difficult: you just have to assign the DataTable to the DataGrid’s

As you might have noticed, the Add Reference dialog in Visual Studio displays all the assemblies in the GAC, which brings up the following question: is there a way to

It often happens that you need to swap the operands of an assignment. For example, say that you have this set of assignments: p1.FirstName = m_FirstNamep1.LastName = m_LastName and later

Thanks to Visual Studio.NET macros, it is quite simple to automate the task of transforming a Public field into a Property with the same name that accesses a private field

When you’re working with the Visual Studio .NET code editor, typing a Try keyword plus the Enter key automatically creates the End Try statement. The following simple macro does something

Nothing beats ILDASM when it’s time to understand what your VB.NET or C# compiler actually emits. In this case you should prepare a desktop shortcut to ILDASM so that you

Persisting an array of data in a SQL Server DB is usually considered quite difficult. The common solution is to use a master detail table, but this leads to a

‘ Download the HTML source code at the specified URL’ You can optionally specify the username/password credentials,’ in case the page uses Basic Authentication’ Returns a null string if any

The Process class provides all you need to create a command-line utility that lists all the processes running on the system and all the related information. This utility is therefore