Category - Excel
Results 1 - 5 of 103
18 Jun 2020 18 Jun 2020 0 Comments  3474 Views
Here Mudassar Ahmed Khan has explained with an example, how to import (insert) Excel file data into Database using SqlBulkCopy in ASP.Net Core MVC.

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.
17 Jun 2020 17 Jun 2020 0 Comments  5997 Views
ASP.Net  Excel  Tips  OLEDB
Here Mudassar Ahmed Khan has explained how to download the Microsoft.ACE.OLEDB.12.0 provider for 32bit and 64bit.

In order to download the Microsoft.ACE.OLEDB.12.0 provider for 32bit and 64bit, you will need to download the Microsoft Access Database Engine 2010 Redistributable file.
08 May 2020 08 May 2020 0 Comments  1445 Views
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.
06 Sep 2019 06 Sep 2019 0 Comments  15028 Views
Here Mudassar Ahmed Khan has explained with an example, how to download (save) VARBINARY data as File from SQL Server database table in ASP.Net using C# and VB.Net.

Files such as Images, PDF, Word or Excel Documents, Audio and Video files will be saved as VARBINARY data in SQL Server database table and later the VARBINARY data will be converted back to the file and downloaded in ASP.Net using C# and VB.Net.
06 Sep 2019 06 Sep 2019 0 Comments  8741 Views
Here Mudassar Ahmed Khan has explained with an example, how to download (save) VARBINARY data from SQL Server database table using Entity Framework in ASP.Net MVC Razor.

Files will be uploaded and then will be saved (inserted) to database table as VARBINARY data. The file in VARBINARY data format will be retrieved and displayed in HTML Grid (Table) consisting of a Link for downloading the VARBINARY data as file from database.
Results 1 - 5 of 103