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.