Since 1998, DevX has helped people start businesses, build websites, and provide enterprise technology to people globally. Interviewing the likes of Microsoft’s co-founder, Steve Ballmer, the publication brings comprehensive, reliable, and accessible insights to the Internet.
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,
Visual Basic includes the Immediate If function (IIf), but VBScript (VBS) does not. However, you can copy this code to VBS to allow the IIf function to be used: ‘VB
This is a very straightforward loop comparing every element in the array with the key. As soon as an equal value is found, it returns. If the loop finishes without
ngo is an independent consultant, developer, author, and trainer based in Vienna, Austria. His books “Advanced .NET Remoting” and “Advanced .NET Remoting in VB.NET” were published by Apress in 2002.
‘ This class loads an animated image and gives access to all its internal ‘ frames as Bitmap objects” Example:’ ‘ load the animation and extract its frames’ Me.Cursor =
‘ Convert a bitmap to greyscale – the function returns a new bitmap,’ it does not directly modify the input image.’ Note: requires the GetGreyScale function” Example:’ Dim bmp As
‘ Retrieve the number of frames contained in the specified image. For non-‘ animated images the function returns 1” Example:’ Dim frameCount As Integer = GetAnimationFrameCount(“D:sample.gif”)Function GetAnimationFrameCount(ByVal imgPath As String)
‘ Convert a color to greyscale’ Example: Me.BackColor = GetGreyScale(Color.Red)Function GetGreyScale(ByVal col As Color) As Color Dim greyValue As Integer = CType(col.R * 0.3 + col.G * 0.59 + col.B
‘ Return the format of the input image, according on its extension’ Example: Dim imgFormat As System.Drawing.imaging.ImageFormat = GetImageFormat’ (“D:sample.gif”)Function GetImageFormat(ByVal imgPath As String) As _ System.Drawing.imaging.ImageFormat imgPath = imgPath.ToLower()
