Category - SqlBulkCopy
18 Jun 2020 18 Jun 2020 0 Comments  33928 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  96189 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  28828 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  33394 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  23575 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.
28 Dec 2017 28 Dec 2017 0 Comments  21921 Views
Here Mudassar Ahmed Khan has explained with an example, how to use the SqlBulkCopy class in ASP.Net MVC Razor.

This article will illustrate how to import (insert) data from Excel file into SQL Server database table 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 table 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 into SQL Server database table using the SqlBulkCopy class.
08 May 2017 08 May 2017 5 Comments  53894 Views
Here Mudassar Ahmed Khan has explained with an example, how to import (insert) data from Excel file into SQL Server database table 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 table 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 into SQL Server database table using the SqlBulkCopy class.
30 Mar 2017 30 Mar 2017 3 Comments  40593 Views
Here Mudassar Ahmed Khan has explained with an example, how to import (insert) CSV file (Text File) data into Database using SqlBulkCopy in ASP.Net MVC Razor.
The uploaded CSV file (Text File) data will be read using File class 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 DataTable can be easily read and inserted using the SqlBulkCopy class.
27 Mar 2017 27 Mar 2017 0 Comments  28804 Views
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.
27 Mar 2016 27 Mar 2016 0 Comments  12555 Views
Here Mudassar Ahmed Khan has explained with an example, how to solve the following error (exception) that occurs in the WriteToServer function when SqlBulkCopy is used along with SqlTransaction class.
System.InvalidOperationException: Unexpected existing transaction.
24 Mar 2016 24 Mar 2016 0 Comments  48454 Views
Here Mudassar Ahmed Khan has explained with an example, how to use SqlBulkCopy to insert bulk data to database with Transaction i.e. Commit and Rollback feature in ASP.Net using C# and VB.Net.
SqlBulkCopy will be used along with the SqlTransaction class in order to perform Bulk Insert with Transaction i.e. Commit and Rollback feature in ASP.Net.
25 Jan 2015 25 Jan 2015 8 Comments  116517 Views
Here Mudassar Ahmed Khan has explained how to bulk copy data from DataTable (DataSet) to SQL Server database Table using SqlBulkCopy in C#, VB.Net and ASP.Net.
27 Dec 2014 27 Dec 2014 14 Comments  240566 Views
Here Mudassar Ahmed Khan has explained how to perform Bulk Insert records and Update existing rows if record exists using C# and VB.Net.

SqlBulkCopy as the name suggest is for copying (inserting) bulk records and it cannot perform update operation. Hence comes Table Valued Parameter to the rescue, which allows us to pass multiple records using a DataTable to a Stored Procedure where we can do the processing.
03 Oct 2014 29 Jun 2018 7 Comments  148898 Views
Here Mudassar Ahmed Khan has explained how to import / upload CSV file data to SQL Server database in ASP.Net using C# and VB.Net.

The CSV file data will be inserted into SQL Server database table using the SqlBulkCopy class.
08 Jun 2014 08 Jun 2014 3 Comments  55975 Views
Here Mudassar Ahmed Khan has explained how to use SqlBulkCopy to insert bulk data from GridView to database in ASP.Net.

SqlBulkCopy class as the name suggests does bulk insert from one source to another and hence multiple selected rows from the GridView can be easily read and inserted in SQL Server database table using the SqlBulkCopy class.
27 May 2014 03 Oct 2018 16 Comments  224646 Views
Here Mudassar Ahmed Khan has explained how to insert data from Excel sheet into SQL Server database table using SqlBulkCopy in C# and VB.Net.

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.