private IEnumerable <QueryData> importReadFile(String filename)
{
string[] contents;
contents = File.ReadAllLines(Path.ChangeExtension(filename, ".csv"));
//Remove the file path and extension from the name for the group name
string title = Path.GetExtension(filename);
importfilename = filename.Substring(0, filename.Length - title.Length);
int filepathend = importfilename.LastIndexOf('\\');
importfilename = importfilename.Substring(filepathend + 1); //+1 to account for the '\'
//Import the file to QueryData entries.
SQLMan.CreateTable(importfilename);
return(contents.Select(line =>
{
string[] data = line.Split(',');
return new QueryData(data[0], data[1], data[2], data[3], data[4]);
}));
}
