ExtensionsDataTable.cs

using Microsoft.VisualBasic.FileIO;
using sage.addons.idatos.Negocio.Clases;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Sage.ES.S50.Extensions
{
    public static class ExtensionsDataTable
    {
        public static void ImportCSV(this DataTable dataTable, string csvFile, string separator = ";", bool hasFieldsEnclosedInQuotes = true, bool primeraFilaDatos = true)
        {
            try
            {
                bool assignedTypes = false;
                using (TextFieldParser csvReader = new TextFieldParser(csvFile))
                {
                    csvReader.SetDelimiters(separator);
                    csvReader.HasFieldsEnclosedInQuotes = hasFieldsEnclosedInQuotes;
                    string[] colFields = csvReader.ReadFields();
                    foreach (string column in colFields)
                    {
                        DataColumn dataColumn = new DataColumn(column)
                        {
                            AllowDBNull = true
                        };
                        dataTable.Columns.Add(dataColumn);
                    }
                    while (!csvReader.EndOfData)
                    {
                        string[] fieldData = csvReader.ReadFields();
                        List<object> fieldList = new List<object>();
                        for (int i = 0; i <= fieldData.Length - 1; i++)
                        {
                            //dataTable.Columns[i].DataType = Type(int)
                            if (int.TryParse(fieldData[i].ToString(), out int resultInt))
                            {
                                fieldList.Add(resultInt);
                                if (!assignedTypes)
                                {
                                    dataTable.Columns[i].DataType = typeof(int);
                                }
                            }
                            else if (DateTime.TryParse(fieldData[i].ToString(), out DateTime resultDateTime))
                            {
                                fieldList.Add(resultDateTime);
                                if (!assignedTypes)
                                {
                                    dataTable.Columns[i].DataType = typeof(DateTime);
                                }
                            }
                            else if (fieldData[i].ToString() == "")
                            {
                                fieldList.Add(null);
                            }
                            else
                            {
                                fieldList.Add(fieldData[i]);
                            }
                        }

                        dataTable.Rows.Add(fieldList.ToArray());
                        assignedTypes = true;

                    }
                    //foreach (var line in csv.Split(new[] { Environment.NewLine }, StringSplitOptions.None))
                    //{
                    //    if (!readHeader)
                    //    {
                    //        foreach (var c in line.Split(separator))
                    //            dataTable.Columns.Add(c);
                    //    }
                    //    else
                    //    {
                    //        dataTable.Rows.Add(line.Split(separator));
                    //    }
                    //}
                }
            }
            catch (Exception)
            {

            }
        }
  
        public static void ImportCSV_Idatos(this DataTable dataTable, string csvFile, List<CargarDatos.stInfoFields> InfoFields, string separator = ";", bool hasFieldsEnclosedInQuotes = true, bool primeraFilaDatos = true)
        {
            try
            {
                using (TextFieldParser csvReader = new TextFieldParser(csvFile))
                {
                    csvReader.SetDelimiters(separator);
                    csvReader.HasFieldsEnclosedInQuotes = hasFieldsEnclosedInQuotes;
                    string[] colFields = csvReader.ReadFields();
                    if (primeraFilaDatos)
                    {
                        foreach (string column in colFields)
                        {
                            DataColumn dataColumn = new DataColumn(column)
                            {
                                AllowDBNull = true
                            };
                            dataTable.Columns.Add(dataColumn);
                        }
                    }
                    else
                    {
                        string abc = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";

                        for (int j = 0; j < colFields.Length; j++)
                        {
                            DataColumn dataColumn = new DataColumn(abc)
                            {
                                AllowDBNull = true
                            };
                            dataTable.Columns.Add(abc.Substring(j, 1));
                        }
                    }

                    while (!csvReader.EndOfData)
                    {
                        string[] fieldData = (primeraFilaDatos ? csvReader.ReadFields() : colFields);
                        primeraFilaDatos = true;

                        List<object> fieldList = new List<object>();

                        for (int i = 0; i <= fieldData.Length - 1; i++)
                        {
                            string valor = InfoFields[i].tipoColumna;
                            switch (valor)
                            {
                                case "entero":
                                    fieldList.Add(fieldData[i]);
                                    dataTable.Columns[i].DataType = typeof(Int32);
                                    break;
                                case "numerico":
                                    fieldList.Add(fieldData[i]);
                                    dataTable.Columns[i].DataType = typeof(double);
                                    break;
                                case "logico":
                                    if (string.IsNullOrEmpty(fieldData[i]))
                                    {
                                        fieldList.Add(false);
                                    }
                                    else
                                    {
                                        fieldList.Add(fieldData[i]);
                                    }
                                    dataTable.Columns[i].DataType = typeof(bool);
                                    break;
                                case "fecha":
                                    fieldList.Add(fieldData[i]);
                                    dataTable.Columns[i].DataType = typeof(DateTime);
                                    break;
                                default:
                                    if (fieldData[i].ToString() == "")
                                    {
                                        fieldList.Add(null);
                                    }
                                    else
                                    {
                                        fieldList.Add(fieldData[i]);
                                    }
                                    break;
                            }
                        }

                        dataTable.Rows.Add(fieldList.ToArray());
                    }
                }
            }
            catch (Exception)
            {

            }

        }
    }
}