title: import textfile into SQL table
body: <p>I have a bunch of 2 line (with header row) '|' delimited text files.  I need to import this into a specific SQL table and I'm having a hard time with the command.</p>
  
  <pre><code>string sqltable = ("dbo.SLT_C" + "60" + "Staging");
  string[] importfiles= Directory.GetFiles(@"K:\jl\load\dest", "*.txt")
  SqlConnection con = new SqlConnection("Data Source=" + "Cove" + ";Initial Catalog=" + "GS_Ava_MCase"+ ";Integrated Security=" + "SSPI");
  con.Open();
  foreach (string importfile in importfiles)
  {
  
  }
  </code></pre>
  
  <p>or maybe I am going about this the whole wrong way.</p>