If you take a look at the MSIL as it’s being executed you’ll see that it doesn’t compile down to the exact same code. When you use IsNothing() it actually makes a call to that method as opposed to just evaluating the expression. The reason I would tend to lean towards using “Is Nothing” is … Read more
It sounds like you might be looking for a “NaturalSort” – the kind of display File Explorer uses to order filenames containing numerals. For this you need a custom comparer: Imports System.Runtime.InteropServices Partial Class NativeMethods <DllImport(“shlwapi.dll”, CharSet:=CharSet.Unicode)> Private Shared Function StrCmpLogicalW(s1 As String, s2 As String) As Int32 End Function Friend Shared Function NaturalStringCompare(str1 As … Read more
PASSWORD is a reserved word in Access SQL, so you need to wrap that column name in square brackets. You really should use a parameterized query to protect against SQL Injection and generally make your life easier. Try something like this SQL = “INSERT INTO [Accounts] ([StudNo],[Password],[FirstName],[LastName],[YrandSec]) ” & _ “VALUES (?, ?, ?, ?, … Read more
I would first create an OleDbCommand object and use this object to create a OleDbDataAdapter Imports Data.OleDb dim cmd as new OleDbCommand cmd.Connection = con cmd.CommandType = CommandType.Text cmd.CommandText = “SELECT * FROM tblContacts where Name=? and City=?” ‘ Here we add the parameters in the same order they appear in the ‘ CommandText. The … Read more
You have to use a ColorMatrix to blend images. Here’s a C# control I wrote a while ago, it shows you the basic code you’ll need. Not VB.NET code but, hey, you didn’t try real hard either: using System; using System.Drawing; using System.Drawing.Imaging; using System.Windows.Forms; public class BlendPanel : Panel { public BlendPanel() { DoubleBuffered … Read more
These sets of methods allow to print the content of a ScrollableControl to a Bitmap. A description of the procedure: The control is first scrolled back to the origin ([ScrollableControl].AutoScrollPosition = new Point(0, 0) (an exception is raised otherwise: the Bitmap has a wrong size. You may want to store the current scroll position and … Read more
There’s a shortcut for limited (ie. simple) math expressions by using the DataTable.Compute method. Obviously, this isn’t robust (limited functionality) and feels hackish to misuse the DataTable for this purpose, but I figured I would add to the current answers. Example: var result = new DataTable().Compute(“3+(7/3.5)”, null); // 5 “Sin(90)” wouldn’t work with this approach. … Read more
One option is display the url in the message box, along with a message and provide the help button that takes you to that url: MessageBox.Show( “test message”, “caption”, MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, 0, ‘0 is default otherwise use MessageBoxOptions Enum “http://google.com”, “keyword”) Important to note this code cannot be in the load event of the … Read more
You can escape (this is how this principle is called) the double quotes by prefixing them with another double quote. You can put them in a string as follows: Dim MyVar as string = “some text “”hello”” hello” This will give the MyVar variable a value of some text “hello” hello.
Source : Here Usage: To create the hook Private WithEvents kbHook As New KeyboardHook Then each event can be handled: Private Sub kbHook_KeyDown(ByVal Key As System.Windows.Forms.Keys) Handles kbHook.KeyDown Debug.WriteLine(Key.ToString) End Sub Private Sub kbHook_KeyUp(ByVal Key As System.Windows.Forms.Keys) Handles kbHook.KeyUp Debug.WriteLine(Key) End Sub Keyboard Hook Class : Imports System.Runtime.InteropServices Public Class KeyboardHook <DllImport(“User32.dll”, CharSet:=CharSet.Auto, CallingConvention:=CallingConvention.StdCall)> _ … Read more