‘ Restore the specified database.’ Note: requires Imports System.Data.SqlClient” Example:’ Dim connString As String = “server=(local); user id=sa; password=; ‘ Database=master;”‘ Try’ RestoreDatabase(connString, “MyTestDB”, “D:MyTestDbBackup.bak”)’ Catch ex As Exception’ MessageBox.Show(ex.Message)’
‘ Create a SQL Server database with the specified name.’ If the second parameter is True and a DB with the same name is already ‘ present,’ it is dropped
The DataSet is a container of multiple DataTables, and it allows to create parent-child relationships between two tables, as shown below: ‘ create a relationship between the Categories and the
s an open source add-on for the Apache Jakarta Struts Framework (or Struts), StrutsCX has its roots in a pure XML- and XSLT-based, multi-language and multi-layout project. With StrutsCX you
wap() is one of those tricky algorithms that has several implementations, each of which offers its own advantages and disadvantages. In the following sections I will show why familiarity with
Introductionack in January of 2002, I was thumbing through the December issue of elementkjournal’s, “Inside Microsoft Access”, when I came across the MSDN article entitled, “Graphically Display Percentages on Forms
This class is designed to make working with the ListView control much easier, primarily when using it in Report view. There are various properties and methods which make for easy
he .NET framework makes it easy to start code execution on a new thread?improving user interface design by letting you execute lengthy procedures on one thread while leaving the UI
‘ Returns a TimeSpan for the interval of time the system has been up.’ EXAMPLE:’ Dim ts As TimeSpan = GetSystemUpTime()’ Console.WriteLine(String.Format(“The system’s up time is: {0} days, {1} ‘
‘ Returns the input string decoded from base64Private Function DecodeBase64(ByVal input As String) As String Dim strBytes() As Byte = System.Convert.FromBase64String(input) Return System.Text.Encoding.UTF8.GetString(strBytes)End Function Related Posts Knowing the Sign of
‘ Returns a hashtable with the key-value pairs extracted from the querystring ‘ of the specified url’ EXAMPLE:’ Dim ht As Hashtable = GetUrlParameters’ (“http://www.mysite.com?param1=123¶m2=¶m3=234”)’ ‘ print the key=value pairs
‘ Returns the input string encoded to base64Private Function EncodeBase64(ByVal input As String) As String Dim strBytes() As Byte = System.Text.Encoding.UTF8.GetBytes(input) Return System.Convert.ToBase64String(strBytes)End Function Related Posts Red Hat, Samsung Sign
‘ Downloads the file at the specified URI, and saves it where specifiedSub DownloadFile(ByVal uri As String, ByVal destFile As String, _ Optional ByVal username As String = Nothing, Optional
Usually, you set attributes in a session and the attributes are available through out the session. If you want to limit the scope of an attribute to just a request,
When you need to change the parameters or name of a class or method you developed use the javadoc @deprecated tag and leave the old code. This allows other to
The standard Java library contains a host of valuable methods. Many of these are hidden away, such as Beans.isInstanceOf.This method belongs to the java.beans.Beans class. However, it’s an object version
Say you need to change the behavior of your Java application depending on some parameters read from a properties or ini file (like batchMode, debugMode, etc.). You want to turn
If your application includes .properties files or images and you want to load them without hard-coding their location, store the files in the class path. Classes are stored in archive
When writing multithreaded applications in the Windows Environment, you have two options for creating new threads: the C-runtime function _beginthread (and _beginthreadex) or the WIN32 API CreateThread(). If the thread
Need a quick and dirty way to exponentiate integers? Or perhaps you are working on a number library of your own. This will work in all cases. templateTYPE power(TYPE x,
Using the ISNUMERIC() and ISDATE() functions, you can check the required column’s data type validity. If the column passes the data type validity check, it will return a 1. If
t’s daunting to come up with a topic of interest to a large group of readers?and then to write about it well. I know it’s impossible to please everyone, but
xtensible Stylesheet Transformations, or XSLT, has received decidedly mixed reviews from developers. Although XSLT has many evangelists it has its detractors as well. Because of some concepts, such as static
When compiling a program, the compiler adds some optimizations that may cause your application to misbehave. For example consider the following code: // To avoid threads waiting on the critical
The const_cast operator takes the form: const_cast (expr) It is used to add or remove the “const-ness” or “volatile-ness” from a type. Consider a function, f, which takes a non-const
In this application, we will show you how you should be able to use the GPSOne features built into the BREW SDK to perform geo-location on BREW-based phones… once BREW
I have found the need to do multiple tests on dissimilar variables and objects with any failing test causing an action. Multiple embedded If…Then…ElseIf…EndIf statements are awful to look at
When an array is declared as a type where each element occupies a lot of memory (such as a complex user-defined type), sorting the array can become unacceptably slow. To
Believe it or not, you can override VB Related Posts Unleashing Hyundai Ioniq 6 N: Electrifying PowerhouseFirst Date with Visual Studio 2015Biden administration considers downgrading marijuana classificationUse ngSwitch Directive to
VB6 introduced a new built-in function, CallByName(), as a member of VBA.Interaction. It lets you reference an object Related Posts Get the Size of a File in FTP with C#Cisco