Sometimes Page load event not firing in asp.net

The reason for the page executing doesn't affect the page cycle, the Load event always fires when the page is executed. So, if the Page_Load doesn't run sometimes, it's because the page is cached and doesn't execute on the server. The page can be cached in the browser, in a router somewhere along the way, or on the server using server side page caching. If...

Read More

Excel Data Reader - Read Excel files in .NET (Convert Excel data to DataTable using Asp.Net)

Click here to download Excel.dll File FileStream stream = File.Open(filePath, FileMode.Open, FileAccess.Read); //1. Reading from a binary Excel file ('97-2003 format; *.xls) IExcelDataReader excelReader =ExcelReaderFactory.CreateBinaryReader(stream); //... //2. Reading from a OpenXml Excel file (2007 format; *.xlsx) IExcelDataReader excelReader...

Read More