Dejan's Web Log

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

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

JavaScript

read more

Umbraco CMS

read more

.NET

read more

SQL/T-SQL

read more