how can i store data from csv file to sql database in asp.net

Question

in my project i have existing csv file and all they have up to 20 lak records. and they all i store in my sql database. so plz help me how can i do this. i use sql bulk insert query but they didn't run in asp.net

Answer 1

ASP.NET itself won't import your records.

For one shot imports you should use the BCP command line utility with a format file that specifies the formatting of your CSV and maps the fields in your data file to the fields in the database. This link helped me, but there are plenty of resources out there if you Google bcp import csv.