Here Mudassar Ahmed Khan has explained with an example, how to export DataSet or DataTable to Excel file in ASP.Net Core MVC.

The data from the database is fetched using ADO.Net into a DataTable.

Then the DataTable is exported and downloaded as Microsoft Excel file using ClosedXML Excel Library which is a wrapper for OpenXml Excel library.

Here Mudassar Ahmed Khan has explained with an example, how to use a DataSet or DataTable as Model in View in ASP.Net Core MVC.

Though it is not a good practice to use to use DataSet or DataTable as Model in View in MVC Core architecture, thus user’s please make a note that this is just an informative article and does not recommend to use DataSet or DataTable as Model in View in ASP.Net Core MVC.

Here Mudassar Ahmed Khan has explained with an example, how to populate jQuery DataTable using Entity Framework using C# in ASP.Net MVC Razor.

The data from the SQL Server Database will be populated using Entity Framework in C#.

An HTML Table will be applied the jQuery DataTables plugin and then using a jQuery AJAX call the data will be fetched from the Controller and will be assigned to the jQuery DataTables plugin in ASP.Net MVC Razor.

Here Mudassar Ahmed Khan has explained with an example, how to use jQuery DataTables plugin in ASP.Net Core MVC.

The data from the SQL Server Database will be populated using Entity Framework.

An HTML Table will be applied the jQuery DataTables plugin and then using a jQuery AJAX call the data will be fetched from the Controller and will be assigned to the jQuery DataTables plugin in ASP.Net Core MVC.