Category - Excel
Results 1 - 5 of 52
Here Mudassar Ahmed Khan has explained with an example, how to Import (Insert) Excel file data into Database using SqlBulkCopy in ASP.Net MVC Razor.

The uploaded Excel file data will be read using OLEDB library and the read data will be inserted into SQL Server database using SqlBulkCopy.

SqlBulkCopy class as the name suggests does bulk insert from one source to another and hence all rows from the Excel sheet can be easily read and inserted using the SqlBulkCopy class.
Here Mudassar Ahmed Khan has explained with an example, how to upload, read and display Excel file data using OLEDB in ASP.Net MVC Razor.
The uploaded Excel file data will be read using OLEDB library and the read data will be displayed in View in HTML Table (Grid) format.
Here Mudassar Ahmed Khan has explained with an example, how to export HTML string to Microsoft Excel file in ASP.Net using C# and VB.Net.
Here Mudassar Ahmed Khan has explained with an example, how to export Grid (Html Table) data from database to Excel file in ASP.Net MVC Razor.
First the Grid (Html Table) will be populated from database using Entity Framework and then the records from the database will be 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 export multiple DataTables of a DataSet to multiple Excel Sheets (Worksheets) in ASP.Net using C# and VB.Net.
Records of each DataTable in the DataSet will be exported to a different Sheet (Worksheet) of an Excel file using ClosedXml library in ASP.Net.
Results 1 - 5 of 52