Alec Tang

How Sharepoint stores datetime field in UTC

Alec — Sunday, January 02, 2011 12:00:00 AM

Lately we found a very interesting fact of Sharepoint, which I think is worth writing a post about. Although it is very rare that someone will read directly into Sharepoint database to retrieve information, but for some hardcore users, especially with my last post regarding how Sharepoint stores data in backend database, one can easily read into Sharepoint Prod_Content database and do CRUD transactions. ...

How to disable button upon submit click

Alec — Friday, November 26, 2010 12:00:00 AM

Often times user could be multi clicking a submit button, sometimes due to a slow responding browser or network connection of simply by accident. We could actually disable a button click from code behind easily using one line of code....

Accessing parent web list items carefully

Alec — Friday, November 26, 2010 12:00:00 AM

I spent quite some time today fixing this problem of accessing a list item in parent web. What I had to do was to access a list item in a parent web, but it kept crashing as if there's no permission given to access it. ...

Useful common methods for Sharepoint Development

Alec — Wednesday, October 20, 2010 12:00:00 AM

Time and time again, I use these methods in coding for Sharepoint. These include methods for querying a list, bind a Dropdown List to a list, and bind a Dropdown List to a multiple choice field. ...

Reading Spreadsheet into a DataTable in C#

Alec — Tuesday, October 19, 2010 12:00:00 AM

This is an extremely useful function, which allows you to read an Excel spreadsheet and convert its data into a DataTable in C#. With data in a DataTable, we can perform lots of things to it. ...

Easy expand or collapse Sharepoint List in Group by view

Alec — Sunday, October 03, 2010 9:35:00 AM

When you group list items by some fields, by default Sharepoint have the items collapsed. It's quite annoying to have to manually expand each. There's a way you could easily expand all list items or collapse in one click....

List Attachments Open as Read Only

Alec — Sunday, September 05, 2010 8:32:00 AM

I had the problem of saving files which I uploaded programatically to Sharepoint list item. When I tried to save them, there's pop up dialog saying the file is in read only mode, even I had all the required permissions....

Website finally back up from Google's block

Alec — Sunday, August 22, 2010 9:37:00 AM

Just two weeks ago, my website had been hacked and what drove me crazy was I couldn't find out what was wrong, or which files were been hacked. All I knew was the site had been marked as containing malicious code by Google and hence visitors could not get to my site, which in another words, my site was blocked by Google!...

How to duplicate a Sharepoint list item

Alec — Tuesday, July 13, 2010 9:00:00 AM

I was trying to add a duplicate link to the list item menu dropdown context box, so that user can click and duplicate an item. It's actually quite easy to do that. ...

Sys.WebForms.PageRequestManagerParserErrorException

Alec — Wednesday, May 12, 2010 1:15:00 PM

I had the problem of page not able to redirect when in an ajax postback. It happens to be the fact that I disabled a line in web.config:. This line should be added in HttpModules, so that redirection will work in Ajax postback. This class manages HttpModules for Ajax functionalities in ASP.NET....