
Merge Two DataTables, Preserving the Old Values
The datatable1.Merge(datatable2) statement will merge datatable2 into datatable1. You cannot retrieve the old values in the datatable1 after the merge happens. A quick way to do that, is by creating

The datatable1.Merge(datatable2) statement will merge datatable2 into datatable1. You cannot retrieve the old values in the datatable1 after the merge happens. A quick way to do that, is by creating

Often, there are multiple collections with the same kind of elements, that we would have to loop on. Instead of writing two for loops over the collections, we can use

When you create the datagridview associate an event handler for its ‘EditingControlShowing’ event. sampleDataGridView.EditingControlShowing += new DataGridViewEditingControlShowingEventHandler(DataGridViewEditingControlShowing); And in the event handler add the selectedIndexChanged eventhandler to the combobox. private

There are cases in which you would need the Enter key to operate as the Tab key. In order for the Enter key to be used as a Tab key,

How to set a Java Persistence API hint in Spring: @Override@QueryHints(value = { @QueryHint(name = “org.hibernate.cacheable”, value = “true”)})public List findAll(); Related Posts Use SUBSTR to Remove the Last Character

You would get the ‘DeletedRowInaccessibleException‘?when you try to access a deleted row in a dataset. To retrieve the information of a deleted row in a dataset, use the overloaded property

/*A UUID is a 36 character string, 32 alphanumeric characters and 4 hypens123e4567-e89b-12d3-a456-426655440000Java supports generation and usage of this using the java.util.UUID class*/public class JavaUUID{ public static void main(String args[])

You can’t use the “Between” keyword in a LINQ query. The sample snippet below shows how you translate between two date fields. DateTime fromDate = DateTime.Now.AddMonths(-3); DateTime endDate = DateTime.Now;

You can use an undocumented Extended Stored Procedure named xp_dirtree to list folders, subfolders, and files for a given path. Xp_dirtree has three parameters that need to be supplied: directory?-

Let’s suppose that we have Flyway installed in D:/Flyway folder: copy the conf/flyway.conf file to a file called conf/prod.conf open it and update the username, password and url properties: flyway.url=jdbc:mysql://localhost:3306/db

A Dataset maintains an index, or many indexes, to facilitate the high performance when it is traversed for data. An example of such a situation is when you use the

public class CompareArrays{ public static void main(String args[]) { compareArrays(); } private static void compareArrays() { int[] intArray1 = new int[5]; int[] intArray2 = new int[5]; //Changing the value so

To copy the HTML document of the WebBrowser control in HTML format, you need to use the IHTMLDocument2 object of the MSHTML class. For this, you need to add a
If you want to move some content to a new page or create a new page, just place the cursor at the desired location and press CTRL and ENTER keys simultaneously. The cursor is also automatically placed in the new page. Related Posts Microsoft Updates, Expands Visual Studio ToolsTips for Unit Testing with MocksGetting the Last ID in MySQLEMC Buys Cloud Management Vendor VirtustreamBackblaze Runs a Fire Sale on Cloud
Microsoft word gives us various options to change the case of the text. Changing to upper/lower is just a click away. Access the ???change case??? button in the Paragraph ribbon menu, and you will see options like Lower case, Upper case, sentence case. Applying it is very easy as well. Just click on the text on which you want to change the case, and then select an option from the ???change case??? options. Related Posts Customer Journey Mapping: Top Tools to Track and Optimize User Experience Support for Lazarus 1.8.4 and a Bunch of New Helpful Features in Updated DAC ProductsWhat Are
Is there a format/style of the text that you want to quickly copy in Office applications like word, excel, powerpoint etc? Just click on the text from which you want to copy the format, and then click on the ???Format Painter??? button in the clipboard ribbon menu and then click on the text where you want to apply. The format is copied over. Related Posts Easily Create Responsive Websites Using BootstrapVolkswagen ID.3 Battery Capacity Concerns RaisedSalesforce Launches Einstein AI ProgramElon Musk threatens Apple over OpenAI integrationHow to Enable Java 9 GC

When working with an SQL Output parameters, you need to specify the parameter’s Direction property once you have created it. Here is a nice little example method: private float checkValue()

A list of textboxes available in a Google authentication page can be captured using this snippet of code: driver.get(“https://accounts.google.com/”);List Textbox =driver.findElements(By.xpath(“//script[@type= ‘text/javascript’]”));System.out.println(“Overall textboxes:”+Textbox.size()); Related Posts How To Find Hidden Apps

If a stored procedure returns multiple record sets, and if you are using the DataReader to retrieve the results, you can use the NextResult method of the DataReader to iterate

import java.util.*;public class TimerTaskDemo extends TimerTask{ public static void main(String args[]) { //Creating a TimerTask and a Timer that together helps achieving the required result TimerTask timeTaskDemo = new TimerTaskDemo();

The WebBrowser control’s document object gives us the ExecCommand method that takes in dom commands such as ‘SelectAll’, and ‘Copy’ which can copy the text for you. You need to

To get the text of an external window you could use the GetForegroundWindow and the GetWindowTextAPI functions. Here is a small example of its usage: public partial class Form1 :

Getting elements using their tag names is often used to collect autosuggestions, checkboxes, ordered lists, and so on. The following line of code is an example of capturing elements trough

The WebBrowser control does not show notifications such as: Downloading web page… Resolving proxy… Hyperlink URLs You can quickly enable this by using the StatusTextChanged Event of the WebBrowser control.

public class ArraySize{ public static void main(String args[]) { changeArraySize(); } private static void changeArraySize() { int[] intArray = new int[5]; System.out.println(“Before change: size(): ” + intArray.length); // Increasing the

The default designer that comes with the Web Controls is great but there are times when you might need to customize it. It’s pretty easy to do. You need to
Memory utilization on the mobile app has a significant impact on the customer experience. If your app creates a lot of objects, then Garbage Collection (GC) process will be triggered frequently to evict unused objects. Even though Garbage Collection is an automatic process, however, frequent Garbage Collection consumes a lot of CPU + it will also pause the app. Frequent pauses can jank the app (i.e. stuttering, juddering, or halting). Thus, you need to understand how many objects your app is creating, how frequently Garbage collection is triggered, how much time it takes to complete, how much memory is reclaimed after every event. All this information is present in the runtime log messages. Whenever a GC event runs, a log line is printed in the runtime log messages. You can view those log lines through logcat. GC log line format varies based on whether app runs on Dalvik VM or Android Run Time (ART). In the earlier article, we saw how to analyze ART GC log line. In this article, let???s see how to analyze Dalvik GC log line. Related Posts Virginia receives $1.5 billion for broadbandMay’s geomagnetic storm sparks unique atmospheric changesEsa scientists 3D print space bricksIntegration Salesforce with SFTPInfinite Heap in Java

A quick and dirty way to see if the application’s current platform is 64 Bit or 32 Bit is to test the size of the System.IntPtr variable, as shown in

Here is a list of the most popular Docker network commands: docker network create – creates a network docker network connect – connect a container to a network docker network

A situation may arise in which you would need to hide certain sections of your page from crawlers or determine what actions to take based on the referrer of the