private DataTable ReadAsDataTable(string file, bool hasHeader, char seperator)
{
DataTable dt = new DataTable();
StreamReader reader = new StreamReader(file);
string line = string.Empty;
string[] data = null;
int counter = 0;
while (reader.Peek() != -1)
{
line = reader.ReadLine();
data = line.Split(seperator);
if (hasHeader)
{
if (counter == 0)
{
foreach (string item in data)
{
dt.Columns.Add(item);
}
}
else
dt.Rows.Add(data);
}
else
dt.Rows.Add(data);
counter++;
}
reader.Close();
return dt;
}
Calling function
DataTable result = ReadAsDataTable(@"C:\temp\data.csv", true, ',');
{
DataTable dt = new DataTable();
StreamReader reader = new StreamReader(file);
string line = string.Empty;
string[] data = null;
int counter = 0;
while (reader.Peek() != -1)
{
line = reader.ReadLine();
data = line.Split(seperator);
if (hasHeader)
{
if (counter == 0)
{
foreach (string item in data)
{
dt.Columns.Add(item);
}
}
else
dt.Rows.Add(data);
}
else
dt.Rows.Add(data);
counter++;
}
reader.Close();
return dt;
}
Calling function
DataTable result = ReadAsDataTable(@"C:\temp\data.csv", true, ',');
Add a comment