I have a website project with C # language. my idea is to use the FileUpload tool of Visual Studio to import files to my application. what i need is to import a CSV file that contains dozens of data, in order to insert these data in my database.
an example is I have a table "Customer" which has the following structure:
id_custumer int IsIdentity,
name varchar (100),
surname varchar (100),
locality varchar (200)
as I said, I have created a csv file that contains various customer data. I want, through FileUpload, import this file into my application and adding the data to my table "customer".
any idea how to do this?