WebLog

Server-side, client-side, code snippets, scripts, automation, best practices, proven approaches, tips & tricks...

Simple Office365 authentication

Use Office365 account login for your application
0
With so many online and cloud based services, adding one more additional account for your application adds additional complexity level for your users since they will have to manage one more account and remember one more password. Microsft ASP.NET comes with pretty nice built in provides for social networks, but for office usage social networks are not so convenient to be used. ...read more

Create XML/HTML with T-SQL

Generating XML/HTML output in SQL Server
0
Sending email from SQL is not a difficult to achieve, but generating rich HTML content might be. SQL Server itself is not built as a text processor, first approach would be to build HTML by simple concatenating the string elements. This approach will work, but over time it will become more and more difficult to maintain especially if you need to add layout elements over time. ...read more

MSMQ recovery with .NET

Using MSMQ with message recovery in .NET
 
0
MSMQ is a bit old stuff and there are bunch of other products out here which perform better in most of the scenarios, but MSMQ is still used in a lot of solutions and Microsoft still did not announce support ending for MSMQ so it will be for sure some more time around.One of the stuff that is missing as out of the box feature in MSMQ is recovery. In scenarios you get the message from the queue and try to process, and process fails, in some of the cases you might want to try to process the message again...read more

Serialize DataTable to JSON with just few lines of code

Generate JSON string from DataTable in C#
0
Although JSON is widely used as a format for sharing the data, there are still existing solutions or modules that still rely on ADO and DataTables. Even today it very common to see some piece of code which deals with DataTable or DataReader for the performance reasons. In the end if any of the ADO objects needs to be exposed as a JSON string you have to write your own serialization code. ...read more

Resize image on the client side with JQuery

Reducing the upload sie by resizing image on the client side
0
Image resizing is considered as a server side operation as JavaScript and HTML were not so sophisticated and HTML5 support was not widely adopted for quite some time. even now, some features are not equally supported by all major browsers. Anyhow, HTML5 is here to stay and over time we will get more and more features supported by all browsers. ...read more

SqlBulkCopy with model classes in C#

Use SqlBulkCopy with model (POCO) classes in C#
 
0
So far (based on my experience) the fastest way to insert big number of records from application to database is to use SqlBulkCopy. The downsize of this is that SqlBulkCopy uses DataTable instace as an input parameter which is not so convenient when dealing with models which are strongly typed and a lot more easy to use than iterating through the DataTable. Since SqlBulkCopy accepts DataTable for insert you can not use models directly to insert your data...read more

GoogleMaps route jQuery plugin

jQuery plugin for easily adding route map on your website
0
To make it easier for your customers to find your store location it is really important to show them where you are, but what can make even better impact is to show them where you are based on their current location and to guide them to you. GoogleMaps are a powerful tool for that, but you have to spend some time (more or less) to find code snippets and understand how to invoke their API, add the proper references, handle exceptions which might occur during the communication between your website and GoogleMaps API etc. ...read more

IP address to octets split in TSQL

Split IP addresse into octets in SQL Server
0
In case you need to handle IP addresses in SQL, they are not much useful as string values. To do anything with them rather then just storing and retrieving (checking the ranges for example) you need to split IP address to segments (octets). The following is modified method I run into online. ...read more

Debugging Windows Service application with console in C#

An easier way to debug and develop Windows Services
 
0
Developing Windows Service might a a real headache since you do not have any visual part to see the output. Even if you want to rely on Visual Studio debugger you need to install the service, stop it (if already running), deploy, start the service from Windows MMC and finally hook up Visual Studio to the running service process. Whooh, a lot of things to be done just to start debugging and you have to do it every time you want to start your debugging session (of course not including install every time obviously). ...read more

Non blocking writing to console in C#

Write message to console without blocking current thread
0
The fast and most commonly used method to debug code is for sure using console applications. Since main operations are reading input and writing output, it does not take much to set it up and start debugging your code. One more reason for using console application is to test the performance...read more

IP address filtering from C# code in ASP.NET MVC and Web Api

Restrict or allow specific IP addresses to access your WebApi or MVC
 
 
0
Last year I wrote an article about IP address filtering on MVC and WebApi Restrict Access to an MVC Action or Controller based on IP address. Over time the requirements for IP filtering in several web based application increased, so I had t work on this class to make it more extendible and reusable in different scenarios. The new scenarios I wanted to cover are: ...read more

JavaScript

read more

Umbraco CMS

read more

.NET

read more

SQL/T-SQL

read more