title: Passing DataTable to stored procedure as an argument
body: <p>I have a data table created in C#.</p>
  
  <pre><code>DataTable dt = new DataTable();
  dt.Columns.Add("Name", typeof(string));
  dt.Columns.Add("Age", typeof(int));
  
  dt.Rows.Add("James", 23);
  dt.Rows.Add("Smith", 40);
  dt.Rows.Add("Paul", 20);
  </code></pre>
  
  <p>I want to pass this to the following stored procedure.</p>
  
  <pre class="lang-sql prettyprint-override"><code>CREATE PROCEDURE  SomeName(@data DATATABLE)
  AS
  BEGIN
      INSERT INTO SOMETABLE(Column2,Column3)
      VALUES(......);
  END
  </code></pre>
  
  <p>My question is : How do we insert those 3 tuples to the SQL table ?  do we need to access the column values with the dot operator ? or is there any other way of doing this?</p>