🙂 İNSANLARIN EN HAYIRLISI INSANLARA FAYDALI OLANDIR 🙂

Ramazan HABER / C# RMOS / CSV to Class

1-) C# RMOS - CSV to Class (Eğer bazı değerler gelmez . office sürümünü yükseltin. misal = 2013)

 

static DataTable GetDataTableFromCsv(string path, bool isFirstRowHeader)

        {

            string header = isFirstRowHeader ? "Yes" : "No";

 

            string pathOnly = Path.GetDirectoryName(path);

            string fileName = Path.GetFileName(path);

 

            string sql = @"SELECT * FROM [" + fileName + "]";

 

            using (OleDbConnection connection = new OleDbConnection(

                      @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + pathOnly +

                      ";Extended Properties=\"Text;HDR=" + header + "\""))

            using (OleDbCommand command = new OleDbCommand(sql, connection))

            using (OleDbDataAdapter adapter = new OleDbDataAdapter(command))

            {

                DataTable dataTable = new DataTable();

                dataTable.Locale = CultureInfo.CurrentCulture;

                adapter.Fill(dataTable);

                return dataTable;

            }

        }

 

2-) aşağıdakine de bakarsın belki lazım olur.

 

https://stackoverflow.com/questions/25933786/generate-c-sharp-model-class-from-csv-file-structure

 

 2021 Ocak 18 Pazartesi
 406