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.

Here Mudassar Ahmed Khan has explained with an example, how to bulk import CSV file data into SQL Server database using SqlBulkCopy in ASP.Net using C# and VB.Net.

The CSV file will be uploaded and its data will be read into a DataTable and the DataTable data will be inserted into database using SqlBulkCopy in ASP.Net.

Here Mudassar Ahmed Khan has explained with an example, how to highlight GridView Row based on some condition in ASP.Net using C# and VB.Net.

A loop will be executed and values of each GridView Row will be checked, then based on some condition the GridView Row will be highlighted by changing its Background color.

Here Mudassar Ahmed Khan has explained with an example, how to populate (bind) WebGrid using ADO.Net in ASP.Net MVC Razor.

Inside the Controller, the records from the Database Table will be fetched using traditional ADO.Net method i.e. using SqlConnection, SqlCommand, SqlDataAdapter, etc.

The fetched records will be populated into a DataSet which will be ultimately used to populate the WebGrid in ASP.Net MVC Razor.