Excel has a huge number of tools for customizing text and tools to count data. So, one of useful things is to rotate text on any angle. It can be useful for customizing table headers. (read more...)
Generic handlers have an extension .ASHX. It's a good solution to render documents or images for user on server-side after user requests, not web page. Generic Handlers solution (.ashx files) are not directly supported by Visual Studio 2010 for SharePoint projects. But there's a little trick for this.
During long use of Microsoft products, I got a habit that to update Microsoft Office I need to download Service Pack for my MS Office version. But in MS Office 2013 I can easily press some buttons for updates.
Source: a lot of money values returned from SQL as strings. For example, "1500312.32", "2382938.12", "283727361.10" etc.
The task: display money values in format "1 500 312.32", "2 382 938.12", "283 727 361.10", etc.
There are some tricks with GridView control on Asp.net. It's really cool tool if you know it. The tricks are about how to add LinkButton to each row and how to focus the GridViewRow where LinkButton was clicked. (read more...)
To clean selected row in GridView control you should set its property SelectedIndex to -1.
GVCtrl.SelectedIndex = -1;
When you restore a database from backup to your SQL server in test environment, you will try to add Role to a restored database for user. At this time you may get the error message:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo). User, group or role 'UserName' already exists in the current database. (Microsoft SQL Server Error" 15023). (read more...)
In SharePoint timer job history I have noticed that there's the error in starting User Profile synchronization:
Could not connect to http://spsrv:5725/ResourceManagementService/MEX. TCP error code 10061: No connection could be made because the target machine actively refused it <ip-adress:port>. (read more...)
Simple console application, which get data from SharePoint list and displays it. It's very good solution if SharePoint is used as a storage of rates, catalogs, libraries etc.
To use SharePoint Client model you should add references to Microsoft.SharePoint.Client.dll and Microsoft.SharePoint.Client.Runtime.dll in your solution. (read more...)
By default Asp.net Calendar control shows dates of current month. For some tasks you may need to show another month by default. You can do it from code behind in one string. (read more...)
