title: Passing c# DataTable as a parameter to stored procedure in MS SQL Server 2008
body: <p>I want to pass a <strong>DataDable</strong> to a <strong>stored procedure as parameter</strong> cointaning the columns below:</p>
  
  <pre><code>Supp_Id          int
  Del_Methode_Id   int
  Ord_Ammount      int
  Promo_Id         int
  Discount_Ammount Money
  </code></pre>
  
  <p>Now I want to use this datatable in stored procedure and want to declare a cursor on it. And use that cursor to insert values into the database table sequentially.</p>
  
  <p>Please tell me how to <strong>declare datatable parameter</strong> in stored procedure and then using <strong>cursor</strong> on that <strong>parameter</strong> ?</p>