Hidden Worksheet in an Excel File

I am automating a report where I have to pull data from excel file to database. When doing this, sometimes I get an error keep telling me that I get the wrong report format.After debug on my program, I found out that some of the excel files do have a few hidden worksheet with different report format. That’s why I keep getting this error.Assume that only visible worksheet will be used to pull data into database, so I need to know which worksheet is visible and which is not. This can be done by using Worksheet.Visible property,...

Comparison of ADO .NET DataSet and ADO RecordSet

1. Number of Tables. Dataset can hold several tables which are called data tables at once. A dataset also stores relationships and constraints on the tables. For example, if a dataset contains a table about customers and another table about customers’ product, it could also contain a relationship connecting each row of the customers table with the corresponding rows of the product table. A recordset contains only the rows returned by the corresponding query. For example, if a recordset want to retrieve data from several...

Access is denied in ASP .NET

Description: An unhandled exception occurred during the execution of the current web request. Exception Details: System.UnauthorizedAccessException: Access is denied. ASP.NET is not authorized to access the requested resource. Solution: 1. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity...

Timeout expired error in ASP .NET

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Had you seen this Timeout expired error in your application before?I have an application which will do a lot of database reads and updates. While the application is running to update records into database, suddenly I am getting this error.I tried to add max pool size to a bigger size (Max Pool Size, default = 100), but in the end I still getting...

Excel Drop Down List

When inputting data into Excel, often you will find yourself have to type the same data into cells. And now, in Excel, you can create a drop down list for the cell, instead of typing the same data over and over again. A drop down list in Excel makes data entry easier, avoids typo error in a cell, and limit entries to certain items.Next, I will show you how to create a drop down list step by step.Imagine that we want...

How to Highlight a row in DataGrid

In this post I will discuss about how to highlight a row in datagrid when mouse moves over a row, by using onmouseover and onmouseout javascript events.Datagrid has two events, ItemCreated and ItemDataBound, which allow us to access the data items and create an event handler for the events. ItemCreated event is raised when an item in the datagrid control is created, while ItemDataBound event is raised after an item in the datagrid control is created.In this example, I will work with the ItemDataBound event, adding handlers for...