.txt / csv Header (FirstLine) to Array

Hello BASCHDI,

Well, you can do so using Regex.Split() method, but this way you will fail to maintain the consistency of data. There are chances of you might mess up the data for a particular SKU with the details of some other SKU. Hence I still would suggest you to use Oledb Reader.

Below is a solution for you to import a text file directly into a DataTable:
---------------------------------------------------------------------

static DataTable ImportDelimitedFile(DataTable dt, string filename, string delimiter)  
{
 StreamReader file = new StreamReader(filename);    string line;
 while ((line = file.ReadLine()) != null)  {  if (line.Trim().Length > 0)  {
 string[] columns = line.Split(delimiter.ToCharArray(), StringSplitOptions.None);
 if (dt.Columns.Count == 0)
{
  foreach (string str in columns)
  {  dt.Columns.Add(str); }
 continue;
 }  

else  
{
 DataRow dr = dt.NewRow();
 for (int i = 0; i < columns.Length;i++ )  
   {
 dr[i] = columns[i];
   }
   dt.Rows.Add(dr);
  }
}
}
return dt;
}

---------------------------------------------------------------------------

Use it like this:
------------------------------------------------------------
DataTable dt = new DataTable();
dt = ImportDelimitedFile(dt,"D:\\testData.txt", " ");
myDataGridView.DataSource=dt;

----------------------------------------------------------------------------------

Add References to System.Data.Oledb, System.Data & System.IO if haven't done yet.


Mark this as answer if it helps.
Cheers!