Here Mudassar Ahmed Khan has explained with an example, how to read Excel File (xls & xlsx) data 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 and displayed on Web Page using GridView in ASP.Net using C# and VB.Net.

Here Mudassar Ahmed Khan has explained with an example, how to populate jQuery DataTable using WebMethod (PageMethod) and AJAX in ASP.Net with C# and VB.Net.

First a jQuery AJAX call will be made to a WebMethod (PageMethod) on Server Side and the WebMethod (PageMethod) will return the Data in JSON format.

Finally, the returned JSON data will be used on Client Side to populate the jQuery DataTable in ASP.Net with C# and VB.Net.

Here Mudassar Ahmed Khan has explained with an example, how to display from Database Table in GridView (Grid) format in ASP.Net Core MVC.

The data from the SQL Server Database Table will be fetched using Entity Framework and finally the fetched data is displayed in Grid (GridView) format in ASP.Net Core MVC.

Here Mudassar Ahmed Khan has explained with an example, how to add new Row to existing DataTable using C# and VB.Net.