title: Import text file into SQL Server table using SqlBulkCopy in C# (How to use it?)
body: <p>I'm new to coding, I'm trying to import a small text file into a SQL Srever table using <code>SqlBulkCopy</code> class, but I failed. It's an exercise, but it's very important for me.</p>
  
  <p>This is the only code I've done. Please some body can  help me to find what next.</p>
  
  <pre><code>string CadenaCon = "Data Source=CH-PC;Initial Catalog=Importar;Integrated Security=True";
  SqlConnection Con = new SqlConnection(CadenaCon); 
  </code></pre>
  
  <p>The File path is 'C:\ok\test1.txt'</p>