Usually in your application you use two different types of lookup query; the first one is for retrieving a page of records (or all records) to populate a pick list,

The ASP.NET version of the Server.Transfer method accepts a second argument which, if true, causes the query string and all the form’s fields to be transferred and made available to

A common mistake when creating a .NET component that runs under Component Services – that is, a class that inherits from ServicedComponents – is that you forget to assign a

All ADO.NET applications require MDAC 2.6 or later (MDAC 2.7 is recommended). MDAC 2.7 comes with Visual Studio .NET but no MDAC version is included in the Microsoft .NET Framework

The ChangeDatabase method of the ADO.NET Connection object requires an open connection to execute correctly. Even if the connection is open, you can still have an InvalidOperationException when invoking this

At times you get the error “Could not copy temporary files to the output directory” when compiling a VB.NET or C# project from inside Visual Studio. Here are some of

A CallableStatement object provides a standard way for all RDBMS’ to call stored procedures. A stored procedure is stored in a database; the call to the stored procedure is what

This code is how to send NET SEND messages to all the connected SQL Server users in an NT local area network: CREATE PROC notify_users(@notification VARCHAR(100) = ‘SQL Server shutting

It has already been said many times that (a) std::vector is preferred to c-style arrays, and (b) Arrays, vectors, and other data structures should preferably be passed by reference.While this

The following code explains how to make a class that is final, meaning that it cannot be derived further. class FinalBase{ FinalBase() {} friend class Final;};class Final : private virtual

Fixed-size arrays in local variables use a stack-allocated descriptor as expected, but all the data for an array is allocated on the heap. However, fixed-size arrays embedded in structures are

In Microsoft Access, you can execute a parameterized query that uses other parameterized queries, as long as their parameter names are the same. Save these queries in an Access database:

Here Related Posts Using Swagger to Document Your ASP.NET Web APIsTip: Find Out the Column Name Using the COL_NAME() FunctionGoogle Rolls Out New Cloud Storage ServiceUse MySQL for CalculationsKaspi.kz Pursues

Sometimes the user forgets to enter a date with date separators. A good way to deal with this is to correct the users mistake instead of forcing the user to

If you want a form to support context-sensitive help, set the WhatsThisButton and WhatsThisHelp properties on the form to True, and set the WhatsThisHelpID property to a corresponding help-file topic

There are many ways to count the occurrences of a string within a text. Here’s a simple function that uses the InStr() function: Function CountWords(ByVal Text As String, _ ByVal

There is no native function for returning the current date format string. Here’s a simple function that calls the GetLocaleInfo API in order to retrieve the short date format string:

All AWT component classes have a setCursor() method that allows for dynamically setting the cursor for a particular component and any subcomponents.For example, if you set the cursor for a

Sometimes you need variables scoped by thread so that each thread has an independent copy. There’s an easy way to create and manage such variables.The java.lang.ThreadLocal class provides a wrapper

If class B uses only pointers or references of class A, you don’t have to include A.h. You can simply forward declare class A as shown below. //File B.hclass A;

Suppose you want to pass a Boolean system property, -DDEBUG=true or -DDEBUG=false, from the command line. Normally, you’d probably use the following in source code to retrieve it: boolean b

// Quickly zero out a struct. This can be applied// To an array of structs also, since// memset() initializes memory regions#include struct sample {int a;short int b;int c;};struct sample s;//

The new ANSI C++ standard specifies that variables declared as in for(int i=1; …) have a scope local to the for statement. Unfortunately, older compilers (like Visual C++ 5.0) use

Use the following code: select *,right(field1,4) as Col1 from [Tablename]order by col1 You can do it by using substring: SELECT *, substring(field1, 3, 5) as col1from [tablename]order by col1 Related