SqlBulkCopy Articles

Category - SqlBulkCopy

08 May 2017 Mudassar Khan 0 Comments 3275 Views

ASP.Net Excel SQL Server SqlBulkCopy MVC

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 Mudassar Khan 0 Comments 2831 Views

ASP.Net SqlBulkCopy CSV MVC

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 Mudassar Khan 0 Comments 4078 Views

ASP.Net Excel SQL Server SqlBulkCopy MVC

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 Mudassar Khan 0 Comments 2949 Views

ASP.Net Issues and Exceptions SqlBulkCopy

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 Mudassar Khan 0 Comments 9443 Views

ASP.Net SqlBulkCopy SqlTransaction

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.