There are various cases in which you may want to display results from aggregate functions (Sum, Avg, Count, Min, Max) performed over the columns in the grid in their footer. This post explains how to display aggregate functions in ASP.NET MVC Razor views.
Used Environment for this post: VS 2015 Update 3, ASP.NET MVC 5
For ASP.NET Web Forms, Read following post:
Displaying Total in ASP.NET Gridview Footer Row Without using Template Field
Generally, User submitted images (profile pictures, social media posts, and business documents) are needed to be moderated to protect business and quality. If a large number of images are submitted in an application then manual moderation is time consuming and is not instantaneous. This post explains how to automate image moderation using Azure functions and Cognitive Services. Automated moderation applies machine learning and AI to cost-effectively moderate at scale, without human involvement.
In this tutorial, we will setup HTTPS with Apache on Ubuntu server and generate free SSL certificate from Let’s Encrypt. It is a free certificate authority which can issue free certificates with a valid duration of 90 days and the certificates cost nothing to implement. It is assumed you know the basics and importance of HTTPS and SSL in terms of safety and security.
Read Also: Install or Upgrade to PHP 7.X on Ubuntu
This post explains how to install or upgrade to PHP 7.2 on Ubuntu. It is assumed PHP 5.x is running on an Ubuntu 14.04 machine in case of upgrade.
Note: This new version brings with it a number of new features and a few incompatibilities that should be tested for before switching PHP versions in production environments.
Read Also: Installing Linux, Apache, MySQL, PHP (LAMP) Stack on Ubuntu 14.04
Do you want to query JSON document, extract data, select sub sections or testing a query quickly? This articles explains to do it using Chrome Developer tools. I am using Google Chrome Version 60.0.3112.113. But it should work for all recent versions.
Read Also: Copy DropDownList Data from a Website: Chrome Developer Tools
This article shows how to use PostgreSQL with ASP.NET Core 1.0 using Dapper ORM. We will implement CRUD (Create, Read, Update and Delete) operations in ASP.NET MVC step by step.
On a web page or application form, it is common to have different master data like Country, State…etc. available in dropdownlist, listbox or any other control. It is needed to read all master data from database and bind to proper controls. This post explains different ways to read master tables with C# and Dapper.
Do you want to allow user to login with either Username or Email address? ASP.NET Identity uses Username for Signin verification and In default Core template, Email is used as Username. In this post, we will change ASP.NET Core Identity setup to allow both Username and Email on login.
1. Username is unique for each user. It is either input by user or generated by application on registration.
2. No @ symbol allowed in Username.
In previous post, we created enum for different roles and added them in database on application startup. In this post, we will implement role based security.
It uses following environment:
In this post, we will see how to use select tag helper in ASP.NET Core MVC and how to bind select tag helper to model data or enum values. The following environment is used for this post:
ASP.NET Core 1.0.1
Visual Studio 2015 update 3
For the demo, let us assume we have following Department enum
Error: column "Gender" is of type enum but expression is of type text.
Are you getting this error when you are using enum datatype in PostgreSQL database? This blog post explains how to fix the error with C# and Dapper. The following environment is used for this post:
In ASP.NET Core application, you want to seed roles and users in the database. This post explains how to add Roles on application startup using ASP.NET Core Identity. It is written in following environment:
ASP.NET Core 1.0.1
Postgresql 9.5.4 database
Visual Studio 2015 update 3
Today, we will explain how to show SSRS reports in ASP.NET MVC application. Suppose you already created awesome SSRS reports and want to use MVC as Report viewing application. Here is your solution.
Open existing application or create new MVC application. You can install reporting package from NuGet.
Go to Tools -> Library Package Manager -> click on Package Manager Console and type following command into command window.
I was working to setup development environment of this website on Ubuntu 14.04 virtual machine. So decided to write a post on it. This post explains how to install LAMP stack (Linux, Apache, MySQL and PHP) on Ubuntu 14.04.
Run following commands:
sudo apt-get update
sudo apt-get install apache2 php5 libapache2-mod-php5 mysql-server libapache2-mod-auth-mysql php5-mysql phpmyadmin