Category - SqlBulkCopy
Results 1 - 5 of 16
18 Jun 2020 18 Jun 2020 0 Comments  2400 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.
04 Oct 2018 04 Oct 2018 3 Comments  57106 Views
Here Mudassar Ahmed Khan has explained with an example, how to import Excel data to SQL Server Database in ASP.Net using C# and VB.Net.

The Excel Sheet data will be read into a DataTable and then then DataTable data will be imported into SQL Server Database using SqlBulkCopy in ASP.Net.
29 Jun 2018 29 Jun 2018 1 Comments  17493 Views
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.
14 May 2018 14 May 2018 0 Comments  20682 Views
Here Mudassar Ahmed Khan has explained with an example, how to insert multiple rows (records) from GridView to database in ASP.Net using C# and VB.Net.

The GridView rows will be copied to a DataTable and the DataTable will be later used for bulk inserting records to SQL Server Database using SqlBulkCopy class.
14 May 2018 14 May 2018 0 Comments  14311 Views
Here Mudassar Ahmed Khan has explained with an example, how to insert multiple selected (checked) rows (records) from GridView to database in ASP.Net using C# and VB.Net.

The GridView rows will be selected using CheckBoxes and the selected rows (records) will be inserted into a DataTable which will be later used for bulk inserting records to SQL Server Database using SqlBulkCopy class.
Results 1 - 5 of 16