Archived articles

Archive for February 2018

Export DataSet and DataTable to Excel with C#
Saving DataSet or DataTable instace to an Excel spreadsheet with C#
0
Some time ago I wrote an article on how to export data to Excel from C# code. Essentially it exports data to file which can be opened in Excel but it does not produce the actual Microsoft Office Excel document. I recently wrote an article on Working with Excel files in .NET without using COM in C#, so I decided to use this approach to create extension methods for DataTable and DataSet classes... read more
Export DataTable to HTML in C#
Generate HTML table from DataTable instance in C#
0
When I searched for exporting s to HTML table in C# I found a lot of articles and code snippets which are basically doing string concatenation or String.Format on the hard-coded HTML String to generate HTML string of the table. To me this approach is a bit like a workaround and I was never a fan of hard-coding values. In addition, code with a lot of hard-coded value end up as hardly maintainable code... read more
Working with Excel files in .NET without using COM
Read and write Excel files with C# using OLEDB on x86 and x64 platforms
0
Excel is a common format for storing tabular data. It is a powerful tool from Microsoft Office package. Since it is often format for string data, it is often required to work with this data from the third party applications... read more
Simplest way to store lists and dictionaries in config files
Fast and simple way of storing and using lists and dictionaries in config files
0
Configuration files are a useful place too keep any related configuration settings. It provides easy to use configuration fetching which you can invoke from any part of the application. However it does not support many stuff out of the box, but on the other hand it is pretty flexible and expendable. One of the things that are not there built in is support for lists. ... read more
Send data to Azure Log Analytics from C# code
Sending data to Azure Log Analytics from your C# code
0
Azure as a part of Microsoft Operations Management Suite provides data collection and insight services inside Azure cloud platform. It allows you to: ... read more
Multiple file upload with ASP.NET WebApi
Upload multiple files using WebApi REST service
0
Taking out business logic from the application allows different clients running on a different platform to use same logic. REST API is a great way to decuple business logic and make it available to different clients on a different platforms. To upload files using WebApi we first need to define an action in a WebApi controller to handle files posted to the endpoint. ... read more
Merge folders with Windows PowerShell script
Detect changes and merge folders and files with PowerShell script
 
0
When deploying application to specific location it is often required to deploy only few files and not the whole deployment package. For example, if you changed only single static image file in your ASP.NET WebApplication, there is no reason to overwrite bin folder content and cause WebApplication on IIS to restart. ... read more
Installing same Windows service under a different name
How to install same Windows service with different name on the same host
0
Microsoft .NET framework comes with a really good support for Windows services. Regarding the project itself, Visual Studio IDE comes with build in project template for Windows service. .NET framework itself comes with a built in tool installutil for deploying the Windows Service project... read more
Sending email with Gmail account using PowerShell script
Send email with your Gmail account login with PowerShell script
0
Sending email after and even before a long running PowerShell script is a logical thing to do to notify users which are responsible for taking actions for the specific operation. PowerShell starting from version 3.0 has build in cmdlet Send-MailMessage for sending emails. ... read more
Use PowerShell to install SSL certificate on IIS
Importing PFX SSL certificate to IIS with PowerShell script
0
Since Google announced HTTPS as ranking signal most of the websites now days are switching to secured communication via SSL certificates. Even I switched my website to HTTPS secured connection to follow up with this new trend. Using certificate on the website is related to domain binding, but even before we setup the domain binding for the website, we need to import the certificate to IIS... read more

.NET

read more

JavaScript

read more

SQL/T-SQL

read more

Umbraco CMS

read more