Results 1 - 5 of 9
29 Jun 2018 29 Jun 2018 1 Comments  833 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.
20 Jul 2017 20 Jul 2017 0 Comments  3733 Views
Here Mudassar Ahmed Khan has explained with an example, how to export Grid (Html Table) data from database to CSV (Text) file in ASP.Net MVC Razor.

First the Grid (Html Table) will be populated from database using Entity Framework and then the records from the database will be exported and downloaded as Microsoft CSV (Text) file in ASP.Net MVC Razor.
30 Mar 2017 30 Mar 2017 0 Comments  11142 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  15604 Views
Here Mudassar Ahmed Khan has explained with an example, how to upload, read and display CSV file (Text File) data in ASP.Net GridView using C# and VB.Net.
CSV file is a Text file which contains Comma Separated (Comma Delimited) values. The data from a CSV file will be read and then after separating the values, a DataTable will be created which will be used to populate the ASP.Net GridView control.
27 Mar 2017 27 Mar 2017 1 Comments  17643 Views
ASP.Net  CSV  MVC
Here Mudassar Ahmed Khan has explained with an example, how to upload, read and display CSV file (Text File) data in ASP.Net MVC Razor.
CSV file is a Text file which contains Comma Separated (Comma Delimited) values. The data from a CSV file will be read and then after separating the values, the data will be populated in HTML Table (Grid) format.
Results 1 - 5 of 9