‘ Find a control in a hierarchy of controls’ Example:’ Dim txtCtl As Control = FindControlRecursive(DataGrid1, “FirstNameTextBox”)Function FindControlRecursive(ByVal ctrl As Control, _ ByVal id As String) As Control ‘ Exit

‘ Return the index in a ListControl given a value’ Example:’ Dim i As Integer = GetIndexFromText(ListBox1, “hellovalue”)Function GetIndexFromValue(ByVal lst As ListControl, ByVal value As String) As _ Integer Return

‘ Select the ListControl element with a given text’ Example: SelectItemFromText(ListBox1, “hello”)Sub SelectItemFromText(ByVal lst As ListControl, ByVal value As String) lst.SelectedIndex = lst.Items.IndexOf(lst.Items.FindByText(value))End Sub

‘ Return the index in a ListControl given a text’ Example:’ Dim i As Integer = GetIndexFromText(ListBox1, “hello”)Function GetIndexFromText(ByVal lst As ListControl, ByVal value As String) As _ Integer Return

‘ EvalFileName ensures that the basename of a file or directory’ conforms to the Microsoft file naming guidelines (see MSDN webpage)’ http://msdn.microsoft.com/library/default.asp?url=/library/en-us/fileio/base/’ naming_a_file.asp” Return value:’ True = Valid basename’ False

The VB’s MkDir function creates a directory in a specified path. If the directory already exists, MkDir raises error 75 (Path/file access error); yet, it raises the same error code

‘ Select the ListControl element with a given value’ Example: SelectItemFromValue(ListBox1, “hellovalue”)Sub SelectItemFromValue(ByVal lst As ListControl, ByVal value As String) lst.SelectedIndex = lst.Items.IndexOf(lst.Items.FindByValue(value))End Sub

Being an avid Access Programmer I have been frustrated with the limitation of VB DropDownLists to using only 1 field as the value. I found a way to simulate/work around

‘ Flip an image on one or both axes. The x and y’ parameters are the coordinates of the upper-left point’ Note: requires Imports System.Drawing.Imaging” Example:’ Dim gr As Graphics

‘ Skew an image by a given amount along one or both axes (the dx and dy ‘ parameters)’ The x and y parameters are the coordinates of the upper-left

‘ Rotate an image by a specified angle (in degrees)’ The x and y parameters are the coordinates of the upper-left point’ Note: requires Imports System.Drawing.Imaging” Example:’ Dim gr As

‘ This routine demonstrates how to create an Enhanced Metafile (EMF) from a ‘ bitmap image, contained in a PictureBox.’ You must use a PictureBox control, since the Image control

‘ Return the date of the Monday for a specified week..’ This function can be tweaked to return any weekday. I use it in Access to’ subdivide reports into weekly

AUTH_TYPE request.getAuthType()CONTENT_LENGTH request.getContentLength()CONTENT_TYPE request.getContentType()DOCUMENT_ROOT getServletContext().getRealPath()PATH_INFO request.getPathInfo()PATH_TRANSLATED request.getPathTranslated()QUERY_STRING request.getQueryString()REMOTE_ADDR request.getRemoteAddr()REMOTE_HOST request.getRemoteHost()REMOTE_USER request.getRemoteUser()REQUEST_METHOD request.getMethod()SCRIPT_NAME request.getServletPath()SERVER_NAME request.getServerName()SERVER_PORT request.getServerPort()SERVER_PROTOCOL request.getProtocol()SERVER_SOFTWARE getServletContext().getServerInfo() HTTP_XXX_YYY Variables of the form HTTP_HEADER_NAME can be accessed using the request.getHeader(Header-Name) Example:

Public Function GetHtmlString(rs)Dim StrHtmlDim FldLimiter,RowLimiterFldLimiter=””RowLimiter=””If Not rs.EOF ThenStrHtml=”” ‘Table Tag’Prefix for 1 col valueStrHtml=StrHtml & “”StrHtml=StrHtml & rs.GetString(2,-1,FldLimiter,RowLimiter)’Trim of the Last StrHtml=Left(StrHtml,Len(StrHtml)-Len(“”))’Close TableStrHtml=StrHtml & “”End IfEnd Function Usage: Response.Write(GetHtmlString(rs))

IN tblTicker table we have following fields: [CompanyID] INT IDENTITY (1,1) [TickerSymbol] [char] (10) NULL [ClassOfShare] [char] (10) NULL We inserted some rows and deleted some from table tblTicker.Now At

This tip is useful when debugging and testing complex stored procedures that have a lot of business logic. It helps to find out exactly what is being returned from a

This technique allows you to delete the contents of a List at the same time you are storing pointers a list. This same approach can be used for maps or

The const keyword in C++ provides a type-safe way to replace some of those #define preprocessor statements that you’re used to writing from C.Whenever you have a value that you

This task is quite common task. However, explicit insertion of values can be unacceptable in many cases?like if you need to insert a lot of values. I’ve found that it’s

When you construct an object using new, you have no control over where it gets created in the heap. What if you want the object to be placed at a