DEV4 Blog

Loading...

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

ASP

<%@ Page Language="vb" AutoEventWireup="false" CodeBehind="GeneratePdf.aspx.vb" Inherits="SampleApp.GeneratePdf" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title&





Read more...
Published on 18 Dec 2018

1. Create an error table.


2. Set up a Stored Procedure to manage the error handling in your database.
CREATE PROCEDURE [dbo].[uspLogError] 
    @ErrorLogID [int] = 0 OUTPUT  -- Contains the ErrorLogID of the row inserted
  &


Read more...
Published on 12 Dec 2018

Using an AJAX call and a web service method.


Code behind method to get objects;


In the web service, a GET endpoint retrieves this data in JSON format;

On client-side, a successful AJAX GET request (to the above method) calls the function which uses the



Read more...
Published on 14 Nov 2018

Telerik's RadGrid requires that users hold the Ctrl key for selecting multiple rows, similar to Windows Explorer. Enable multi row selection without holding the Ctrl key programmatically using the following approach.

ASPX

<telerik:RadGrid ID="Ra
Read more...
Published on 24 Oct 2018