title: How to input into DataTable quickly? Or save data permanently into DataTable?
body: <p>I am inputting a text file into a DataTable and then using SqlBulkCopy to copy to a Database. While BulkCopy is fast, inserting 50000+ lines into DataTable is not (around 5 mins). How do I make it efficient?</p>
  
  <p>Can I insert data into the DataTable quickly?
  If not, is there a way to save the inserted data permanently into the DataTable so I don't have to insert it every time I run the program?</p>
  
  <pre><code>    for (; i &lt; fares.Length; )
              {
                  k = i;
                  Console.WriteLine("Inserting " + k + " out of " + (fares.Length));
                  for (; i &lt;= (k + 3); i++)
                  {
                      if (i % 4 == 0)
                      {
                          for (int j = 0; j &lt; fares.Length - 1; j++)
                          {
                              {
                                  int space = fares[i].IndexOf(" ");
                                  startStation = fares[i].Substring(0, space);
  
                                  endStation = fares[i].Substring(space + 1, fares[i].Length - space - 1);
  
                              }
                          }
                      }
  
                      else if (i % 4 == 1)
                      {
                          valueFare = fares[i];
                      }
                      else if (i % 4 == 2)
                      {
                          standardFare = fares[i];
  
                      }
                      else if (i % 4 == 3)
                      {
                          time = int.Parse(fares[i]);
                      }
  
  
                  }
  
                  faresDT.Rows.Add(startStation, endStation, valueFare, standardFare, time);
  </code></pre>