public void CsvHelper() { var tr = TestData.GetTextReader(); var csv = new CsvHelper.CsvDataReader(new CsvHelper.CsvReader(tr, new CsvHelper.Configuration.CsvConfiguration(CultureInfo.CurrentCulture))); var dr = (IDataReader)csv; while (dr.Read()) { for (int i = 0; i < dr.FieldCount; i++) { var s = dr.GetString(i); } } }
public static void DapperBinderTest() { var tr = new StringReader(CsvData); var csv = new CsvHelper.CsvReader(tr, new CsvHelper.Configuration.CsvConfiguration(CultureInfo.InvariantCulture)); var dr = new CsvHelper.CsvDataReader(csv); var st = dr.GetSchemaTable(); var parser = dr.GetRowParser <DataRecord>(); while (dr.Read()) { var a = dr.GetValue(0); var b = dr.GetValue(1); // is there a way to make dapper // bind the empty field to float? Value? var row = parser(dr); } }
private void DisplayRecords() { try { using (var reader = new StreamReader(csvFile)) using (var csv = new CsvHelper.CsvReader(reader)) { using (var dr = new CsvHelper.CsvDataReader(csv)) { var dt = new DataTable(); dt.Load(dr); dgvTable.DataSource = dt; } } } catch (Exception) { throw; } }