Here Mudassar Ahmed Khan has explained with an example, how to upload, read and display Excel file data using WebGrid in ASP.Net MVC Razor.

The uploaded Excel file data will be read using OLEDB library into a DataSet and then the DataSet will be used to populate WebGrid in ASP.Net MVC Razor.

Here Mudassar Ahmed Khan has explained with an example, how to display Excel file in Web Page in ASP.Net using C# and VB.Net.

The Excel File will be read into a DataTable using OLEDB and ADO.Net and the DataTable will be used to display the Excel File in ASP.Net GridView.

Here Mudassar Ahmed Khan has explained with an example, how to add (insert) Please Select Option (Item) in ComboBox (DropDownList) in Windows Forms Application using C# and VB.Net.

First a DataTable will be populated from database and then the Please Select Option (Item) will be added to it, finally the ComboBox will be populated from DataTable in Windows Forms Application using C# and VB.Net.

Here Mudassar Ahmed Khan has explained with an example, how to read Excel file directly from FileUpload control without Saving file in ASP.Net using C# and VB.Net.

When the Excel file is uploaded, the Excel File data is available in the InputStream property of the FileUpload control.

Using ClosedXml library, the Excel file data can be easily read from the InputStream property.