This code displays the cookies sent by a browser, if any, including any subkeys to those cookies.

The folowing stored procedure will find and replace a string in a table: CREATE PROCEDURE [dbo].[sp_st_FindANDReplaceString]@Tablename varchar(20),@FieldName varchar(20),@FindString varchar(30),@RepalceString varchar(30)ASdeclare @sqlstring varchar(8000)Select @sqlstring = “Update ” + @Tablename + “

A disconnected recordset is a recordset which does not hold an active connection. A fabricated recordset can be viewed as a variation of a disconnected recordset. The variation in the

This program prints out the name and the address (in both textual and numerical forms) of the machine on which its run, using the InetAddress singleton. import java.net.*;public class CurrentHost

All programmers?especially database programmers?require a function that replaces all occurrences of one substring with another string. For example, they need to replace the single quotes in strings passed to an

You can serialize your data quickly by placing it into a PropertyBag object, then reading the PropertyBags Contents property. This property is really a Byte array that is a serial

You might have used line numbering to track error locations, but this technique can be a pain (and ugly) to use for every line. Sparse line numbers help you locate

When the TextMode property of a TextBox control is set to Password, the value you assign to the Text property (either declaratively or programmatically) isn’t actually displayed at runtime, not

‘ Select the specified items (passed as a comma delimited list) in the input ‘ List control (e.g. ListBox, CheckBoxList)’ ‘ Example:’ SetListSelections(CheckBoxList1, “item 3, item 5, item 6”)Sub SetListSelections(ByVal

‘ Return whether a file uploader control has posted a file to the serverFunction HasUploadedFile(ByVal fileCtl As _ System.Web.UI.HtmlControls.HtmlInputFile) As Boolean ‘ to return True the control’s PostedFile must be

‘ Return the HTML code generated by the input ASP.NET server control’ Note: the function only works with server side controls that don’t generate ‘ postbacks and that can be

‘ Show a client-side message box at the next page load’ Example:’ ShowMessageBox(Me, “Order successfully submitted!”)Sub ShowMessageBox(ByVal webPage As System.Web.UI.Page, ByVal message As String) ‘ replace ‘ with ‘, otherwise

‘ Return a comma delimited list of items selected in a List control (e.g. ‘ ListBox, CheckBoxList)” Example:’ Dim selections As String = GetListSelections(CheckBoxList1)Function GetListSelections(ByVal listCtl As _ System.Web.UI.WebControls.ListControl) As

You can make an object appear like a pointer with a smart pointer. If a class overloads the operator ->( ), then any object of that class can appear like

‘ A generic routine that takes an object, an event name, and a list of potential’ delegates to event handlers, and selects the first delegate that matches the’ expected signature

‘ Create a suitable connection object for a given connection string.’ Requires Imports for System.Data, System.Data.Common, System.Data.OleDb,’ System.Data.SqlClient and System.Data.Odbc” Example: Dim cn As IDbConnection = CreateConnection(connStr)Function CreateConnection(ByVal connString As

‘ Reusable routine that save a BLOB field to a file’ Requires Imports for System.Data and System.Data.Common’ Example: BlobToFile(dr, 2, “c:xxxx.bmp”)Sub BlobToFile(ByVal dr As IDataReader, ByVal fieldIndex As Integer, _

‘ Reusable routine that loads a file into a SQL Server’s BLOB.’ Requires Imports for System.Data and System.Data.SqlClient’ (It supports only tables with one key field.)” Example:’ FileToBlob(cn, “pub_info”, “logo”,

‘ Create a suitable DataAdapter object for a given connection object.’ Requires Imports for System.Data, System.Data.Common, System.Data.OleDb,’ System.Data.SqlClient, System.Data.Odbc and System.Data.OracleClient” Example:’ Dim da As DbDataAdapter = CreateDataAdapter(“SELECT * FROM

‘ Create a suitable DataAdapter object for a given connection object.’ Example:’ Dim da As DbDataAdapter = CreateDataAdapter(cn, “SELECT * FROM Titles”)Function CreateDataAdapter(ByVal cn As IDbConnection, _ ByVal sql As

In the following example, the PurchaseOrderKey class implements a composite key for the PurchaseOrderEJB entity bean. The key is composed of two fields, productModel and vendorId, whose names must match

You can override some of the built-in VB keywords with your own version of the function. For instance, FileDateTime is a handy built-in function in VB, but it suffers from

When transforming XML to HTML you often have to create links on your page. Use this syntax to simply this task. Long way: Short way: