Reading Spreadsheet into a DataTable in C#

Read more about Reading Spreadsheet into a DataTable in C# article

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

Read more about Easy expand or collapse Sharepoint List in Group by view article

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

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

Read more about Website finally back up from Google's block article

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

Read more about How to duplicate a Sharepoint list item article

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

Read more about Sys.WebForms.PageRequestManagerParserErrorException article

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.

How Google treats Content Duplication

Read more about How Google treats Content Duplication article

Today I was reading Google's Webmaster Guideline regarding content duplication on the Internet and steps that Google advise webmasters to take care if the situation applies. It's quite interesting as I did not know some of these facts.

How to create HTML column in Sharepoint List View

Read more about How to create HTML column in Sharepoint List View article

I came across this problem of wanting to add a column in the List view web part (stock standard one) with the ability to have html elements rendered properly. Unfortunately Sharepoint's standard list view only displays text in it.

How Sharepoint stores User Data

Read more about How Sharepoint stores User Data article

Lately I had fun digging into Sharepoint database and see how the monster was built and what its database schema looking like. Well, it's pretty smart the way it was built but it's also a pain for developers to understand and even to play with it, if they have to. With the business that I am working for, we have to create reports for corporates, which forces us to having to dig into Sharepoint database directly, even though I read a lot of posts saying that is not recommended by Microsoft.

How to send email via Sharepoint

Read more about How to send email via Sharepoint article

A useful function to send email in Sharepoint, programatically.