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;
}
}
