DEV4 Blog

Loading...

PivotTables are a useful function on Excel which allow you to take a large dataset and transform it into an easy-to-read table. They can be used to separate data into timescales such as years or months, to compare data categories, and to produce char

Read more...
Published on 24 Feb 2021

Carriage returns within text cells can often cause problems when you want to transfer data to another platform, such as a database.  An easy way to remove all carriage returns from a spreadsheet is to us the Excel Find and Replace function along

Read more...
Published on 28 Oct 2020

The MS Excel VLOOKUP function is useful when you need to link data from multiple tables and worksheets.

This very simple example shows how to use the arguments in the VLOOKUP function:

More advanced uses of this function will follow in this blog soon.


Read more...
Published on 28 Oct 2020

To add a carriage return/new line to text inside a single MS Excel cell:

Click into the cell at the location to place the new line and use the keyboard 'Alt + Enter'.

See a video example here:


Read more...
Published on 16 Oct 2020

If you need to retrieve the total number of fields in your database, use the following query.

select count(*),c.table_name 
from information_schema.COLUMNS c
JOIN information_schema.tables t ON c.TABLE_NAME = t.TABLE_NAME
AND c.TABLE_Schema = t.TABLE_Sch


Read more...
Published on 28 Jun 2019

The compilation is disabled by default. In order to enable it, modify the Properties/AssemblyInfo.cs file.

using Xamarin.Forms.Xaml;

[assembly: XamlCompilation(XamlCompilationOptions.Compile)]
Published on 04 Mar 2019

Backing up your database may not be enough to ensure you can respond to a Disaster Recovery incident.

For the purposes of this article, we'll use MS SQL Server without replication, as our working example.


Backing Up Your Databases

Choose a Separate



Read more...
Published on 26 Feb 2019
Public Class Sessions

    Private Sub New()

        blnPriceListActive = false

    End Sub


    Public Shared ReadOnly Property Current As Sessions

    Get

 












Read more...
Published on 25 Feb 2019
RESTORE HEADERONLY FROM DISK = <path to backup file>


Read more...
Published on 19 Feb 2019

Bootstrap is a front-end framework and only supports activation of user interface elements from JavaScript. How can we show dismiss-able Bootstrap style alert messages from code-behind in a Web Forms project? 

Steps:

  1. Write a VB module (attache
Read more...
Published on 22 Jan 2019