IIS can not access by anonymous account

Recently I encounter an issue. Windows anonymous account can not access local IIS. The security setting in IIS is correct.

After a couple of hours searching on internet. I find the cause. That's because my IUSR_computername doesn't has the right of "log on locally". So I go to:

controlpanel -> Admin Tool -> Local Security Settings -> Local Policies -> User Rights Assignment and find that Guest group doesn't have the permission of "Log on locally". Since IUSER_computername is memeber of Guest group. It doesn't have it as well.

I removed it from Guest group and add it to User group to make this account can be log on locally.

Auth Diagnostics 1.0 is a good tool to find IIS authentication issues. It can be downloaded here

Also, there is a good guideline here to help troubleshooting such issue.

Create Template Dynamically - Part 2

In my previous blog entry: Create Template Dynamically. I mentioned a nice article on this topic. This article shows how to implement ITemplate interface to build template.

Another article, Using Templated Controls Programmatically shows how to use CompiledTemplateBuilder to do the something. Actually, CompiledTemplateBuilder class is an implement of ITemplate, in it's constructor, a method need to be passed in. And later on, it's initiateIn method will call the method to finish render task.

Create Template Dynammically

Some ASP.NET server controls, like GridView, ListView, Menu provide templates, we can use templates to partially change render behaviors of these controls. Usually we achieve this by using declarative.

However, chances are that we need to create and use templates programmatically. Here is a nice article written by Dino Esposito. Although it is written several years ago, the concept is remain unchanged.

ModalPopupExtender with PostBack and Set Focus

There is a good article about how to add postback and setfocus on ModalPopupExtender.

Check out here

Import Excel spreadsheet into SQL Server table

MVP David Hayden has written some good articles regarding the data import/export between Excel and SQL Server. They can be found in links below:

Import Excel Spreadsheet Data into SQL Server Database Table Using SqlBulkCopy

Reading and Writing Excel Spreadsheets Using ADO.NET C# DbProviderFactory

Thanks David.