This article will describe how to format SQL code using SQL Server Management Studio (SSMS) native options and how to format SQL code using a third-party SQL formatter tool. A well-formatted SQL code is easily readable and reviewing such code… Continue Reading
You’re using Microsoft SQL Server Management Studio (SSMS) and would like to become more productive with this IDE. Check out these tips on how to make the most of SSMS. In this tutorial, we’ll look at 10 handy productivity tips… Continue Reading
File Upload is an input controller that is used to upload files to the server. It will create a browse button on the form that pops up a window to select the local machine’s file. To implement FileUpload, we can… Continue Reading
I want to connect to an MS Access database with C# in .Net core. Therefore, I will be able to write queries to create, read, update, and delete (CRUD) records. OS driver From experience, I would recommend run the web… Continue Reading
Many business owners mistakenly think of a domain name as just an address for their website. But as Rand Fishkin over at Moz recently explained, it’s so much more than that. Consequently, there are a number of factors you should seriously… Continue Reading
Background There is often a need in a project’s reporting module to create an Excel file from a database, so by considering that requirement I decided to write this article especially focusing on beginners and those who want to learn… Continue Reading
JavaScript is Everywhere. Millions of web pages are built on JavaScript and it’s not going anywhere at least for now. On one side HTML and CSS give styling to the web pages but on the other side, it’s the magic of JavaScript… Continue Reading
In this article, we will learn how to generate QR codes in ASP.NET MVC Core 6 by simply entering Text, numbers, and a combination of both in the textbox and clicking on generate QR code button. I found a very… Continue Reading
We have all been there. Staring at the screen, watching the little counter, waiting as Crystal Reports takes its time exporting what should be a simple report to a file format of your choosing. Worse still, the report takes so long that… Continue Reading
1. Export from DataTable to Excel using (ExcelEngine excelEngine = new ExcelEngine()) { IApplication application = excelEngine.Excel; application.DefaultVersion = ExcelVersion.Excel2016; //Create a new workbook IWorkbook workbook = application.Workbooks.Create(1); IWorksheet sheet = workbook.Worksheets[0]; //Create a dataset from XML file DataSet customersDataSet… Continue Reading