Skip to main content

Creating An Azure SQL Database And Connecting Through SQL Server Management Studio

Introduction This article demonstrates how to create an Azure SQL Database, set the Firewall rule, and connect through the SQL Server Management Studio. Prerequisites Microsoft Azure Subscription, SQL Server Management Studio (SSMS) First of all, login to the Azure portal. Click here to go Azure login page. After signing into the Azure portal, click on the SQL […]

Read More

Export Data To Excel File In ASP.NET Using EPPlus

We are going to use EPPLus library in this article. It is an open source library and very easy to use for developers. EPPlus supports many properties like cell ranges, cell styling (border, color, fill, font, number, alignments), charts, pictures, shapes, comments, tables, protection, encryption, pivot tables, data validation, conditional formatting, formula calculation etc. We […]

Read More