Andy Blog

Full-stack developer

nopCommerce tutorial - (3) develop a plugin

Introduction There are two approaches to customize nopCommerce to fit our needs. Plugin can be used to extend the functionality of nopCommerce. Theme can be used to define the look and feel of page...

nopCommerce tutorial (2) increase file upload size

Issue nopCommerce throws exception when uploading a large file for downloadable products. Solution Please modify web.config because nopCommerce uses .NET MVC Please note that the default maxim...

nopCommerce tutorial (1) - installation and debug

Prepare environment operating system windows 7+, sql server 2008+ control panel > program and features > turn windows feature on/off > IIS > Application Development F...

ASP.NET WCF Service Tutorial

Download source Introduction WCF(Windows Communication Foundation) is a service layer that allows us to build applications that can communicate using a variety of communication approaches. With it...

ASP.NET SOAP ASMX Web Services Tutorial

Introduction A web service is a web application which is basically a class consisting of methods that could be used by other applications. Active Server Methods (ASMX) is a solution put forwarded ...

SQL Server Reporting Services Tutorial 5 - Integrate reports in web page

Prepare report(s)/chart(s) Report1: Report2: Integrate reports - way1: use iframe find the report file at http://localhost/reportserver open a report and get the url like http://hostnam...

SQL Server Reporting Services Tutorial 4 - Create charts

Create a chart Prepare query select i.title as device, sum(t.quantity_purchased * transaction_price_value) as amount, round(sum(t.quantity_purchased * transaction_price_value) / sum(sum(t.q...

SQL Server Reporting Services Tutorial 3 - Create more reports

Create a dropdown report Let’s create a dropdown report including date, order_no, amount, quantity. We can drill down the date via year/quarter/month/day and view special orders Prepare sql query...

SQL Server Reporting Services Tutorial 2 - Visual Studio

Install SQL Server Data Tools SQL Server Data Tools (SSDT) is a development tool that we can used to build SQL Server relational databases, Azure SQL databases, Integration Services packages, Anal...

SQL Server Reporting Services Tutorial 1 - Introduction

Introduction SQL Server Reporting Services (SSRS) is a server-based report generating software by Microsoft. It is part of suite of Microsoft SQL Server services. Basically, it can be used to prep...