Category - SqlBulkCopy
Results 11 - 15 of 15
25 Jan 2015 25 Jan 2015 6 Comments  79444 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  197308 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 6 Comments  122677 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  46866 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  193679 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.
Results 11 - 15 of 15