Beispiel #1
0
        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);
                }
            }
        }
Beispiel #2
0
        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);
            }
        }
Beispiel #3
0
        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;
            }
        }