DataTable dt = new
DataTable();
DataTable();
string line = String.Empty;
int i = 0;
using (StreamReader sr = File.OpenText(@path))
{
while ((line = sr.ReadLine()) != null)
{
string[] data = line.Split(‘,’);
if (data.Length > 0)
{
if (i == 0)
{
int j = 0;
foreach (var
s in data)
{
//create column
dt.Columns.Add(new DataColumn());
//add column name from first row
dt.Columns[j].ColumnName = data[j].ToString();
j++;
}
i++;
}
if (i > 1)
{
//if not first row (column name) then create
data row
DataRow row = dt.NewRow();
row.ItemArray = data;
dt.Rows.Add(row);
}
i++;
}
}
}
return dt;