ASPSnippets.com
Category - SqlBulkCopy
Results 1 - 5 of 13
14 May 2018 14 May 2018 0 Comments  597 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  534 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  2716 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 3 Comments  14237 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 0 Comments  9950 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.
Results 1 - 5 of 13