/// <summary>
/// Read in a , sepearated ascii file , assumes file is in the same format as the table
/// </summary>
/// <param name="Filename"></param>
public virtual DataTable LoadFromFile(ArrayList FieldDefs, string Filename)
{
DataTable ImporTable = BuildImportTable(FieldDefs);
CSVtoDataTable tmp = new CSVtoDataTable(ImporTable);
tmp.LoadfromFile(Filename,System.Text.Encoding.UTF8,true);
return ImporTable;
}
/// <summary>
/// Import a csv file to a simple string based datatable
/// </summary>
/// <param name="filename"></param>
/// <param name="incHeader"></param>
/// <param name="enc"></param>
/// <returns></returns>
public static DataTable CovertCSVtoDataTable(string filename, System.Text.Encoding enc, bool incHeader)
{
DataTable aTable = new DataTable(System.IO.Path.GetFileNameWithoutExtension(filename).Replace(" ", "_"));
for(int i = 0 ; i <= 150; i++)
{
aTable.Columns.Add(new DataColumn("Field"+i.ToString(), Type.GetType("System.String")));
}
CSVtoDataTable tmp = new CSVtoDataTable(aTable);
tmp.LoadfromFile(filename,enc,incHeader);
return aTable;
}