Skip to main content


Showing posts from March, 2010

Google Search

Custom Search

Live Search

Yahoo Search

Search the web Search this site

SharePoint Page Types

Do you know in SharePoint there are two types of pages?In a SharePoint site each page you see is either a ghosted page or an unghosted page.Ghosted (Uncustomized) PagesThese are the pages stored in the severs file system but not in the database. The other important thing is these files are common to all the site collections within the SharePoint server and are generally based on the "out of the box" site definition templates. Basically they are working as template files. Ghosted pages are faster since ASP.NET parser will be used to parse them and as you might know ASP.NET parser will compile the page into an assembly on the first time it is rendered, on subsequent executions the compilation is skipped since the assembly is already there.When ghosted pages are modified by SharePoint designer then they will become unghosted pages, and then SharePoint will start using that file in the future not the file stored in the file system. A common example for this would be the “default…

Protect HTML Files

Recently I came up with a requirement to protect a website which was created using HTML. When searching over the internet a team member of mine found a nice software called HTML Guard.This software is encoding the source of the site so the users will not be able to see the code behind the site. Using this tool you can even block a site to a particular domain. Even the site is downloaded it will not properly run.The best thing is this has a free version so we can use the full set of features without paying (A small message will come on the top right corner saying the site is encoded by using the tool). This software is by WulfSoft, thanks guys you have done a good job.Try out yourself and see.

Reading and Writing to Excel Files

Even though I posted similar 2 articles in 2008, the code of that article was having few errors. So thought to put more complete post on this.The code will read an Excel file using an OleDbConnection and will write the same data back to another Excel file. This will explain how to read and write to Excel files. One thing to remember when running this code is to make sure the source Excel file is open. Otherwise you will get an error similar to “External table is not in the expected format.”Also note that there are few connection string parameters you can use while opening Excel files.HDR = Yes – Use when first row contains column headers.HDR = No  - Use when first row contains data.Excel xx.x – Use the following Table as a guide.Parameter ValueExcel VersionExcel 12.0Excel 2007 (Released in 2007)Excel 11.0Excel 2003 (Released in 2003)Excel 10.0Excel XP (Released in 2001)Excel 9.0Excel 2000 (Released in 1999)Excel 8.0Excel 97 (Released in 1997)IMEX=1 – Use this when you want to treat al…

Project has Stopped Working

If you create a .NET application to use SQL CE database when you try to run your application on a Windows Vista or Windows 7 machine you might get an error saying your application did stop working, and the error details might show that your are having a problem with System.Data.SQLServerCE.The reason for this is that your system is not having the SQL Server CE runtime in your machine. To fix it what you need to do is to install the Microsoft SQL Server Compact 3.5 Service Pack 1 on your system. You can download it from the following Microsoft link.