I was creating a simple tool to work with database table. When I coded a part of updating table records I got some errors. One of them was:

Fixing C# and GridView error - String or binary data would be truncated. The statement has been terminated (more...)

Below I described two string javascript functions that I often forget.  (more...)

It’s good to be dbowner in MS SQL server, but it’s easy to forget about permissions for other users. I created a procedure and tried to execute it from technical account. And I've got the error that user can not execute procedures. (more...)

When I tried to add html to data for my GridView control, I could only see html code. I could see "<span class="myhtmlclass">my text</span> from SQL request</span>. But I wanted to wrap my content with <span> tags. (more...)

Field with autoincrement is very useful thing and it's often used in MySQL. In MSSQL you can also need to use this tool. There are two ways to do it. (more...)

When I wanted to get the ID of clickable element using jQuery, I have found out that I don't remmember such a simple thing. I had to look for it. And I've found it 🙂

I had buttons with class "phonebtnCall" and some IDs. I wanted to know which of buttons was clicked. (more...)

When user tells you that he has got an error using SharePoint portal service, you ask him about the page he was, which buttons he clicked and, if user hasn’t still closed browser, ask to send you screenshot of the error. It contains very useful information – CorrelationId. (more...)

Sometimes when you work with jQuery,  you want to change css-style of elements. There are two common ways to do it: 1 – to change class of element, 2 – add css attribute (more...)

I was asked to download a lot of files from document library. Of course, I could open document library in Explore mode, but there was a lot of files and it could take a long time. So I’ve found a good PowerShell script to save files from document library. (more...)

The reason of error  "'Namespace.className.source' is inaccessible due to its protection level" is that by default class variables "source" and "substitute" are protected and you don’t have access to them anywhere out of the class. (more...)