‘ 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: Related Posts Mother’s e-reader accessory
TML form handling consists of a set of named form controls on an HTML page and a Submit button for sending the information contained by the controls to a server,
CREATE TABLE tblSales (MonthNumber int,MonthName varchar(10) PRIMARY KEY,ProductA INT,ProductB INT,ProductC INT) INSERT INTO tblSales Select 1,’Jan’,5800,5900,5400 union allSelect 2,’Feb’,5750,5950,5500 union allSelect 3,’Mar’,6200,5700,7100 union allSelect 4,’Apr’,6300,5900,5400 union allSelect 5,’May’,5350,5650,5500 SELECT A.*,X.AvgSales
Oracle and SQL Server databases use different date/time resolutions, which poses a problem when you compare times from the two databases: The times will rarely be equal. Solve this problem
Windows applications generally use the registry for storing configuration information. Sometimes, it can be essential to allow users to change the registry key/value and the same needs to be reflected
he Java Data Objects (JDO) 1.0 specification, accepted in May 2002, was the first standard, data store-neutral specification designed specifically for Java object persistence. Java developers already had many persistence
n standard C++, the initialization order of objects with static storage type that are declared in separate translation units is unspecified. If, for instance, a constructor of object A takes
efore I turned 18 and graduated from high school, I can’t recall ever enjoying a quiz. But somehow these days I find them hard to resist. Whether they’re silly and
Here’s an easy way to get OS information using the Windows Management Instrument (WMI): Private Sub getWindowsInfo() On Error Resume Next Dim strComputername As String Dim objWMIService As Object Dim
If you sort a table from a field which has null values, Null values are typically displayed first. Here is a way to display the NULL values at last. Use
ive years ago, I reviewed Borland’s C++ Builder 4.0 and I was so impressed with it that I have used it as my C++ IDE ever since! So I jumped
ecently, “Paul” wrote to the xml.general group asking: I have the following XML element: Hello John, my name is Paul. I would like to tell you something. The element can
ava Messaging Service (JMS) is an excellent message-queuing specification and also a pretty good publish-subscribe solution. To determine the best JMS implementation for messaging at your site, you will have
un Microsystems’ Java Message Service (JMS) is about to have a huge impact on the messaging middleware business. This venerable industry, which provides the plumbing for transaction processing and data
ne of the VB6 features that are no longer supported in VB.NET is the automated creation of control arrays by simply copying an existing control as many times as required
‘ Join a variable number of binary files into a single file” Params:’ – resultFile: the complete path of the result file you want to create’ – sourceFiles: the sequence
‘ Return a reference to the control that caused the last postback,’ even from the Page_Load event!’ It requires in input a reference to the posted-back page’ (this is necessary
‘/// ‘/// Provides static (Shared) methods to find the’/// ImageFormat for a filename or MIME type.’/// Public NotInheritable Class ImageFormatUtils Private Shared codecs() As ImageCodecInfo Private Shared formats As Hashtable
When you install a new version of the VS.NET IDE, you lose the settings you used in the older version, such as project’s and solution’s defaults, debugging options, fonts and
If you do presentations/trainings and have to use VS.NET, and actually want your students to see the text on the IDE’s windows and dialog, you’d be better off changing the
hen you think of using data binding in .NET it’s always to structured data sources such as a DataSet, array, list etc. But in reality, you aren’t limited to data
ake a look at the applications you deal with on a regular basis. Regardless of the platform or GUI that you use, or the programming language used to create them,
he first article of this series, “Set Up Passport Authentication in ASP.NET“, discussed using the authentication features of Microsoft Passport in ASP.NET applications. This second and final installment demonstrates how
TML, that universal and egalitarian documentation format, is now 13 years removed from birth and 10 years removed from the lab. Unless pretenders such as Adobe’s PDF quicken their pace,