GetOleDbType – Retrieving the OleDbType for the specified system type
‘ Return the OleDbType that represents the specified system type’ This is particularly useful when you have a DataTable and want to create a ‘ OleDbParameter for onw of its
‘ Return the OleDbType that represents the specified system type’ This is particularly useful when you have a DataTable and want to create a ‘ OleDbParameter for onw of its
‘ Deserialize an object from a file in binary format’ It can handle types that the SOAP serialization can’t’ Requires:’ Imports System.IO’ Imports System.Runtime.Serialization.Formatters.BinaryPrivate Function LoadBinaryData(ByVal path As String) As
‘ Return the HTML code for the specified Color’ Example: MessageBox.Show(Color2Html(Color.Red)) ==> #ff0000Function Color2Html(ByVal clr As Color) As String Return “#” & clr.ToArgb().ToString(“x”).Substring(2)End Function Related Posts Oracle, Salesforce, Microsoft lead
Printing con be quite difficult in VB.NET (or any other .NET language), especially if you not only have to print plain text, but also tables, images, bulleted lists, text with
harting and reporting can involve a lot of work. Numerous vendors have made a business out of selling their third party charting and reporting tools. High-end vendors such as Microstrategy,
hen building complex desktop applications, different individuals or groups of developers often need to collaborate. On some projects, you can separate the layers of the system and assign different individuals
In software design, you should plan ahead the interface of a class hierarchy to make sure that all related concrete classes share a common interface. This can be achieved by
++ creators introduced Runtime Type Information (RTTI) more than a decade ago. Yet even today many programmers arent fully aware of its benefits and perils. In the following sections, I
omewhere north of a million. That, last time you counted, is the number of lines of C and C++ code keeping your organization running. And that is the number that
kay, maybe you aren’t up to speed on the features of BREW version 1.x, or perhaps you’ve not yet even investigated this technology. So, before we jump into the improvements
arlier this year, Amazon quietly exposed a set of Web services that can be used to allow any application to find and display Amazon product information. The Web services are
s a big fan of atmosphere and thematic environment, I queued up the “Blade Runner” Soundtrack on my computer. Vangelis’ ghostly ambience, like the subject of this editorial, is futuristic
hile writing an earlier article (see “Build a Touch Utility with .NET”), which describes a console application to set file dates and times, I struggled with the problem of parsing
year ago, if someone had asked me to develop an interactive Web site, I’d have said, “Sure, me and what magic genie?” Fortunately, for those of us with little expertise
Globally unique identifiers (GUIDs) distinguish hardware, software, and users. Originally, Microsoft designed the GUID value for use with ActiveX controls; Windows uses a 128-bit GUID to identify ActiveX controls. A
ne of the ever-present challenges facing mobile application developers is maintaining the look and feel of applications across different devices. There is an untold number of mobile devices such as
am sure you have already found out why you should be wary of static, application-global and module-global variables in COM+ components written in VB. As for me, one wonderful day
The following routines convert a numeric value into a string that represents the number, and vice versa. They are useful for reading data written by QuickBasic programs, because the QuickBasic
I happened to come across a serious problem when installing my own software with Visual Installer 1.1: the installation of my product on Windows 98 computers caused a system crash
‘ Return a collection of strings that identify the installed versions of the ‘ .NET Framework’ Note: this function require the EnumRegistryKeys and EnumRegistryValues ‘ functions’ Example:’ Dim version As
‘ Return a Boolean value indicating whether the .NET Framework is installed’ Note: this function require the CheckRegistryKey functionsFunction IsDotNetFrameworkPresent() As Boolean Const HKEY_LOCAL_MACHINE = &H80000002 IsDotNetFrameworkPresent = CheckRegistryKey(HKEY_LOCAL_MACHINE, _
If you install a COM+ application proxy on a client and open its Properties dialog, you’ll see that the field “Remote Server Name” is set to the server where you
Here it is some code that shows how to use reflection to dynamically set an event handler for a class’ event. Sub TestSub() ‘ create a Person Dim pe As
Some control events provide the mouse pointer’s current position within the control’s client area; others provide only the screen coordinates of the mouse pointer (the same as returned by Cursor.Position).
et’s face it. Caching is a fancy was of saying that you are going to save some type of data somewhere. In the n-tier web application model, your tiers are
‘ 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 Related Posts T-SQL FORCEPLANWhat Is Website
‘ 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