c# read csv file save to database dynamically

BlackSwan answered on April 28, 2022 Popularity 5/10 Helpfulness 1/10

answer c# read csv file save to database dynamically

c# read csv file save to database dynamically

Comment

  private readonly DataTable dt = new DataTable();

        /// <summary>
        /// Read CSV file and save to DataTable dynamically
        /// </summary>
        /// <param name="xmlFilePath"></param>
        /// <param name="csvFilePath"></param>
        /// <returns></returns>
        public DataTable Read(string xmlFilePath, string csvFilePath)
        {
            try
            {
                var headrs = File.ReadLines(csvFilePath).First().Split(',');
                foreach (var item in headrs)
                {
                    dt.Columns.Add(item.ToString(), typeof(string));
                }

                string[] lines = File.ReadAllLines(csvFilePath);
                foreach (string line in lines.Skip(1))
                {
                    string[] columns = line.Split(',');
                    dt.Rows.Add(columns);

                }

                return dt;
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }

Popularity 5/10 Helpfulness 1/10 Language csharp

Source: Grepper

Tags: c# csv database file save

Link to this answer
Share Copy Link

Contributed on Apr 28 2022

BlackSwan

0 Answers Avg Quality 2/10

c# read csv file save to database dynamically

Contents

More Related Answers

c# read csv file save to database dynamically

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.