How to skip specific line in text file to DataTable

See more:

C#

DataTable

Hi
I am reading a csv file into a sql table.

I need to skip the the first line which always starts with the string STR, eg "STR122", and the last line which is always END.

I was able ignore the substring "STR", but having problems with the substring "END".
I don't want "END" to be written into the DataTable

My code is as follows

DataTable dt = new DataTable();

     DataColumn dc = new DataColumn();

     bool endOfTransaction = false;

    string csvData = File.ReadAllText(filePath);
     dc.ColumnName = "Number";
     dt.Columns.Add(dc);

     foreach (string row in csvData.Split('\r'))
     {
         if (!string.IsNullOrEmpty(row) && row.Substring(0,3) != "STR")
         {
             if ((row.Substring(0, 3) == "END"))
             {
                 Console.WriteLine("End of file");
                 endOfTransaction = true;
             }
             else
             {
                 dt.Rows.Add(row);
             }
         }
     }

     SqlBulkCopy bc = new SqlBulkCopy(con,SqlBulkCopyOptions.TableLock, null);
     bc.DestinationTableName = "bulkAff_EmpNumbers";
     bc.WriteToServer(dt);
     bc.Close();


     cmd.CommandType = CommandType.StoredProcedure;
     cmd.CommandText = "[dbo].[chuck_doQAFF_C#]";
     cmd.Parameters.Add(new SqlParameter("@DebugMode", 1));
     cmd.CommandTimeout = 50000;

     SqlDataReader extractReader = cmd.ExecuteReader();

     WriteToFile file = new WriteToFile();
     file.parseResultSetToFile(extractReader);