Do Not Use the * with the SELECT Statement in Production Code
When * is used in a select query, it returns all the columns in a table. This approach can be used in a development or testing environment, but it should
When * is used in a select query, it returns all the columns in a table. This approach can be used in a development or testing environment, but it should
Create one class similar to the following, add codes within the static block, and run the application. For example: public class A{ static void displayMe() { System.out.println(“I’m inside display Me
Say you want to have several classes-modifiers, and you want to execute a certain virtual function for each of them. The ideal solution is to create an abstract class with
Dynamic SQL queries allow users to create statements on the fly using parameters or variables. The EXECUTE (EXEC) statement is used to implement dynamic SQL solutions in the stored procedure.
If you want to force a class to be abstract (meaning you can’t actually create an instance of it), but don’t have any pure virtual functions to do it, you
or all the functional enhancements that .NET brings to a developer’s world and the excitement one might be feeling about putting these advances into practice, the truth is that this
All Web Forms controls, and the page itself, expose the EnableViewState property, a boolean that says whether the current value of the control must be saved in the __VIEWSTATE hidden
A few Web Forms control expose the AutoPostBack property, which makes it possible to start a postback when the user clicks on these controls or changes their contents. By default
In classic ASP, the only way to preserve information – for example, the value of a variable- – between consecutive client requests is by means of Session variables, cookies, or
During a page postback, the page is redrawn by default and users see a short but annoying flickering. Worse, the scroll position isn’t preserved during postbacks (the page scrolls to
In any decent sized application, one of the most common activities is string manipulation at one level or another. One of the most common problems with string manipulation is the
swap(int & a, int & b){a ^= b;b ^= a;a ^= b;}
Some of the most irritating and difficult-to-trace bugs are the ones relating to uninitialized or inaccessible memory locations. This problem becomes especially severe when dealing with parameters that are pointers.
Sometimes it’s useful to get information from a text property file, especially when you want to change values inside classes without recompiling them every time. A simple (and fast) way
You can do this without using the classpath directive at the command line. How? Easy! Just write a launcher! Here’s the code: /* Allow you to type “java QuickRunner” instead
Send an email without using JavaMail API, by using the Java Core packages(java.net.*;java.io.*) to pass three parameters. The first parameter is the SMTP mail server, the second parameter is the
Start the JVM with the “-D” switch to pass properties to the application and read them with the System.getProperty() method. SET myvar = Hello world Set myothervar = nothing java
Who doesn Related Posts Report: 70% of Enterprises Plan to Increase Cloud Storage SpendingTop Southern states for stretching $1 millionExtending Simple Enum Values to Be CompositeDatabricks Unveils Secure Version of
Many programmers are familiar with declaring an object variable in class modules and other places to capture events from a form and handle them in a generic way: Private WithEvents
Sometimes you might need to determine the full path name to a Windows executable file associated with a given file extension. The usual recourse is to use the FindExecutable API.
When generating a data report based on an ADO recordset linked to a remote database (such as Oracle or SQL Server), you can end up with a blank report. Try
While designing multilingual applications, I had to make them respond when a user changes the Windows locale setting Related Posts How To Watch Apple TV On AndroidMarvell debuts Structera CXL
The MDI look seems to have gone out of favor recently, judging from the popularity of the Explorer and Outlook styles in modern apps. Maybe that Related Posts Hybrid Integrations
If you Related Posts Home Depot bolsters B2B with $18.3B acquisitionCORS Support in SpringThe New Surface Laptop Studio 2 Is NutsRepair ship en route to fix Sitka cableHello, World! Meet
This easy routine copies the contents of a listview, including column headers, to the clipboard for pasting into Excel or other applications: Public Sub SendToClipboard(ByVal ListViewObj _As MSComctlLib.ListView)Dim ListItemObj As
Have you ever wanted to have a hard copy listing all the VB error messages? Create a new standard EXE VB application and drop this code into the Load event
his article benchmarks a few different ways to access data using ADO.NET. Hopefully, after seeing the results of these tests, you will have a better idea concerning what approach to
SP.NET Web applications have a built-in way to access simple name/value configuration data. In the Web.config file, you can create an section that lets you store simple name/value pairs. For
The Clip property of the Cursor is the rectangle within which the mouse cursor is confined, or its value is Nothing if the mouse can move over the entire screen.
Pasting data from the clipboard requires more code because you must ascertain whether the clipboard contains data in one of the formats you’re willing to process. First, use the Clipboard.GetDataObject