Pritam's Blog

Sharing is Caring

By - Pritam Baldota

The request body did not contain the specified number of bytes. Got 0, expected xxx – Internet Explorer Issue

When you try to re-POST subsequent requests from Internet Explorer browser it only sends only the header data is posted. As a result you will receive error in response – The request body did not contain the specified number of bytes. Got 0, expected xxx. There is already a Hotfix available at Microsoft Knowledge Base https://support.microsoft.com/en-gb/kb/895954. General Repro Steps –

By - Pritam Baldota

SharePoint 2010/2013 Date Comparison in different Time Zones

Working with DateTime in SharePoint is always tricky since it stores values internally in UTC and when we tried to access it in CSOM or SOM in different Time zone we have to be very careful while filtering on Created, Modified Date columns. Time Zone plays very crucial roles in any Date Time difference calculation. When we do difference in

By - Pritam Baldota

jQuery based Resource Localization

Create client side (JavaScript) based Resource Localization in any web application. Extremely light-weight library, just 3KB (Minified) and 8KB(Debug) version. Implementing client side localization into any web application is always challenge. Most of web technologies provide localization using server-side technologies. For e.g. .Net application uses Resources Files(.resx) to implement localization into globalization application. Nowadays world is extensively moving towards Asynchronous

By - Pritam Baldota

JQuery Culture Information Plugin

Accessing Culture Information for all available cultures in JavaScript is always difficult and most of the web developer has to search on internet for this information. There may be several options available to fetch this information into Server-side technologies like ASP.Net, JAVA, PHP, and etc. But in JavaScript it is very difficult to find this information at one place. To

By - Pritam Baldota

Associate Custom Content Type with SharePoint 2010/2013 List Or Library using PowerShell

To automate deployment in SharePoint 2010/2013 on-premise solution, we have to use PowerShell. One of the deployment activity is creating SharePoint Custom Lists/Libraries and associating them with custom created content types. In this article we will be focusing only how to add/remove content types from the List/Library. To add content type follow below steps – Get Reference to Site collection

By - Pritam Baldota

SQL Server Database Triggers

A trigger is an object contained within an SQL Server database that is used to execute a batch of SQL code whenever a specific event occurs. A trigger is “fired” whenever an INSERT, UPDATE, or DELETE SQL command is executed against a specific table. A Trigger is associated with Database Table There are three types of Database Triggers – INSERT

By - Pritam Baldota

ActionScript for Designers Part 1- Basics of ActionScript

Hi Guys, Generally Flash comes with two meanings – 1) Flash for Designer & 2) Flash for Developers (ActionScript). Designer always threaten about ActionScripting. It is not that complicated at basic level where Designer can levarage the benefits of ActionScripting to their Creative Work without having Programming knowledge. If you already know the Flash, using tools and creating animations, you may

By - Pritam Baldota

Generate Page URL Name for CMS, Blogs Application

Hi All, To give the Name to the Page can be handeled by many ways like Using GUID (Issue- Cant identify exactly while browsing through pages) Using Session (Issue-Same as above) Using Page Title provided in Text Field (We will see this) We are going to implement the scenario 3. We will first see what are our constraints for page

By - Pritam Baldota

Optimizing SQL Server Database Design Tips & Tricks

Database design is most crucial part in application development. Database can be anything SQL Server, MySQL, Oracle, etc. I will consider SQL SERVER as a part of discussion. Tunning the database depends upon various factors like whether one datatype is better depends on the context of it’s usage. Following are most common datatypes used in database. Numbers Datatype (For storing

By - Pritam Baldota

GridView in ASP.Net

GridView plays very important component in ASP.Net Application. It covers most of the basic reports for which you do not need any reporting component like Crystal Report, Report Viewer etc. Major concern with any data entry form is Add, Edit, Delete and View. Assumptions- We are using SQL Server Express editions as Database. Table Name- Employees Fields- EmpId, EmpName, Designation