title: Passing datatable to a stored procedure
body: <p>I have a datatable created in C#.</p>
  
  <pre><code>using (DataTable dt = new DataTable())
  {
      dt.Columns.Add("MetricId", typeof(int));
      dt.Columns.Add("Descr", typeof(string));
      dt.Columns.Add("EntryDE", typeof(int));
      foreach (DataGridViewRow row in dgv.Rows)
      {
          dt.Rows.Add(row.Cells[1].Value, row.Cells[2].Value, row.Cells[0].Value);
      }
  
      // TODO: pass dt
  }
  </code></pre>
  
  <p>And I have a stored procedure</p>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE PROCEDURE [dbo].[Admin_Fill] 
  -- Add the parameters for the stored procedure here
  @MetricId INT,
  @Descr VARCHAR(100),
  @EntryDE VARCHAR(20)
  </code></pre>
  
  <p>What I want is to pass the datatable to this stored procedure, how?</p>