private TableInfo GetStructure(LumenWorks.Framework.IO.Csv.CsvReader reader) { var res = new TableInfo(null); if (HasHeaders) { foreach (string col in reader.GetFieldHeaders()) { res.Columns.Add(new ColumnInfo(res) { CommonType = new DbTypeString(), DataType = "nvarchar", Name = col }); } } else { for (int i = 1; i <= reader.FieldCount; i++) { res.Columns.Add(new ColumnInfo(res) { CommonType = new DbTypeString(), DataType = "nvarchar", Name = String.Format("#{0}", i) }); } } return(res); }
private void CountActivities(CsvReader csv) { int fieldCount = csv.FieldCount; string[] headers = csv.GetFieldHeaders(); while (csv.ReadNextRecord()) { string activityName = csv[(int)Fields.ActivityName]; if (_activityCount.ContainsKey(activityName)) { _activityCount[activityName]++; } else { _activityCount.Add(activityName, 1); } } }
private string SerializeCsv(CsvReader csv) { string results = ""; int fieldCount = csv.FieldCount; string[] headers = csv.GetFieldHeaders(); while (csv.ReadNextRecord()) { for (int i = 0; i < fieldCount; i++) { results += csv[i] + " "; } results += "\n"; } return(results); }