Author: Sumit Gupta

  • SQL Update if Record Exists or Insert

    Quite often we need an approach where we need to Insert record if it is not already present. Sometime to manage relationship. There are few different way of doing it, like “If Exists”, or “Insert on Duplicate Key” (mysql) but the best I found is one from MSDN Blog Entry ( http://blogs.msdn.com/b/miah/archive/2008/02/17/sql-if-exists-update-else-insert.aspx) The approach is […]

  • ASP.NET MVC 5: Session not working

    Just encounter an issue with ASP.NET MVC 5, the sessions are not working. i.e. when I put a value in controller like Session[“mysession”], it do not shows the same value in Views or in fact anywhere else. Search online, some create custom classes to manage them, and some give different patch, finally got the easiest […]

  • Refreshing USB ports using C#

    Finished a project in which I need to refresh the USB ports by just before we start some particular benchmarking application my client has. Seems pretty easy job, if you know to gain access of system resource. But, it become fun job, when I found that knowledge of system is not even necessary for this […]

  • WordPress: Custom Post Permalink giving 404

    In most of wordpress project we do, we have few custom post type and taxonomy. We use a nice plugin called “PODs” for the same. It is good plugin, we try some other in different project and most of them serve the purpose pretty well. But today we found something, or rather just an overlook stuff. […]

  • WhatsAPP moving to new authentication.

    Though the new authentication (WUTH-2) is not really new, but few days back they disable the old authentication mechanism. So, just a bookmark to latest version of API: https://github.com/mgp25/WhatsAPI-Official . This is rather refined library and you can feel it when you use it.

  • Windows System Repair

    I just install Windows 8.1 on my home PC, installing SQL Server on it and found that activeds.dll file was missing. I haven’t install anything, just regular MS products and updates. So, how can a file is missing. On searching I found that DLL was present, but seems corrupted, maybe some disk writing fails or […]

  • PDF Creation: wkhtmltopdf

    In past I post about how good wkhtmltopdf is. I have used it for few of my projects. Really it is the cheapest [as it is open source and free] and powerful solution. But it is not the reason I love it. I love this because it is the Easiest solution available. Most of PDF […]