How to upload and save csv file

use SqlBulkCopy available in .net core

using (StreamReader sr = new StreamReader(File.OpenRead("C:\\Resources\\Employee.txt")))
{
string file = sr.ReadToEnd();
records = new List<string>(file.Split('\n'));
}
List emplist = new List();
foreach (string record in records)
{
Employee emp = new Employee();
string[] textpart = record.Split('|');
emp.EmpId = textpart[0];
emp.EmpName = textpart[1];
emp.Salary = Convert.ToDecimal(textpart[2]);
emplist.Add(emp);
}
var copyParameters = new[]
{
nameof(Employee.EmpId),
nameof(Employee.EmpName),
nameof(Employee.Salary)
};
using (var sqlCopy = new SqlBulkCopy(connectionstring))
{
sqlCopy.DestinationTableName = "[Employee]";
sqlCopy.BatchSize = 500;
using (var reader = ObjectReader.Create(emplist, copyParameters))
{
sqlCopy.WriteToServer(reader);
}
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Harsh Shah5y ago
Hi,

please refer to the below link...

https://www.c-sharpcorner.com/UploadFile/8c19e8/uploading-and-importing-csv-file-to-sql-server/#:~:text=After%20creating%20the%20database%2C%20go,the%20user%20imports%20the%20file.
Sachin Singh5y ago
use SqlBulkCopy available in .net core
using (StreamReader sr = new StreamReader(File.OpenRead("C:\\Resources\\Employee.txt")))
            {

                string file = sr.ReadToEnd();
                records = new List<string>(file.Split('\n'));
            }


            List emplist = new List();

            foreach (string record in records)
            {
                Employee emp = new Employee();
                string[] textpart = record.Split('|');
                emp.EmpId = textpart[0];
                emp.EmpName = textpart[1];
                emp.Salary = Convert.ToDecimal(textpart[2]);
                emplist.Add(emp);

            }


            var copyParameters = new[]
             {
                        nameof(Employee.EmpId),
                        nameof(Employee.EmpName),
                        nameof(Employee.Salary)

                    };


            using (var sqlCopy = new SqlBulkCopy(connectionstring))
            {
                sqlCopy.DestinationTableName = "[Employee]";
                sqlCopy.BatchSize = 500;
                using (var reader = ObjectReader.Create(emplist, copyParameters))
                {
                    sqlCopy.WriteToServer(reader);
                }
            }


        }